Oracle数据库常用备份脚本

recover database until time  '2016-02-20 15:31:07' using backup controlfile;
20 14:59:33 UTC 2016
--全库备份脚本：
#!/bin/bash
export ORACLE_SID=PROD4
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' 
echo '----------------------------------------'>>/tmp/rman_PROD4_full.log
echo 'Start FULL Backup at '`date +%Y-%m-%d:%H:%M:%S` >>/tmp/rman_PROD4_full.log
echo '----------------------------------------'>>/tmp/rman_PROD4_full.log
rman target / nocatalog log /tmp/rman_PROD4_full.log append<<EOF
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup  database format '/home/oracle/bak/full_%d_%T_%s_%p';
SQL 'alter system archive log current';
SQL 'alter system archive log current';
backup archivelog  all delete input  format '/home/oracle/bak/arch_%d_%t_%s_%p';
backup current controlfile format '/home/oracle/bak/ctl_%d_%T_%s_%p';
backup spfile format '/home/oracle/bak/%d_%U.spfile';
}
EOF
echo '----------------------------------------'>>/tmp/rman_PROD4_full.log
echo 'End Full Database Backup at '`date +%Y-%m-%d:%H:%M:%S` >>/tmp/rman_PROD4_full.log
echo '----------------------------------------'>>/tmp/rman_PROD4_full.log
rman target / nocatalog log /tmp/rman_delete.log append<<EOF
allocate channel  for maintenance type disk;
crosscheck backup;
crosscheck archivelog all;
delete noprompt obsolete;
delete noprompt expired backup;
delete noprompt expired archivelog all;
EOF
exit
###################################################################################
--如果有dg备库，需要配置归档删除策略，防止备库收到不归档就被删除了。
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
或者这样写每次只备份和删除半天前的归档backup archivelog until time 'sysdate-1/2' all delete input  format '/orabak/fullbak/arch_%D_%s_%p_%T';
###################################################################################
--归档备份脚本：
#!/bin/bash
export ORACLE_SID=PROD4
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' 
echo '----------------------------------------'>>/tmp/rman_PROD4_arch.log
echo 'Start Arch Backup at '`date +%Y-%m-%d:%H:%M:%S` >>/tmp/rman_PROD4_arch.log
echo '----------------------------------------'>>rman_PROD4_arch.log
rman target / nocatalog log /tmp/rman_PROD4_arch.log append<<EOF
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
sql 'alter system archive log current';
sql 'alter system archive log current';
sql 'alter system archive log current';
backup archivelog all format '/home/oracle/bak/arch_%d_%T_%s_%p' delete input ;
backup current controlfile format '/home/oracle/bak/ctl_%d_%T_%s_%p';
}
EOF
echo '----------------------------------------'>>/tmp/rman_PROD4_arch.log
echo 'END Arch Backup at '`date +%Y-%m-%d:%H:%M:%S` >>/tmp/rman_PROD4_arch.log
echo '----------------------------------------'>>/tmp/rman_PROD4_arch.log
rman target / nocatalog log /tmp/rman_arch_delete.log append<<EOF
allocate channel  for maintenance type disk;
crosscheck backup;
crosscheck archivelog all;
delete noprompt obsolete;
delete noprompt expired backup;
delete noprompt expired archivelog all;
EOF
exit