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
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
No comments:
Post a Comment