======================================================= Oracle: rman maintenance commands ======================================================= :Title: Oracle: rman maintenance commands :Author: Douglas O'Leary :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... :command:`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. :command:`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. :command:`validate backupset ##` Verifies the backupset identified by ## can be restored. Throws an error if it can't be. :command:`list backup` Very verbose listing of all backups of which rman knows. Rather unreadable output :command:`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. :command:`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. :command:`list backupset ##` Much more readable version of list backup :command:`list incarnation [ of database ]` Lists the incnations of the database, information of which will be needed if you need to restore through a resetlogs :command:`list archivelog all` Lists the archivelogs in the FRA(?) that haven't been backed up yet. :command:`list backup of archivelog all [ summary ]` Lists the backups of the archive logs. :command:`report need backup [ days | incremental | redundancy ]` Reports on the datafiles that need to be backed up. W/o args, uses the default retention period. :command:`report obsolete` IDs the backups that are considered obsolete based on the configured retention policy :command:`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. :command:`report unrecoverable` Reports any datafiles, tablespaces, etc, that are unrecoverable. Would seem to be a fairly important command. :command:`delete obsolete` Deletes backupsets that are considered obsolete based on the configured retention policy :command:`delete backupset ##, ##, ##` Deletes specific backupsets.