Databases Reference
In-Depth Information
you. To guarantee the best results from this command, you must make a habit of executing the
crosscheck
command
frequently, especially if you've been manually deleting any kind of RMAN-related backup files at the OS level. This is
yet another reason for you to adhere to Oracle's recommendation of configuring both a backup retention policy and
an archived redo log deletion policy, in addition to using the flash recovery area. When you follow the recommended
maintenance strategy, RMAN backup and repository maintenance becomes more or less automatic, obviating the
need for you to constantly execute commands such as
crosscheck
to verify your backups.
Listing Only Recoverable Backups and Copies
Problem
You want to review all data file backups and copies that you can actually use for a restore and recovery.
Solution
Use the
list backup
command with the
recoverable
clause to restrict the list of backups to only those backups and
copies whose status is listed as available
.
Here's an example:
RMAN> list recoverable backup;
List of Backup Sets
===================
/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2012_08_20/o1_mf_s_791811205_834sppgs_.bkp
...
List of Archived Logs in backup set 146
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 29 1925370 07-AUG-12 1925437 07-AUG-12
...
List of Archived Logs in backup set 166
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 54 2150961 12-SEP-12 2163833 12-SEP-12
...
Control File Included: Ckp SCN: 2164280 Ckp time: 12-SEP-12
...
List of Datafiles in backup set 174
5 Full 2209483 21-SEP-12 /u01/app/oracle/oradata/orcl/cattbs_01.dbf
RMAN>
The
recoverable
clause restricts the list of backups and copies to only those that are listed as available in the
repository and, as such, can actually be used for a restore and recovery operation.
