Database Reference
In-Depth Information
statement to inform Oracle to start applying all the redo log files
including those archived.
Figure 10-7: Zoomed area of Figure 10-1 with focus on User-managed
incomplete recovery. There are three different ways to do such type of
recovery. All the redo log files including the ones got archived will get
applied to the database when RECOVER DATABAE statement is
executed. We can stop the process of recovery in the middle by using
either of the clauses i.e. UNTIL CHANGE, UNTIL CANCEL or
UNTIL TIME with the RECOVER DATABASE statement. A
complete backup must be performed after incomplete recovery. Each
transaction in Oracle has been assigned a unique number called SCN or
System Change Number. After performing incomplete recovery of any
type, the database would then be opened with the RESETLOGS clause.
Search WWH ::
Custom Search