RMAN备份及恢复归档日志的语法
👉 本文共约345个字，系统预计阅读时间或需2分钟。
备份所有归档日志文件
1 | RMAN> backup archivelog all delete input; |
还原归档 restore archivelog 的各种选项
1.恢复全部归档日志文件
1 | RMAN> restore archivelog all; |
2.只恢复5到8这四个归档日志文件
1 | RMAN> restore archivelog from logseq 5 until logseq 8; |
3.恢复从第5个归档日志起
1 | RMAN> restore archivelog from logseq 5; |
4.恢复7天内的归档日志
1 | RMAN> restore archivelog from time 'sysdate-7'; |
5.sequence between 写法
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
1 | RMAN> restore archivelog sequence between 1 and 3; |
6.恢复到哪个日志文件为止
1 | RMAN> restore archivelog until logseq 3; |
7.从第五个日志开始恢复
1 | RMAN> restore archivelog low logseq 5; |
8.到第5个日志为止
1 | RMAN> restore archivelog high logseq 5; |
如果想改变恢复到另外路径下 则可用下面语句
1 2 3 4 5 6 7 8 | 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> } |
