RMAN命令知多少

1.1 显示RMAN默认配置—SHOW命令
RMAN> show all;
RMAN> SHOW CONTROLFILE AUTOBACKUP;
1.2 列出备份信息--LIST
列出数据库中的所有信息：RMAN>LIST BACKUP;
列出所有备份的控制文件信息：RMAN>LIST BACKUP OF CONTROLFILE;
列出指定数据文件的备份信息：RMAN> LIST BACKUP OF DATAFILE 'D:\ORACLE\ORADATA\JSSBOOK\SCOTT_TBS01.DBF';或RMAN> LIST BACKUP OF DATAFILE 5;--ps:DATAFILE序号可以通过动态性能视图V$DATAFILE或数据字典DBA_DATA_FILES中查询
列出所有备份的归档文件信息：RMAN>LIST BACKUP OF ARCHIVELOG ALL;
列出指定表空间的备份信息：RMAN>LIST COPY OF TABLESPACE ‘SYSTEM’
列出某个设备上的所有信息：RMAN>LIST DEVICE TYPE DISK BACKUP;
列出数据库当前所有归档：LIST ARCHIVELOG ALL;
列出所有无效备份LIST EXPIRED BACKUP;
1.3 删除备份—DELETE
删除过期备份：RMAN>DELETE OBSOLETE;
删除无效备份：RMAN>DELETE EXPIRED BACKUP;
删除EXPIRED副本：RMAN>DELETE EXPIRED COPY;
删除特定备份集：RMAN>DELETE BACKUPSET 19;
删除特定备份片：RMAN>DELETE BACKUPPIECE ‘D:\backup\DEMO_19.bak’;
删除所有备份集：DELETE BACKUP;
删除特定映像副本：RMAN>DELETE DATAFILE COPY ‘D:\backup\DEMP_19.bak’;
删除所有映像副本：DELETE COPY;
在备份后删除输入映像：RMAN>BACKUP ARCHIVELOG ALL DELETE INPUT;RMAN>DELETE BACKUPSET 22 FORMANT = “D:\backup\%u.bak” DELETE INPUT;
1.4 报表显示
查看7天前数据库的模式：RMAN> report SCHEMA AT TIME 'SYSDATE-7';
查看所有需要备份的文件：RMAN> REPORT NEED BACKUP;
查看指定表空间是否需要备份：RMAN> REPORT NEED BACKUP TABLESPACE SYSTEM;
查看过期备份：RMAN> REPORT OBSOLETE;
1.5 执行检查—CORSSCHECK
检查所有归档文件：RMAN> CROSSCHECK ARCHIVELOG ALL;
检查所有备份集：RMAN>CROSSCHECK BACKUP;
1.6 修改状态—CHANGE
修改指定备份集状态：RMAN>CHANGE BACKUPSET n UNAVAILABLE;
修改指定表空间的备份集状态：RMAN> CHANGE BACKUP OF TABLESPACE USERS UNAVAILABLE;
修改指定归档文件状态：RMAN> CHANGE ARCHIVELOG LOGSEQ=12 UNAVAILABLE;
查询归档文件序号：RMAN> LIST ARCHIVELOG ALL;
删除归档文件：
RMAN> CHANGE ARCHIVELOG LOGSEQ=n DELETE;