Oracle Backup & Recovery Techniques - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 277

RECOVER DATABASE UNTIL CANCEL;
The last case under User-Managed Incomplete recovery is
“Changed-Based Recovery”. The word “Change” means SCN or
System Change Number. SCN is the unique number that gets
written to the header of data files, control files and redo log files.
It gets written whenever Checkpoint happens. Oracle assigns
each committed transaction a unique identification number
called SCN. So Change Based recovery gives us the most
control. We can stop the recovery process at any SCN.
Remember that this SCN should be after the last back but before
the point of failure. The statement used to perform such type of
recovery is as follows.
RECOVER DATABASE UNTIL CHANCE 64575343;
After performing any type of incomplete recovery the database
must be opened with the RESETLOG clause and then back up
the complete database.
ALTER DATABASE RESETLOGS;
RESETLOGS clause makes sure that redo logs applied in the
recovery process will never be used by resetting the log sequence
and rebuilding the redo log system. The next step would be to
perform complete database backup. The information about the
SCN can be acquired by querying the V$LOG_HISTORY
dynamic performance view.
RMAN based Incomplete Recovery
The command used to perform RMAN “Time-Based”
Incomplete Recovery is as follows.
RMAN> RUN {
ALLOCATE CHANNEL ch1 TYPE DISK;
SET UNTIL TIME '2003-3-4 11:00:00';
RESTORE DATABASE;
RECOVER DATABASE;
}