Oracle: rman maintenance commandsΒΆ

Title:Oracle: rman maintenance commands
Author:Douglas O’Leary <dkoleary@olearycomputers.com>
Description:Oracle: rman maintenance commands
Date created:08/04/2010
Date updated:08/04/2010
Disclaimer:Standard: Use the information that follows at your own risk. If you screw up a system, don’t blame it on me...
crosscheck backup
Verifies that the backups that rman thinks are available actually are. Lists any that aren’t as expired with a ‘X’ in the status column.
crosscheck backup completed between 'sysdate-5' and 'sysdate-2';
Verifies that the backups that rman thinks are available actually are. Lists any that aren’t as expired with a ‘X’ in the status column.
validate backupset ##
Verifies the backupset identified by ## can be restored. Throws an error if it can’t be.
list backup
Very verbose listing of all backups of which rman knows. Rather unreadable output
list backup summary
A much more readable version of the above. Useful for gettng the backup set key from which you can get a more detailed and readable report.
list backup of [ tablespace ${ts} | datafile # ] [ summary ]
Lists backups that have tablespace or datafile specifically. Useful for finding the latest backup of the tablespace for tspitr, for example.
list backupset ##
Much more readable version of list backup
list incarnation [ of database ]
Lists the incnations of the database, information of which will be needed if you need to restore through a resetlogs
list archivelog all
Lists the archivelogs in the FRA(?) that haven’t been backed up yet.
list backup of archivelog all [ summary ]
Lists the backups of the archive logs.
report need backup [ days | incremental | redundancy ]
Reports on the datafiles that need to be backed up. W/o args, uses the default retention period.
report obsolete
IDs the backups that are considered obsolete based on the configured retention policy
report schema [ at [ time | SCN | sequence ]
Displays the database schema. In order to use the ‘at time’ syntax, need to be connected to a recovery catalog.
report unrecoverable
Reports any datafiles, tablespaces, etc, that are unrecoverable. Would seem to be a fairly important command.
delete obsolete
Deletes backupsets that are considered obsolete based on the configured retention policy
delete backupset ##, ##, ##
Deletes specific backupsets.