oracle数据库备份任务 - Oracle-fans - 博客园
备份脚本如下：
1.0 expdp
1.1导出某些schema
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 全库导出
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+'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级备份脚本
#set env
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
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级备份脚本
#set env
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
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级备份脚本
#set env
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
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/L2_bk_$DATE.log << EOF
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 定期删除归档
#set env
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
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平台的计划任务如下：
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"
~
