2

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?

1
  • Finally, an intelligent question! I am beginning to despair for the quality of this site.
    – Gaius
    Feb 25, 2015 at 12:49

2 Answers 2

1

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')";
}
1

Here is the solution.

RMAN > run  
{
    ALLOCATE CHANNEL d1 DEVICE TYPE disk;
    restore archivelog all;
}

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.