Pages

Tuesday, April 5, 2016

RMAN- Maintenance Commands

RMAN- Maintenance Commands

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.

No comments:

Post a Comment