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;
}
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |