nbu oracle备份脚本权限,NBU 6.0备份AIX下Oracle 的三个脚本

分别针对表空间，数据和日志的脚本

一、bktbs.sh

su - oracle << EOF

rman target /

run {

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' parms='ENV=(NB_ORA_POLICY=mis_tbs,NB_ORA_SERV=nbu)';

backup

TAG hot_tbs_bk_level0_whole

FORMAT 'df_%s_%p_%t'

tablespace users diskratio=0;

sql 'alter system archive log current';

RELEASE CHANNEL ch00;

}

EOF

二、bklog.sh

su - oracle << EOF

rman target /

run {

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' parms='ENV=(NB_ORA_POLICY=mis_log,NB_ORA_SERV=nbu)';

backup

incremental   level   0

skip   inaccessible

tag   hot_log_bk_level0

FORMAT 'log_%s_%p_%t'

archivelog all delete input diskratio=0;

RELEASE CHANNEL ch00;

}

EOF

三、bkdb.sh

su - oracle << EOF

rman target /

run {

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' parms='ENV=(NB_ORA_POLICY=mis_db,NB_ORA_SERV=nbu)';

backup

incremental   level   0

skip   inaccessible

tag   hot_db_bk_level0

FORMAT 'df_%s_%p_%t'

database diskratio=0;

sql 'alter system archive log current';

RELEASE CHANNEL ch00;

}

EOF

posted on 2007-07-16 17:30 David 阅读(1046) 评论(0)  编辑 收藏 引用 所属分类: 数据库应用技术 、存储网络