rman restore

  • From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
  • To: 'oracle-l List' <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 29 Sep 2009 15:46:01 -0700

Hi all,
This is first one for me. I need to restore d/base from last night's rman hot 
backup. I also need to apply redo logs till 13:00 today to bring it to the time 
before the "accident" happened.

Do I restore backup files to disk from tape and then run the following:





STARTUP NOMOUNT

RUN
{
  # set time to just before data was lost.
  SET UNTIL TIME 'Sep 29 2009 13:00:00';
  RESTORE CONTROLFILE FROM AUTOBACKUP;
  ALTER DATABASE MOUNT;
  RESTORE DATABASE;
  RECOVER DATABASE;
}


ALTER DATABASE OPEN RESETLOGS;

Thanks,


Regards,

Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P  Please consider the environment before printing this e-mail.

Other related posts: