Recover Database From Autobackup Controlfile And Backup Sets
shutdown immediate;
startup nomount;
set dbid 1519834868;
RUN
{
set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/rman/?/ctl_%F';
RESTORE CONTROLFILE FROM AUTOBACKUP;
}
ALTER DATABASE MOUNT;
run {
SET UNTIL TIME "TO_DATE('2009/05/16 2:52:00', 'YYYY/MM/DD HH24:MI:SS')";
RESTORE DATABASE;
}
run {
SET UNTIL TIME "TO_DATE('2009/05/16 2:52:00', 'YYYY/MM/DD HH24:MI:SS')";
RECOVER DATABASE;
}
ALTER DATABASE OPEN RESETLOGS;
page_revision: 1, last_edited: 1242913115|%e %b %Y, %H:%M %Z (%O ago)





