Pages

Wednesday 22 April 2015

RMAN Duplicate fails with "ORA-01276: Cannot add file" error

NSTANCE 'i2'
  GROUP   5 ( '/oracle/oradata/teststby/group_5.264.789509951', '/oracle/oradata/teststby/group_5.296.789509953' ) SIZE 300 M  REUSE,
  GROUP   6 ( '/oracle/oradata/teststby/group_6.263.789509955', '/oracle/oradata/teststby/group_6.297.789509955' ) SIZE 300 M  REUSE,
  GROUP   7 ( '/oracle/oradata/teststby/group_7.274.789509957', '/oracle/oradata/teststby/group_7.298.789509959' ) SIZE 300 M  REUSE,
  GROUP   8 ( '/oracle/oradata/teststby/group_8.299.789510045', '/oracle/oradata/teststby/group_8.275.789510045' ) SIZE 300 M  REUSE
sql statement: ALTER DATABASE ADD LOGFILE

INSTANCE 'i3'
  GROUP  19 ( '/oracle/oradata/teststby/o1_mf_19_9hcqsyb9_.log' ) SIZE 100 M  REUSE,
  GROUP  20 ( '/oracle/oradata/teststby/o1_mf_20_9hcqsyhf_.log' ) SIZE 100 M  REUSE
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: aux
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/22/2015 02:22:55
RMAN-05501: aborting duplication of target database
RMAN-06136: ORACLE error from auxiliary database: ORA-01276: Cannot add file /oracle/oradata/teststby/o1_mf_19_9hcqsyb9_.log.  File has an Oracle Managed Files file name.

Reason:

OMF parameter set in the database, hence the file name cannot be specified while adding log file

Solution:

Remove following parameters if they are set in parameter file and rerun rman duplicate script

db_create_file_dest
db_create_online_log_dest_1
db_create_online_log_dest_2
db_recovery_file_dest


For more refer Oracle Doc ID:1926495.1