Oracle RMAN常用命令小结
RMAN命令小结
=================== 连接到目标数据库(不用恢复目录数据库) rman target / nocatalog
显示rman配置 RMAN> show all;
==================== 报告目标数据库的物理结构 RMAN> report schema;
报告陈旧备份 RMAN> report obsolete;
报告不可恢复的数据文件 RMAN> report unrecoverable;
列出备份信息 RMAN> list backup;
RMAN> list backup of database;
RMAN> list backup of tablespace table_name;
RMAN> list backup of controlfile;
RMAN> list backup of spfile;
RMAN> list backupset id;
======================== 校验备份信息: RMAN> crosscheck backup;
RMAN> crosscheck backup of database;
RMAN> crosscheck backup of tablespace system;
RMAN> crosscheck backup of controlfile;
RMAN> crosscheck backup of spfile;
======================== 删除备份 RMAN> delete obsolete; -- 删除陈旧备份
RMAN> delete expired backup;
RMAN> delete backupset id;
RMAN> delete backup; -- 删除所有备份
========================= 改变备份集的状态 RMAN> change backupset id unavailable; -- available 改为长期备份 RMAN> change backupset id keep forever logs;
RMAN> change backupset id keep until time'sysdate+60' logs;
RMAN> change backupset id nokeep;run { allocatechannel t1 type 'sbt_tape' parms'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; allocatechannel t2 type 'sbt_tape' parms'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'; delete expiredbackup; release channelt1; release channelt2; }