I have an RMAN backup that is taken on 19th january with: BACKUP DATABASE PLUS ARCHIVELOG command. Now I need to restore Archived logs from that backupset to some other OS directory. Is there any way to extract Archived Log files from that backup?
2 Answers
You probably need to use catalog, because a long time passed since January.
rman target / catalog rman_catalog_user@rman_catalog_db
RUN
{
SET ARCHIVELOG DESTINATION TO '/oracle/temp_restore';
RESTORE ARCHIVELOG FROM TIME = "to_date('2014-01-19 19:20:00','YYYY-DD-MM HH24:MI:SS')"
UNTIL TIME = "to_date('2014-01-19 20:00:00','YYYY-DD-MM HH24:MI:SS')";
}
Here is the solution.
RMAN > run
{
ALLOCATE CHANNEL d1 DEVICE TYPE disk;
restore archivelog all;
}