Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

11g duplicate database | RMAN-05001 conflict name of archive log

743412Jul 17 2010 — edited Jul 18 2010
hi all
i m try to duplicate database on remote host....
directory is somewhat diffrent so i applied this mathod to duplicate but i m getting below errors !!!

RMAN> run
2> {set newname for datafile 1 to '/u01/TEST11/sysaux11.dbf';
3> set newname for datafile 2 to '/u01/TEST11/sysaux011.dbf';
4> set newname for datafile 3 to '/u02/TEST11/undotbs11.dbf';
5> set newname for datafile 4 to '/u02/TEST11/users11.dbf';
6> set newname for datafile 5 to '/u01/TEST11/AKI1_perfstat1.dbf';
7> set newname for tempfile 1 to '/u01/TEST11/temp11.dbf';
8> duplicate target database to test11 from active database
9> logfile
10> group 1 ('/u00/TEST11/redo/redo01a.log','/u00/TEST11/redo/redo01b.log') size 10m reuse,
11> group 2 ('/u00/TEST11/redo/redo02a.log','/u00/TEST11/redo/redo02b.log') size 10m reuse;
12> }
************** it went fine upto here ******************

sql statement: alter system archive log current
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TEST11" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/u00/TEST11/redo/red i o01a.log', '/u00/TEST11/redo/redo01b.log' ) SIZE 10 M REUSE,
GROUP 2 ( '/u00/TEST11/redo/redo02a.log', '/u00/TEST11/redo/redo02b.log' ) SIZE 10 M REUSE
DATAFILE
'/u01/TEST11/sysaux11.dbf'
CHARACTER SET WE8MSWIN1252

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/17/2010 19:31:47
RMAN-05001: auxiliary file name /u02/TEST11/arch/1_15_724095580.dbf conflicts with a file used by the target database


finally i applied this command still

i made similar directories and applied below commands

duplicate target database to test11 from active database nofilenamecheck;

but still got errors at end


RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/17/2010 20:33:51
RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed
ORA-01504: database name 'TEST11' does not match parameter db_name 'TEST7'


can you guys please help me setting correct this error !!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 15 2010
Added on Jul 17 2010
2 comments
1,760 views