加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

RMAN备份脚本

发布时间:2020-12-12 13:27:54 所属栏目:百科 来源:网络整理
导读:? 单机环境全备 ? export ORACLE_BASE=/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export ORACLE_SID=hncdfpos001 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export PATH=$ORACLE_HOME/bin:$PATH rman target / log /backup/hncdfpos00
? 单机环境全备 ? export ORACLE_BASE=/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export ORACLE_SID=hncdfpos001 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export PATH=$ORACLE_HOME/bin:$PATH rman target / log /backup/hncdfpos001/rman_full.log append<<EOF run {allocate channel c1 type disk; allocate channel c2 type disk; backup database filesperset 4 format ‘/backup/hncdfpos001/full_%d_%T_%s_%p‘; sql ‘alter system archive log current‘; backup archivelog all format ‘/backup/hncdfpos001/arch_%d_%T_%s_%p‘ delete input; backup current controlfile format ‘/backup/hncdfpos001/ctl_%d_%T_%s_%p‘; crosscheck backup; crosscheck archivelog all; delete noprompt obsolete; delete noprompt? expired backup; delete noprompt? expired archivelog all; } EOF ? ? 单机环境备归档 ? export ORACLE_BASE=/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export ORACLE_SID=hncdfpos001 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export PATH=$ORACLE_HOME/bin:$PATH rman target / log /backup/hncdfpos001/rman_arch.log append<<EOF run {allocate channel c1 type disk; allocate channel c2 type disk; sql ‘alter system archive log current‘; backup archivelog all format ‘/backup/hncdfpos001/arch_%d_%T_%s_%p‘ delete input; backup current controlfile format ‘/backup/hncdfpos001/ctl_%d_%T_%s_%p‘; crosscheck backup; crosscheck archivelog all; delete noprompt? expired backup; delete ?noprompt expired archivelog all; } EOF ? ? ? RAC环境全备 ? run { allocate channel c1 device type disk connect ‘sys/ [email?protected]‘; allocate channel c2 device type disk connect ‘sys/ [email?protected]‘; backup database database format ‘/backup/rmanbak/db_full_%T_%d_%t_%s_%p_bak0‘; sql ‘alter system archive log current‘; backup archivelog all format ‘/backup/rmanbak/arch_%T_%d_%t_%s_%p_bak0‘ delete input; backup current controlfile format ‘/backup/rmanbak/controlfile_%T_%d_%t_%s_%p_bak0‘; backup spfile format ‘/backup/rmanbak/spfile_%T_%d_%t_%s_%p_bak0‘; crosscheck backup; crosscheck archivelog all; delete noprompt obsolete; delete noprompt expired backup; delete noprompt expired archivelog all; release channel c1; release channel c2; }

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读