oracle 11g rman备份脚本配置
新创建了一台oracle 11g服务器，将原oracle服务器的rman备份脚本CP过来执行，不能正常备份，请问要修改什么配置吗？
以下是rman的备份脚本：
. /home/oracle/.bash_profile
RMAN_LOG_FILE=/oralcerman/hotbackup.out
if [ -f "$RMAN_LOG_FILE" ]
then
rm -f "$RMAN_LOG_FILE"
fi
echo >> $RMAN_LOG_FILE
chmod 666 $RMAN_LOG_FILE
echo Script $0 >> $RMAN_LOG_FILE
echo ==== started on `date` ==== >> $RMAN_LOG_FILE
echo >> $RMAN_LOG_FILE
ORACLE_USER=oracle
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
$ORACLE_HOME/bin/rman target / msglog $RMAN_LOG_FILE append<
delete noprompt backupset completed before 'sysdate-10' tag='FULLDB';
delete noprompt backupset completed before 'sysdate-10' tag='ARCHIVELOG';
run {
allocate channel ch00 device type disk;
allocate channel ch01 device type disk;
backup database include current controlfile format '/oralcerman/dbfile/full%T_%u_%p_%d' tag='FULLDB';
sql 'alter system archive log current';
backup archivelog all format '/oraclerman/dbfile/arch%T_%u_%p_%d' tag='ARCHIVELOG';
delete noprompt archivelog until time 'sysdate-7';
release channel ch00;
release channel ch01;
}
EOF
以下是rman的备份脚本：
. /home/oracle/.bash_profile
RMAN_LOG_FILE=/oralcerman/hotbackup.out
if [ -f "$RMAN_LOG_FILE" ]
then
rm -f "$RMAN_LOG_FILE"
fi
echo >> $RMAN_LOG_FILE
chmod 666 $RMAN_LOG_FILE
echo Script $0 >> $RMAN_LOG_FILE
echo ==== started on `date` ==== >> $RMAN_LOG_FILE
echo >> $RMAN_LOG_FILE
ORACLE_USER=oracle
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
$ORACLE_HOME/bin/rman target / msglog $RMAN_LOG_FILE append<
delete noprompt backupset completed before 'sysdate-10' tag='FULLDB';
delete noprompt backupset completed before 'sysdate-10' tag='ARCHIVELOG';
run {
allocate channel ch00 device type disk;
allocate channel ch01 device type disk;
backup database include current controlfile format '/oralcerman/dbfile/full%T_%u_%p_%d' tag='FULLDB';
sql 'alter system archive log current';
backup archivelog all format '/oraclerman/dbfile/arch%T_%u_%p_%d' tag='ARCHIVELOG';
delete noprompt archivelog until time 'sysdate-7';
release channel ch00;
release channel ch01;
}
EOF
10同行回答
超级专家说你的归档日志没有开。收起
楼主，认认真真查看日志，会有很大帮助！收起
浏览1372
浏览1409
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode收起
浏览1345
浏览1317
浏览1430
此脚应用的原数据库也oracle 11g的，以下是脚本备份反馈报告：
Script ./rmanbackup.sh
==== started on 2014年 12月 22日 星期一 17:22:01 CST ====
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Dec 22 17:22:01 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1392273691)
RMAN>
using target database control file instead of recovery catalog
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: SID=192 device type=DISK
RMAN>
specification does not match any backup in the repository
RMAN>
specification does not match any backup in the repository
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10>
allocated channel: ch00
channel ch00: SID=10 device type=DISK
allocated channel: ch01
channel ch01: SID=71 device type=DISK
Starting backup at 22-DEC-14
channel ch00: starting full datafile backup set
channel ch00: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ch00 channel at 12/22/2014 17:22:02
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ch00: starting full datafile backup set
channel ch00: specifying datafile(s) in backup set
channel ch01: starting full datafile backup set
channel ch01: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ch01 channel at 12/22/2014 17:22:02
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ch01: starting full datafile backup set
channel ch01: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ch01: starting piece 1 at 22-DEC-14
including current control file in backup set
channel ch00: starting piece 1 at 22-DEC-14
channel ch01: finished piece 1 at 22-DEC-14
piece handle=/oraclerman/dbfile/full20141222_08pqqnpq_1_ORCL tag=FULLDB comment=NONE
channel ch01: backup set complete, elapsed time: 00:00:01
channel ch00: finished piece 1 at 22-DEC-14
piece handle=/oraclerman/dbfile/full20141222_06pqqnpq_1_ORCL tag=FULLDB comment=NONE
channel ch00: backup set complete, elapsed time: 00:00:02
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch01 channel at 12/22/2014 17:22:02
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on ch00 channel at 12/22/2014 17:22:02
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN>
Recovery Manager complete.收起
Script ./rmanbackup.sh
==== started on 2014年 12月 22日 星期一 17:22:01 CST ====
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Dec 22 17:22:01 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1392273691)
RMAN>
using target database control file instead of recovery catalog
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: SID=192 device type=DISK
RMAN>
specification does not match any backup in the repository
RMAN>
specification does not match any backup in the repository
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10>
allocated channel: ch00
channel ch00: SID=10 device type=DISK
allocated channel: ch01
channel ch01: SID=71 device type=DISK
Starting backup at 22-DEC-14
channel ch00: starting full datafile backup set
channel ch00: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ch00 channel at 12/22/2014 17:22:02
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ch00: starting full datafile backup set
channel ch00: specifying datafile(s) in backup set
channel ch01: starting full datafile backup set
channel ch01: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ch01 channel at 12/22/2014 17:22:02
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ch01: starting full datafile backup set
channel ch01: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ch01: starting piece 1 at 22-DEC-14
including current control file in backup set
channel ch00: starting piece 1 at 22-DEC-14
channel ch01: finished piece 1 at 22-DEC-14
piece handle=/oraclerman/dbfile/full20141222_08pqqnpq_1_ORCL tag=FULLDB comment=NONE
channel ch01: backup set complete, elapsed time: 00:00:01
channel ch00: finished piece 1 at 22-DEC-14
piece handle=/oraclerman/dbfile/full20141222_06pqqnpq_1_ORCL tag=FULLDB comment=NONE
channel ch00: backup set complete, elapsed time: 00:00:02
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch01 channel at 12/22/2014 17:22:02
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN-03009: failure of backup command on ch00 channel at 12/22/2014 17:22:02
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN>
Recovery Manager complete.收起
浏览1461
