linux下RMAN全备脚本

最新推荐文章于 2024-08-12 16:42:24 发布

congzhirou8448

最新推荐文章于 2024-08-12 16:42:24 发布

阅读量300

点赞数

文章标签：数据库

export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/11.2.0.4/db_1
export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
export ORACLE_SID=JDE
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
#export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
date_format=`date +%y-%m-%d`

rman target / nocatalog log /oracle/rman/rman_log/rman_full_JDE_${date_format}.log <<EOF
run
{allocate channel c1 type disk;
allocate channel c2 type disk;
backup filesperset 10 database format '/oracle/rman/databak/full_%d_%T_%s_%p.bak';
sql 'alter system archive log current';
sql 'alter system archive log current';
sql 'alter system archive log current';
backup archivelog all format '/oracle/rman/archive_bak/arch_%d_%T_%s_%p.bak';
backup current controlfile format '/oracle/rman/archive_bak/ctl_%d_%T_%s_%p.bak';
release channel c1;
release channel c2;
}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30491527/viewspace-2121110/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30491527/viewspace-2121110/