备份策略：

周日全备

周一到周六备份归档日志

备份脚本：

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博客

rman 备份（1）