 |
|
Oracle Tips by Burleson |
Oracle 10g RMAN Simplified Recovery Through Resetlogs
After you perform an incomplete (Point-in-time)
recovery, you need to open the database with the RESETLOGS option:
SQL> alter
database open resetlogs;
The RESETLOGS operation creates a new
incarnation of the database and resets the logs. Prior to Oracle
10g, the newly generated redo log files could not be used with the
backups taken in the past. Therefore, it was important to take an
immediate backup, since all previous backups became invalid. In
addition, if you used the RMAN catalog for future backups, you
needed to issue the following command to make the RMAN catalog aware
of the new incarnation of the database.
RMAN> reset
database;
In Oracle 10g, you no longer have to back up
your database following an incomplete recovery and OPEN RESETLOGS
operations.
This new feature is also applicable for the
following two scenarios:
-
Performing a recovery using a backup
control file and opening the database with the RESETLOGS
operation.
-
Reinstantiation of the old primary
database following a failover (see the Flashback Reinstantiation
section for details).
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
