oracle备份计划(二)
每小时备份,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