RMAN Target Problem

[Axr2]

Originally posted by SimonG
One final problem is that I have the db restored but now need to apply archived logs which are within another backupset to combat an error i am getting where the db is requesting archive logs as below. I used the delete input flag when backing up my archives and cannot find any documentation which describes how to recover archive logs from a backupset. Any help would be greatly received.

Originally posted by Axr2

Do a metalink search on dbms_backup_restore.restorecontrolfileto

Did you even try this?! Apparently not. If you did, you would see 3 articles pop up on Metalink based on the search criterion. The Title of Note 60545.1 says "How to extract controlfiles, datafiles, and **archived logs** from SMR backupsets without using RMAN". Scroll down to point number 5 and read for yourself.

In anycase, you shouldn't have to extract archivelog files manually for your situation. RMAN is usually intelligent enough to unravel the appropriate archivelogs for you. So how did you restore/recover the database in the first place? What were the commands you issued? If you had done a point in time recovery, you wouldn't need to be doing this manually..