oracle rman备份命令-备份恢复

核心提示： list backup by file; 列出详细备份list backup; 列出过期备份list expired backup; 列出表空间和数据文件备份list backup of tablespace ;list backup of datafile; 列出归档日志备份list a

list backup by file;

列出详细备份

list backup;

列出过期备份

list expired backup;

列出表空间和数据文件备份

list backup of tablespace ;

list backup of datafile;

列出归档日志备份

list archivelog all;

list backup of archivelog all;

列出控制文件和服务器参数文件

list backup of controfile;

list backup of spfile;

检查备份

crosscheck backup;
crosscheck backup of database;
crosscheck backup of tablespace system;
crosscheck backup of controlfile;
crosscheck backup of spfile;

删除备份

allocate channel for delete type disk;
change backupset BS Key delete;
delete obsolete; 删除陈旧备份
delete expired backup;
delete backupset id;
delete backup; -- 删除所有备份 网管下载dl.bitscn.com

改变备份集的状态

change backupset id unavailable; -- available

改为长期备份

change backupset id keep forever logs;
change backupset id keep until time 'sysdate+60' logs;
change backupset id nokeep;

网管u家bitscn.net

报告丢弃的备份

report obsolete;

删除丢弃状态的备份

delete obsolete;

RMAN的crosscheck 命令

1 备份集有两种状态A(Available,RMAN认为该项存在于备份介质上)X(Expired，备份存在于控制文件或恢复目录中，但是并没有物理存在于备份介质上）

2 crosscheck 的目的是检查RMAN 的目录以及物理文件，如果物理文件不存在于介质上，将标记为Expired。如果物理文件存在，将维持Available。如果原先标记为Expired的备份集再次存在于备份介质上（如恢复了损坏的磁盘驱动器后），crosscheck将把状态重新从Expired标记回Available。