rman 备份（1）

备份策略：

周日全备

周一到周六备份归档日志

备份脚本：

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/