oracle 11g rman备份脚本配置
新创建了一台oracle 11g服务器，将原oracle服务器的rman备份脚本CP过来执行，不能正常备份，请问要修改什么配置吗？以下是rman的备份脚本：. /home/oracle/.bash_profileRMAN_LOG_FILE=/oralcerman/hotbackup.outif [ -f "$RMAN_LOG_FILE" ] then rm -f "$RMAN_LOG_FI...显示全部
查看其它 9 个回答chamberlinux的回答
此脚应用的原数据库也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.
浏览1463