Databases Reference
In-Depth Information
Solution
When you perform an
open resetlogs
operation, it results in the creation of a new incarnation of the database. When
performing recovery operations on such a database, you might want to check the database incarnation. The
list
incarnation
command is handy for this purpose, as shown in the following example:
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- ------ ---------- ----------
1 1 ORCL 1316762630 PARENT 1 04-JUL-12
2 2 ORCL 1316762630 CURRENT 1609405 18-JUL-12
RMAN>
The
list incarnation
command output lists all incarnations of the target database.
How It Works
If the
list incarnation
command shows three incarnations of a database, for example, it means you've reset the
online redo logs of this database twice. Each time you reset the online redo logs, you create a new incarnation of
that database.
RMAN can use backups both from the current incarnation of a database and from a previous incarnation as the
basis for subsequent incremental backups if incremental backups are part of your backup strategy. As long as all the
necessary archived redo logs are available, RMAN can also use backups from a previous incarnation for performing
restore and recovery operations.
Updating the RMAN Repository After Manually
Deleting Backups
Problem
You have deleted some unneeded archived redo logs from disk using an operating system command instead of using
the RMAN
delete
command. The RMAN repository, however, continues to indicate that the deleted archived redo
logs are available on disk. You want to update this outdated RMAN repository information about the deleted backups.
Solution
Execute the
change ... uncatalog
command to update the RMAN repository after you manually delete a backup.
Let's say you delete the data file copy /u01/app/oracle/users01.dbf using the
rm
command from the Linux operating
system. Here's an example of how you would then use the
change ... uncatalog
command to change the RMAN
repository information pertaining to the removed data file copy:
RMAN> change datafilecopy '/u01/app/oracle/users01.dbf' uncatalog;
