ORACLE 全备份脚本

来源:互联网 发布:网络信息安全杂志 编辑:程序博客网 时间:2024/05/14 02:43
#!/bin/bash 
export ORACLE_SID=prd
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export NLS_LANG=american_america.AL32UTF8
backtime=`date +"20%y%m%d%H%M%S"`
$ORACLE_HOME/bin/rman target /   log=/oracle/backup/log/full_backup_$backtime.log <<EOF 
run{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
crosscheck backup;
sql 'alter system archive log current'; 
backup database format '/oracle/rmanbk/db_%d_%T_%U'; 
sql 'alter system archive log current';
backup archivelog all format '/oracle/rmanbk/arc_%t_%s' delete all input;
backup current controlfile format '/oracle/rmanbk/cntrl_%s_%p_%s'; 
crosscheck archivelog all; 
delete noprompt expired backup;
delete noprompt obsolete;
delete noprompt backup of database completed before 'sysdate - 30'; 
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
EOF
1 0
原创粉丝点击