RMAN常用维护命令

1.report
 report schema
 report need backup incremental 3;          
 report need backup days 3 tablespace users;
 report need backup redundancy 2 database; 或 report need backup redundancy 2;  //备份低于两份
 report need backup recovery window of 6 days 
 report obsolete redundancy 2  //报告陈旧备份
 report unrecoverable //报告不可恢复的数据文件
2.list
 list backup of database;
 list backup of tablespace users;
 list backup of datafile 1;
 list backup of controlfile;
 list backup of archivelog all;
 list backup of spfile;
 list backupset 2(通过recid)
 list backup
 list archivelog all;
 list expired backupset;
 list copy
 list copy of database;
 list copy of datafile 1;
 list copy of archivelog sequence 1;
 list copy of controlfile;
 list copy of archivelog all;
 list datafilecopy 'd:\backup\demo_37.bak'
 list incarnation of database;  //列出数据库副本
3.crosscheck //核对磁盘和磁带上的备份文件
 三种状态:available,unavailable,expired
 crosscheck backup;              
 crosscheck backup of database;   //核对所有数据文件的备份集
 crosscheck backup of datafile 5;
 crosscheck backup of controlfile;
 crosscheck backup of spfile;
 crosscheck backup of archivelog sequence 3;
 crosscheck copy;                 //核对映像副本
 crosscheck copy of database;
 crosscheck copy of tablespace users;
 crosscheck copy of datafile 6;
 crosscheck copy of controlfile;
 crosscheck copy of arachivelog sequence 4;
4.delete (加个noprompt,表示删除时不提示)
 delete noprompt obsolete;        //禁止提示信息(删除映像副本或备份集)
 delete noprompt expired backup;
 delete noprompt expired copy;
 delete noprompt backupset 19;
 delete noprompt backuppiece 'd:\backup\demo_18.bak';  //删除备份片
 delete noprompt backup;
 delete noprompt datafilecopy 'd:\backup\demo_31.bak';
 delete noprompt copy;
 delete backup of tablespace users;
 delete archivelog all delete input;   
 delete obsolete;
 delete obsolete until time 'SYSDATE-120';
 delete expired backup of controlfile;
 backup backupset 22 format='d:\backup\%u.bak' delete input
 delete backuppiece 117;
5.change
 change backupset 22 unavailable/available;
 change datafilecopy 'd:\backup\demo_37.bak' unavailable;
 change backupset 156 keep forever logs    //建长期备份
 change backupset 198 keep until time 'sysdate+60' logs;
 change backupset 156 nokeep             
 change datafilecopy 'd:\backup\user01.bak' uncatalog;
 change controlfilecopy 'd:\backup\demo.ctl' uncatalog;
 change backuppiece 'd:\backup\demo_35.bak'  uncatalog;
6.catalog (注册手工备份)
 catalog datafilecopy 'd:\backup\user01.bak';
 catalog controlfilecopy
 catalog archivelog
 catalog backuppiece 'd:\backup\demo_40.dbf';
 catalog start with 'd:\bak'               //注册目录的所有备份文件

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/658698/viewspace-353165/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/658698/viewspace-353165/