Connect.rcv(该文件只有两句话)
rman catalog rmanuser/rman@digoal target sys/oracle@clonedb
删除不必要的备份
delete obsolete recovery window of 15 days;
release channel d1;
}
backup as compressed backupset
format='/rmanbak/backupctl.ctl'
tag='bkctl'
channel=d1
current controlfile reuse;
release channel d1;
}
allocate channel d1 device type disk;
sql "alter database archive log current"; 备份我们当前的联机日志
set limit channel d1 readrate=10240(10M);
set limit channel d1 kbytes=4096000;(备份片的大小)
backup as compressed backupset
format='/rmanbak/arch_%d_%U'
tag='bkarch'
channel=d1
archivelog all delete input;
release channel d1;
}
delete globals script: global_inc0;
execute global script global_del;
allocate channel d1 deviece type disk;
set limit channel d1 readrate=10240;
set limit channel d1 kbytes=4096000;
backup as compressed backupset
incrmental level=0
format='/rmanbak/inc0_%d_%U'
tag='inc0'
channel=d1
database ;
release channel d1;
execute global script global_arch;
execute global script global_bkctl;
}
execute global script global_del;
allocate channel d1 deviece type disk;
set limit channel d1 readrate=10240;
set limit channel d1 kbytes=4096000;
backup as compressed backupset
incrmental level=1
format='/rmanbak/inc1_%d_%U'
tag='inc1'
channel=d1
database ;
release channel d1;
execute global script global_arch;
execute global script global_bkctl;
}
execute global script global_del;
allocate channel d1 deviece type disk;
set limit channel d1 readrate=10240;
set limit channel d1 kbytes=4096000;
backup as compressed backupset
incrmental level=2
format='/rmanbak/inc2_%d_%U'
tag='inc1'
channel=d1
database ;
release channel d1;
execute global script global_arch;
execute global script global_bkctl;
}
execute global script global_inc0;
execute global script global_inc1;
execute global script global_inc2;
}
建立shell脚本,让linux自动执行脚本
run{
execute global script gloal_inc0;
}
exit;
nohup(在后台执行,&) $ORACLE_HOME/bin/rman cmdfile=/rmanbak/script/inc0.rcv log=/rmanbak/script/inc0.log append
&
&
nohup(在后台执行,&) $ORACLE_HOME/bin/rman cmdfile=/rmanbak/script/inc2.rcv log=/rmanbak/script/inc0.log append
&
0 1 * * 0 /rmanbak/script/inc0.sh
0 1 * * 1 /rmanbak/script/inc2.sh
0 1 * * 2 /rmanbak/script/inc2.sh
0 1 * * 3 /rmanbak/script/inc2.sh
0 1 * * 4 /rmanbak/script/inc1.sh
0 1 * * 5 /rmanbak/script/inc2.sh
0 1 * * 6 /rmanbak/script/inc2.sh
Chmod u+x*.sh 给shell脚本加权限