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.