Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN restore error

AJay BAug 15 2017 — edited Aug 20 2017

Hi,

Trying to restore one of the rman monthly backup to check the tape backup consistency.

Out target is to restore 01-Feb-2017 backup. As per the backup policy on monthly basis a full backup and archive logs(morning,evening) backups taken to tape.

So, ideally if I try to restore/recover for any timestamp on that particular date, it should work but recovery process is failing with error "couldn't locate the backup piece"

Need your assistance to fix the issue and find the gaps in the backup process(from oracle and tape library side).

channel ch1: ORA-19870: error while restoring backup piece 6irrmn97_1_1

ORA-19507: failed to retrieve sequential file, handle="6irrmn97_1_1", parms=""

ORA-27029: skgfrtrv: sbtrestore returned error

ORA-19511: Error received from media manager layer, error text:

   Could not locate the backup piece '6irrmn97_1_1' on the NetWorker server 'xyz' for the client 'yzx'. Notify the backup administator. (2:9:2

failover to previous backup

Oracle Error

Thank & Regards

Ajay

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2017
Added on Aug 15 2017
36 comments
5,825 views