Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member206552
Active Contributor
0 Kudos

I played around today on a test system with backups and had a problem that could help someone.

I restored the database using POINT IN TIME. The full and incremental restore was completed, I had problems with archive logs as they get backed up to disk and then after wards to tape I could not restore them using BRTOOLS at first.

I got the error below

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of available command at 06/04/2013 13:50:55

RMAN-20215: backup set not found

RMAN-06159: error while looking up backup set

RMAN>

released channel: ORA_MAINT_DISK_1

RMAN> 2> 3>

allocated channel: dsk

channel dsk: SID=150 device type=DISK

Starting restore at 04-JUN-2013-13:50:55

released channel: dsk

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 06/04/2013 13:50:55

RMAN-20242: specification does not match any archived log in the repository

I retrieve the backup sets from tape using netbackup

Once this is completed you need to add the archives backup into the repository

rman

connect target;

catalog backuppiece '/tmp/SIDarch1.dbf.S';

cataloged backup piece

Once this is completed you can use BRRESTORE to restore the files from the backup set and apply the logs

just my thoughts

Labels in this area