Oracle RMAN 全备 脚本
来源:互联网 发布:淘宝美工注意事项 编辑:程序博客网 时间:2024/05/18 02:57
Oracle RMAN 全备 脚本转载自:http://blog.chinaunix.net/uid-20807166-id-1833981.html
- #!/bin/bash
- #oracle env
- export ORACLE_BASE=/opt/oracle
- export ORACLE_HOME=/opt/oracle/product/10.2.0/db_1
- export ORACLE_OWNER=oracle
- export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/lib:/usr/lib
- export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
- export PATH=$PATH:$ORACLE_HOME/bin
- export ORACLE_SID=yjsdb
- export LANG=en_US
- export CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
- ##backup
- DATE=`date '+%Y-%m-%d-%H'`
- cd /backup/yjsdb/
- mkdir $DATE
- cd $DATE
- mkdir archivebackup
- $ORACLE_HOME/bin/rman<<EOF
- connect target
- RUN {
- crosscheck backup;
- delete noprompt expired backup;
- report obsolete;
- delete noprompt obsolete;
- allocate channel c1 device type disk;
- allocate channel c2 device type disk;
- allocate channel c3 device type disk;
- allocate channel c4 device type disk;
- backup full skip inaccessible tag yjsdb$DATE filesperset 5 format '/backup/yjsdb/$DATE/bak_%U_%s_%T.db' (database);
- release channel c1;
- release channel c2;
- release channel c3;
- release channel c4;
- sql 'alter system archive log current';
- allocate channel d1 type disk MAXPIECESIZE = 4G;
- allocate channel d2 device type disk;
- backup tag yjsdb_arc$DATE archivelog all format='/backup/yjsdb/$DATE/archivebackup/arc_%d_%s_%p.bak' delete all input;
- backup spfile format '/backup/yjsdb/$DATE/spfileYJSDB_%s_%t';
- release channel d1;
- release channel d2;
- allocate channel d3 device type disk;
- backup tag yjsdb_ctl$DATE format '/backup/yjsdb/$DATE/contrl_%s_%p_%t' current controlfile;
- release channel d31;
- }
- exit;
- EOF
0 0
- Oracle rman 全备脚本
- Oracle RMAN 全备 脚本
- script:RMAN 全备脚本
- RMAN全备份脚本
- Rman 备份脚本全
- 【ORACLE 备份】rman多通道全备份脚本
- oracle rman全备恢复实践
- Oracle RMAN-全备份
- Oracle RMAN备份脚本
- Oracle-rman脚本
- oracle rman备份脚本
- oracle rman 恢复脚本
- Oracle RMAN备份脚本
- oracle rman 备份脚本
- Oracle Rman-备份脚本
- [Rman]Oracle Rman增量备份Level012脚本
- ORACLE 数据库 rman 全备份
- oracle rman 备份数据库脚本
- openstack windows下远程debug调试(komodo)
- svn 更换IP eclipse 提交没有变更前的代码
- c#调用c语言dll,形参有char*
- ssh无密码远程登录-自己总结整理
- 在Ubuntu14.04上编写第一个GTK+3.
- Oracle RMAN 全备 脚本
- Android推送方案分析(MQTT/XMPP/GCM)
- 香港微视传媒合法吗?
- NGUI例子1
- 比较帖子发布时间和当前时间
- cannot call methods on dialog prior to initialization; attempted to call method 'close'
- DOS win7 生成目录树
- Web 开发与设计语言大盘点
- OpenStack文件注入相关分析(转载)