Database Reference
In-Depth Information
For “Change-Based” Incomplete Recovery use the following
command at the RMAN prompt. The information about the SCN
can be acquired by querying the V$LOG_HISTORY dynamic
performance view.
RMAN> RUN {
ALLOCATE CHANNEL ch1 TYPE DISK;
SET UNTIL SCN=6563452;
RESTORE DATABASE;
RECOVER DATABASE;
}
After the completion of any type of RMAN Incomplete
Recovery process, open the database using RESETLOGS clause
as shown below.
ALTER DATABASE OPEN 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
take the complete database backup using one of the techniques
discussed earlier in this chapter.
Logical Backup and Recovery
As shown in Figure 10-9 under logical backup and recovery we
have two techniques available. One, we inherited from Oracle 9i
i.e. Export/Import or Simple Export/Import (exp & imp) and
second one is new to Oracle 10g version i.e. Data Pump
Export/Import (expdp & impdp). Oracle recommends DBAs to
use this latest, fastest technique instead of using the old
technology. The simple Export/Import utilities are available in
Oracle 10g only for backward compatability. The Data Pump
export and import (expdp & impdp) are not backward
compatible with old export and import (exp & imp).
Search WWH ::
Custom Search