USER-MANAGED Incomplete Recovery

Contents:- User managed Recovery

USER-Managed Time Based Recovery

Definitions:  Decide to perform user-managed incomplete recovery to restore the database back to its state as of half hour ago

Steps

Sql> shut immediate;

$> cp /backup/*.dbf  +data/clone/datafile/

Sql> startup mount

sql> recover database until time '2005-11-28:11:44:00';

sql> alter database open resetlogs;

now any data entered after recovery time need to be re-entered.

USER-Managed Cancel-based recovery

Here suppose

V$archive_log confirms the absence of archive log sequence. (arc_000_01.log)

Steps

Sql> shut immediate;

Sql> alter database mount;

Restore datafile from most recent backup

Sql> recover database until cancel;

(when recover database until cancel command is executed, it recovers the database until it cannot find a log file. When you prompted for the file name, enter cancel and the recovery stops at that point in time)

Sql> alter database open resetlogs;