oracle备份计划(二)

2014-11-24 16:49:29 · 作者: · 浏览: 1
每小时备份,0 1 1 1 级别
[oracle@sia scripts]$ cat connect.rcv
connect target sys/oracle@prod;


[oracle@sia scripts]$ cat hourinc0.rcv
@@/dsk3/bk/scripts/connect.rcv
run{
backup as compressed backupset
incremental level 0 database
format='/dsk2/backup/inc0_%d_%U.bak';
}
exit;


[oracle@sia scripts]$ cat hourinc1.rcv
@@/dsk3/bk/scripts/connect.rcv
run{
backup as compressed backupset
incremental level 1 database
format='/dsk2/backup/inc1_%d_%U.bak';
}
exit;


[oracle@sia scripts]$ cat hourinc0.sh 
nohup  $ORACLE_HOME/bin/rman  cmdfile=/dsk3/bk/scripts/hourinc0.rcv log=/dsk3/bk/scripts/hourinc0.log append &


[oracle@sia scripts]$ cat hourinc1.sh 
nohup  $ORACLE_HOME/bin/rman  cmdfile=/dsk3/bk/scripts/hourinc1.rcv log=/dsk3/bk/scripts/hourinc1.log append &


[oracle@sia scripts]$ crontab -l
*         */1    *     *    *           /dsk3/bk/scripts/hourinc0.sh
*/15      */1    *     *    *           /dsk3/bk/scripts/hourinc1.sh
*/30      */1    *     *    *           /dsk3/bk/scripts/hourinc1.sh
*/45      */1    *     *    *           /dsk3/bk/scripts/hourinc1.sh