oracle数据库备份任务

备份脚本如下：

1.0 expdp
1.1导出某些schema

#!/bin/bash

ORACLE_BASE=/oracle/product
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/db
export ORACLE_HOME
ORACLE_SID=xxxxx
export ORACLE_SID
NLS_LANG=AMERICAN_AMERICA.zhs16gbk
export NLS_LANG
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export CLASSPATH
PATH=$PATH:/usr/bin:sbin:/bin:/usr/sbin:/opt/bin:/usr/local/bin:$ORACLE_HOME/bin:/usr/contrib/bin
export PATH

cd /datapool/oracle/tmp/expdp
mkdir $ORACLE_SID+'7schemas+expdp'+`date +%Y+%m+%d`

expdp system/manager1 directory=ora_back dumpfile=$ORACLE_SID+'7schemas'+`date +%Y+%m+%d+%H+%M+%S`.dmp cluster=n schemas=ygcg_ndmain,bjdjy_data,ygcg_lx,ygcg_ht,ygcg_trade,ygcg_jianguan,zhgldata logfile=$ORACLE_SID+'7schemas'+`date +%Y+%m+%d+%H+%M+%S`.log
mv $ORACLE_SID+'7schemas'+`date +%Y+%m+%d`*.dmp $ORACLE_SID+'7schemas+expdp'+`date +%Y+%m+%d`

1.2 全库导出

#!/bin/bash

cd /datapool/oracle/tmp/expdp
mkdir $ORACLE_SID+'full'+`date +%Y+%m+%d`

expdp system/manager1 directory=ora_back dumpfile=$ORACLE_SID+'full'+`date +%Y+%m+%d+%H+%M+%S`.dmp cluster=n full=y logfile=$ORACLE_SID+'full'+`date +%Y+%m+%d+%H+%M+%S`.log
#mv $ORACLE_SID+'full'+`date +%Y+%m+%d`*.dmp $ORACLE_SID+'full'+`date +%Y+%m+%d`

2.0 rman

2.1 0级备份脚本

#!/bin/bash
#set env

ARC_PATH=/datapool/oracle/backup/arch
export ARC_PATH
RMAN_BAK_PATH=/datapool/oracle/backup/rman_backup
export rman_bak_path
DATE=`date +%Y%m%d-%H:%M:%S`
export DATE

rman target / log /datapool/oracle/backup/rman_backup/log/L0_bk_$DATE.log << EOF

run {
allocate channel c1 type disk ;
allocate channel c2 type disk ;
allocate channel c3 type disk ;
backup incremental level 0 tag 'dbL0' format '$RMAN_BAK_PATH/L0_%U_%t.bak' database ;
sql 'alter system archive log current';
backup filesperset 3 format '$ARC_PATH/arch%t.arc' archivelog all delete input ;
delete noprompt obsolete ;
release channel c1;
release channel c2;
release channel c3;
}
exit;

2.2 1级备份脚本

#!/bin/bash
#set env

ARC_PATH=/datapool/oracle/backup/arch
export ARC_PATH
RMAN_BAK_PATH=/datapool/oracle/backup/rman_backup
export RMAN_BAK_PATH
DATE=`date +%Y%m%d-%H:%M:%S`
export DATE

rman target / log /datapool/oracle/backup/rman_backup/log/L1_bk_$DATE.log << EOF

run {
allocate channel c1 type disk ;
allocate channel c2 type disk ;
allocate channel c3 type disk ;
backup incremental level 1 tag 'dbL1' format '$RMAN_BAK_PATH/L0_%U_%t.bak' database ;
sql 'alter system archive log current';
backup filesperset 3 format '$ARC_PATH/arch%t.arc' archivelog all delete input ;
delete noprompt obsolete ;
release channel c1;
release channel c2;
release channel c3;
}
exit;

2.3 2级备份脚本

#!/bin/bash
#set env

run {
allocate channel c1 type disk ;
allocate channel c2 type disk ;
allocate channel c3 type disk ;
backup incremental level 2 tag 'dbL2' format '$RMAN_BAK_PATH/L0_%U_%t.bak' database ;
sql 'alter system archive log current';
backup filesperset 3 format '$ARC_PATH/arch%t.arc' archivelog all delete input ;
delete noprompt obsolete ;
release channel c1;
release channel c2;
release channel c3;
}
exit;

2.4 定期删除归档

#!/bin/bash
#set env

ARC_PATH=/datapool/oracle/backup/arch
export ARC_PATH
RMAN_BAK_PAT=/datapool/oracle/backup/rman_backup
export RMAN_BAK_PAT
DATE=`date +%Y%m%d-%H:%M:%S`
export DATE

rman target / log /datapool/oracle/backup/rman_backup/log/rm_arch_$DATE.log << EOF

run {
crosscheck archivelog all;
delete archivelog all;
}
exit;

3.0 linux平台的计划任务如下：

00 17 20 5 * su - oracle -c "/export/home/oracle/scripts/expdp-impdp/expdp_full.sh"
30 19 30 4 * su - oracle -c "/export/home/oracle/scripts/impdp.sh"
45 18 2 5 * su - oracle -c "/export/home/oracle/scripts/imdpdp_ygcg_trade.sh"
40 10 13 5 * su - oracle -c "/export/home/oracle/scripts/expdp0512.sh"

00 22 * * 1-5 su - oracle -c "/export/home/oracle/scripts/expdp-impdp/expdp_7schemas.sh"
* 01 * * 6 su - oracle -c "/export/home/oracle/scripts/expdp-impdp/expdp_full.sh"

#30 10 23 5 * su - oracle -c "/export/home/oracle/scripts/expdp-impdp/impdp_0523.sh"

* 12 * * * su - oracle -c "/export/home/oracle/scripts/expdp-impdp/rm_redundancy.sh"

30    16    *    *    *      su - oracle -c "/export/home/oracle/scripts/rman/rm_arch.sh"
#*    0    *    *    5    su - oracle -c "/export/home/oracle/scripts/rman/l0_rman_bak.sh"
#*    0    *    *    0 1    su - oracle -c "/export/home/oracle/scripts/rman/l2_rman_bak.sh"
#*    0    *    *    2     su - oracle -c "/export/home/oracle/scripts/rman/l1_rman_bak.sh"
#*    0    *    *    3 4   su - oracle -c "/export/home/oracle/scripts/rman/l2_rman_bak.sh"