Sunday, 3 May 2009

RMAN Commands

RMAN


RMAN is short for Recovery Manager.

When the databases use the controlfile as catalog.

Following is a short list of the most common commands.

To connect to RMAN:>>
rman target /




 
show full backups:>> list backup of database;
show backups:>> list backup summary;
show the archivelogs:>> list archivelog all;
show the datafiles:>> report schema;
show RMAN settings:>> show all;
remove a backup:>> delete backupset #;
remove several backups:>> delete noprompt backup of database completed before 'sysdate-7';
remove old archivelogs:>> delete noprompt archivelog until time 'sysdate-7';
test restore of backup:>> restore database validate;
test restore of controlfile:>> restore controlfile validate;
check validity:>> crosscheck backup;
see what needs backing up:>> report need backup;

No comments: