本文共 2010 字，大约阅读时间需要 6 分钟。
第十三章： Rman 维护
1、rman 使用和维护
2、list 查看备份信息
1）RMAN> list backup; 2）RMAN> list backup of tablespace users； 3）RMAN> list backup of datafile 2； 4）RMAN> list backup of controlfile; 5) RMAN> list backup of archivelog all; 6）RMAN> list backup of archivelog until time ='sysdate -1'; 7）RMAN> list backupset 56; 8）RMAN> list copy； 9）RMAN> list copy of tablespace users； 10）RMAN> list copy of datafile 1； 11）RMAN> list datafilecopy 67； 12）RMAN> list copy of controlfile;3、crosscheck：用于检测备份状态（AVAILABLE：可用；UNAVAILABLE ：不可用；expired 过期（备份已经被os 删除了）（防止备份在os下被误删除）
RMAN> crosscheck backup; RMAN> crosscheck copy；4、report
RMAN> report schema; 查看目标库的物理结构 RMAN> report need backup; 查看需要做备份的datafile RMAN> report obsolete; 根据备份冗余策略来判断，那些备份是陈旧的（obsolete）5、delete ；删除备份
RMAN> delete backup of datafile 2; RMAN> delete backup of tablespace system； RMAN> delete backup ； RMAN> delete backup of controlfile； RMAN> delete noprompt backup of controlfile; ；删除noprompt 不提示 RMAN> delete copy; RMAN> delete copy of datafile 10; RMAN> delete copy of tablespace users； RMAN> delete expired backup； 删除过期的备份 RMAN> delete expired copy； RMAN> delete obsolete ；删除陈旧的备份 RMAN> delete noprompt obsolete； 删除不加提示 6、catalog ：可以把手工备份的文件，转换到rman-------将手工备份注册为image
RMAN> catalog datafilecopy '/disk1/backup/prod/hot_bak/users01.dbf';cataloged datafile copy
datafile copy filename=/disk1/backup/prod/hot_bak/users01.dbf recid=68 stamp=759556193RMAN> list copy of datafile 2;
List of Datafile Copies Key File S Completion Time Ckp SCN Ckp Time Name ------- ---- - --------------- ---------- --------------- ---- 68 2 A 19-AUG-11 1457868 19-AUG-11 /disk1/backup/prod/hot_bak/users01.dbfRMAN> delete copy of datafile 2;
-------将手工备份注册成备份集
RMAN> catalog backuppiece '/disk1/backup/prod/hot_bak/users01.dbf';
---------注册目录下所有的备份（image）
RMAN> catalog start with ‘/disk1/backup/prod/hot_bak/’；
7、change: 修改备份状态
RMAN> change backupset 66 unAVAILABLE; RMAN> change backupset 66 AVAILABLE;