日期:2014-05-16  浏览次数:20449 次

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

一.备份所有归档日志文件
RMAN> backup archivelog all delete input;
二: restore archivelog 的各种选项
恢复全部归档日志文件
RMAN> restore archivelog all;
只恢复5到8这四个归档日志文件
RMAN> restore archivelog from logseq 5 until logseq 8;
恢复从第5个归档日志起
RMAN> restore archivelog from logseq 5;
恢复7天内的归档日志
RMAN> restore archivelog from time 'sysdate-7';
sequence between 写法
RMAN> restore archivelog sequence between 1 and 3;
恢复到哪个日志文件为止
RMAN> restore archivelog until logseq 3;
从第五个日志开始恢复
RMAN> restore archivelog low logseq 5;
到第5个日志为止
RMAN> restore archivelog high logseq 5;
三:如果想改变恢复到另外路径下 则可用下面语句
set archivelog destination to 'd:\backup';
?? RMAN> run
?? 2> {allocate channel ci type disk;
?? 3> set archivelog destination to 'd:\backup';
?? 4> restore archivelog all;
?? 5> release channel ci;
?? 6> }


参考至:http://space.itpub.net/11134237/viewspace-710209

如有错误,欢迎指正

邮箱:czmcj@163.com