oracle恢复操作命令详解,学习笔记:Oracle RMAN备份入门 DBA使用rman中关于archivelog操作命令汇总...

天萃荷净

rman中关于archivelog操作，汇总运维DBA在日常工作中常用于archivelog归档文件的操作命令，含：查看归档，删除归档，备份恢复归档等命令

RMAN> list backup of archivelog all;

列出所有archive log 备份

RMAN> list backup of archivelog from logseq 100 until logseq 120;

列出archive log 从100到120

RMAN> list backup of archivelog sequence between 100 and 110;

列出archive log 从100到120

–说明:between……and只能使用sequence，而不能使用logseq

RMAN> list backup of archivelog from logseq 100;

列出seq大于等于100的archive log

RMAN> list backup of archivelog low logseq 120;

列出seq大于等于120的archive log

RMAN> list backup of archivelog sequence 100;

列出seq为100的archive log

–说明:在对于rman中关于archivelog的操作中logseq与sequence作用相同，但是建议尽量使用sequence

RMAN> list backup of archivelog logseq 85;

列出seq为85的archive log

RMAN> list backup of archivelog until logseq 85;

列出seq小于等于85的archive log

RMAN> list backup of archivelog high logseq 40;

列出seq小于等于40的archive log

RMAN> list backup of archivelog from time ‘sysdate-7′;

列出7天以前的archive log

RMAN> run {

2> set archivelog destination to ‘/opt/oracle/oradata/test/newlog’;

3> restore archivelog low logseq 40;

4> }

从seq为40开始，恢复到/opt/oracle/oradata/test/newlog中

–说明:list backup of archivelog中限定日志的位置也适合restore archivelog

RMAN> backup archivelog sequence between 100 and 110 format ‘/tmp/text_test.rman’ delete input;

备份seq为100至110的archive log

–说明:list backup of archivelog中限定日志的位置也适合backup archivelog

RMAN>DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-7′;

删除7天前archive log

RMAN>DELETE ARCHIVELOG low logseq 40;

删除seq大于等于40的archive log

RMAN> crosscheck archivelog all;

RMAN> delete expired archivelog all;

删除无效archive log

–说明:DELETE ARCHIVELOG中限定日志的位置也适合restore archivelog

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之学习笔记:Oracle RMAN备份入门 DBA使用rman中关于archivelog操作命令汇总