11g duplicate database | RMAN-05001 conflict name of archive log
743412Jul 17 2010 — edited Jul 18 2010hi 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 !!