1

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?

  • Finally, an intelligent question! I am beginning to despair for the quality of this site. – Gaius Feb 25 '15 at 12:49
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, privacy policy and cookie policy

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