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!

how to restore old archive logs - i.e. not known by the rman catalog anymo

User_H7BJ4Jun 17 2011 — edited Jun 23 2011
Hi,
I need some help :

I would like to restore archivelogs older than 2 weeks. The backup has been done by rman.
The purpose is to use these archive logs with log miner. We have 2 records which have been deleted and we want to know when , who and where.

I have restored from the backup tape the rman backup piece.
But when I try to restore the archive logs rman said

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/17/2011 15:36:33
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of archived log for thread 1 with sequence 11058 and starting SCN of 162841311 found to restore

And, effectively , the backupset (backupiece) is not known any more by the catalog (not in the list of backupset)
How can I tell that the backpset is now again available to the catalog ?

version is : Recovery Manager: Release 11.2.0.2.0 -

Thanks for help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2011
Added on Jun 17 2011
3 comments
1,027 views