Rman备份方案设计

最新推荐文章于 2025-07-06 16:17:55 发布

原创最新推荐文章于 2025-07-06 16:17:55 发布 · 525 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#脚本 #delete #database #disk #archive #input

备份与恢复专栏收录该内容

26 篇文章

订阅专栏

本文详细介绍了如何使用RMAN（Recovery Manager）设计一个包括全备、增量备份以及自动删除过期归档日志的脚本方案。通过建立全局脚本并设置定时任务，实现了数据库的自动化备份和归档日志管理，确保了数据的安全性和有效性。

1.用catalog连接目标数据库

rman catalog rmanuser/rmanuser target sys/sysdba@rac1

2.建立catalog脚本

RMAN> replace global script global_del {
2> allocate channel d1 device type disk;
3> delete obsolete recovery window of 15 days;
4> release channel d1;
5> }

3.查看脚本列表

RMAN> list global script names;

4.查看脚本内容

RMAN> print global script global_del;

5.再次建立备份归档的脚本

RMAN> replace global script global_arch comment "backup archivelog as well as delete input" {
2> allocate channel d1 device type disk;
3> sql "alter system archive log current";
4> set limit channel d1 readrate=10240;
5> set limit channel d1 kbytes=409600;
6> backup as compressed backupset
7> format='/u01/rmanbak/arch_%d_%U'
8> tag='bkarch'
9> channel=d1
10> archivelog all delete input;
11> release channel d1;
12> }

6.建立增量为0的脚本

RMAN> replace global script global_inc0 comment "backup database as incremental level 0" {
2> execute global script global_del;
3> allocate channel d1 device type disk;
4> backup as compressed backupset
5> incremental level=0
6> format='/u01/rmanbak/inc0_%d_%U'
7> tag='inc0'
8> channel=d1
9> database;
10> release channel d1;
11> execute global script global_arch;
12> }

7.执行脚本

RMAN> run {
2> execute global script global_inc0;
3> }

8.建立执行脚本inc0.rcv

@@/u01/rmanbak/connect.rcv
run {
execute global script global_inc0;
}
exit

9.建立连接脚本connect.rcv

connect target sys/sysdba@rac1
connect catalog rmanuser/rmanuser

10.建立执行shell脚本inc0.sh

nohup $ORACLE_HOME/bin/rman cmdfile=/u01/rmanbak/inc0.rcv log=/u01/rmanbak/inc0.log append &

11.把shell脚本inc0.sh加入crontab,设定自动执行计划