RMAN备份及恢复归档日志的语法

一.备份所有归档日志文件 RMAN>backuparchivelogalldeleteinput; 二:restorearchivelog的各种选项 1.恢复全部归档日志文件 RMAN>restorearchivelogall; 2.只恢复5到8这四个归档日志文件 RMAN>restorearchivelogfromlogseq5untillogseq8; 3.恢复从第5个归档日志起 RMAN>restorearchivelogfromlogseq5; 4.恢复7天内的归档日志 RMAN>restorearchivelogfromtime'sysdate-7'; 5.sequencebetween写法 RMAN>restorearchivelogsequencebetween1and3; 6.恢复到哪个日志文件为止 RMAN>restorearchiveloguntillogseq3; 7.从第五个日志开始 RMAN>restorearchiveloglowlogseq5; 8.到第5个日志为止 RMAN>restorearchiveloghighlogseq5; 三:如果想改变恢复到另外路径下则可用下面语句 setarchivelogdestinationto'd:\backup';

RMAN>run 2>{allocatechannelcitypedisk; 3>setarchivelogdestinationto'd:\backup'; 4>restorearchivelogall; 5>releasechannelci; 6>}

四:rac环境下只恢复5到8这四个归档日志文件

RMAN>restorearchivelogfromlogseq5untillogseq8thread1;