Search This Blog

Tuesday, July 13, 2010

Common RMAN Commands

Connect to RMAN
rman target / nocatalog Connect to RMAN
rman target / catalog rman/rman@rman
Show Configurations
show all;
Backup Commands
backup archivelog all;
backup archivelog from time 'sysdate - 1';
backup archivelog from sequence 353;
backup archivelog all delete input;
backups archivelogs and deletes logs
backup database plus archivelog;
backup duration 00:30 database; -_Limits backup impact_
backup duration 00:30 minimize time database; - Limits backup impact
backup duration 00:30 minimize load database; -_Limits backup impact_
list backup summary;
list backup
report obsolete;
delete obsolete;
crosscheck backup;
backup current controlfile;
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
delete noprompt obsolete;
LIST BACKUP SUMMARY;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CLEAR;

No comments:

Post a Comment