ORACLE 全备份脚本

#!/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
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值