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.