备份策略:
周日全备
周一到周六备份归档日志
备份脚本:
billb[/]#crontab -l oracle
50 0 * * 0 /orarman/script/rman_full.sh &>/dev/null
10 0 * * 1-6 /orarman/script/rman_arch.sh &>/dev/null
$ cat rman_full.sh
#!/bin/sh
export ORACLE_HOME=/oracle/product/rac10g
export ORACLE_SID=bill2
LOGFILE="/orarman/log/"
CMDFILE="/orarman/script/rman_cmd_full.txt"
/oracle/product/rac10g/bin/rman target / log=$LOGFILE`date +"%Y-%m-%d"`.log cmdfile=$CMDFILE;
$ cat rman_cmd_full.txt
run{
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt obsolete;
allocate channel c1 device type disk format '/orabak/databak/%T_%U.dbf' maxpiecesize 900M connect sys/oracle@bill1;
allocate channel c2 device type disk format '/orabak/databak/%T_%U.dbf' maxpiecesize 900M connect sys/oracle@bill2;
backup as compressed backupset database;
backup archivelog all delete input;
release channel c1;
release channel c2;
}
$ cat rman_arch.sh
#!/bin/sh
export ORACLE_HOME=/oracle/product/rac10g
export ORACLE_SID=bill2
LOGFILE="/orarman/log/arch"
CMDFILE="/orarman/script/rman_cmd_arch.txt"
/oracle/product/rac10g/bin/rman target / log=$LOGFILE`date +"%Y.%m.%d-%T"`.log cmdfile=$CMDFILE;
$ cat rman_cmd_arch.txt
run{
allocate channel c1 device type disk format '/orabak/archbak/%T_%U.arc' maxpiecesize 900M connect sys/oracle@bill1;
allocate channel c2 device type disk format '/orabak/archbak/%T_%U.arc' maxpiecesize 900M connect sys/oracle@bill2;
backup archivelog all delete input;
release channel c1;
release channel c2;
}
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26715932/viewspace-729882/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26715932/viewspace-729882/