Databases Reference
In-Depth Information
If you want to search for and check only image copies and not backup sets, you can do so by using the
copy
option with the
crosscheck
command, as shown in the following example:
RMAN> crosscheck copy;
You may want to run the
crosscheck copy
command when verifying the current status and the availability of
image copies that you made yourself or through RMAN.
You can use various options of the
crosscheck
command to perform the cross-checking of a specific tablespace,
data file, archived redo log, control file, and so on. Here are some examples that show how to restrict the cross-
checking to specify types of backups:
# cross-checking just backup sets.
RMAN> crosscheck backupset;
# cross-checking a copy of a database
RMAN> crosscheck copy of database;
# cross-checking specific backupsets;
RMAN> crosscheck backupset 1001, 1002;
# cross-checking using a backup tag
RMAN> crosscheck backuppiece tag = 'weekly_backup';
# cross-checking a control file copy;
RMAN> crosscheck controlfilecopy '/tmp/control01.ctl';
# cross-checking backups completed after a specific time
RMAN> crosscheck backup of datafile "/u01/app/oracle/prod1/system01.dbf" completed
after 'sysdate-14';
# cross-checking of all archivelogs and the spfile;
RMAN> crosscheck backup of archivelog all spfile;
# cross-checking a proxy copy
RMAN> crosscheck proxy 999;
Use the
completed after
clause to restrict the
crosscheck
command to check only those backups that were
created after a specific point in time. The following command will check only for backups of a data file made in the
last week:
RMAN> crosscheck backup of datafile 2
completed after 'sysdate -7';
It's important to understand that the
crosscheck
command doesn't
delete
the RMAN repository records
of backup files that were manually removed. It simply
updates
those records in the repository to reflect that the
backup isn't available any longer by marking the file status as expired. You must use the
delete
command to
actually remove the records of these expired backups from the RMAN repository. On the other hand, if a file was
expired at one time and is now made available again on disk or on media management layer, RMAN will mark the
file's status as available.
Deleting Backups
Problem
You want to delete unwanted backups.
