Outline The Steps Involved In Time Based Recovery From The Full Datab

1.	Outline The Steps Involved In Time Based Recovery From The Full Database From Hot Backup?
Answer» STARTUP MOUNT; restore database UNTIL TIME “TO_DATE(’28/12/2012 18:00:00′, ‘DD/MM/YYYY HH24:MI:SS’)”; recover database UNTIL TIME “TO_DATE(’28/12/2012 18:00:00′, ‘DD/MM/YYYY HH24:MI:SS’)”; alter database OPEN resetlogs;

Outline The Steps Involved In Time Based Recovery From The Full Database From Hot Backup?

Answer»

STARTUP MOUNT;
restore database UNTIL TIME “TO_DATE(’28/12/2012 18:00:00′, ‘DD/MM/YYYY HH24:MI:SS’)”;
recover database UNTIL TIME “TO_DATE(’28/12/2012 18:00:00′, ‘DD/MM/YYYY HH24:MI:SS’)”;
alter database OPEN resetlogs;