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
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
- ORACLE 全备份脚本
- Oracle 全库备份脚本
- 【ORACLE 备份】rman多通道全备份脚本
- mysql全备份脚本
- RMAN全备份脚本
- Rman 备份脚本全
- Oracle RMAN-全备份
- msyql 全量备份脚本
- oracle 备份脚本
- oracle日常备份脚本
- Oracle备份脚本
- oracle 增量备份脚本
- oracle备份、还原脚本
- oracle 增量备份脚本
- Oracle自动备份脚本
- oracle 冷备份脚本
- Oracle RMAN备份脚本
- oracle备份脚本
- Codeforces Round #346 (Div. 2) D (叉积)
- 【April Fools Day Contest 2016E】【脑洞 define分行用法】Out of Controls 不用条件循环实现最长最短路
- jar9
- 最大上升子序列和
- hdoj 1432 Lining Up
- ORACLE 全备份脚本
- OpenCV HOG
- 指定多个泛型类型
- 【April Fools Day Contest 2016F】【脑洞 or 二分OEIS】Ace It!
- Offer题9 斐波那契数列&青蛙跳台&矩形覆盖
- 泛型的上限
- HTML-embed标签详解
- 【April Fools Day Contest 2016G】【2种语言实现】You're a Professional
- 用线性列表求并集