RMAN - Duplicate DB

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sun, 20 Feb 2005 16:27:38 -0500
Message-ID: <f09dd62805022013274c4ff4b2@mail.gmail.com>

Enviornment : Oracle 9.2.0.6

I did follow metalink Note:228257.1 to create duplicate db on the same host. It got falied with an error

ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/u01/oradata/auxdb/control01.ctl'
ORA-17502: ksfdcre:4 Failed to create file /u01/oradata/auxdb/control01.ctl
ORA-17500: ODM err:ODM ERROR V-41-4-17 File exists

When I started this process there was no controlfile /u01/oradata/auxdb/control01.ctl.

Enclosed is the snippet of the RMAN output

:
:

archive log filename=/u04/archive/auxdb/1_77.dbf recid=22 stamp=550772275 channel clone_default: deleting archive log(s) archive log filename=/u04/archive/auxdb/2_44.dbf recid=24 stamp=550772276 media recovery complete
Finished recover at 20-FEB-05

printing stored script: Memory Script
{

shutdown clone;
startup clone nomount ;
}
executing script: Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started) Oracle instance started

Total System Global Area 336595504 bytes

Fixed Size                      731696 bytes
Variable Size                301989888 bytes
Database Buffers              33554432 bytes
Redo Buffers                    319488 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "AUXDB" RESETLOGS ARCHIVELOG

  MAXLOGFILES     64
  MAXLOGMEMBERS      3
  MAXDATAFILES      254
  MAXINSTANCES    32
  MAXLOGHISTORY      226

LOGFILE
  GROUP 1 ( '/u04/oradata/auxdb/redo01a.log',
'/u04/oradata/auxdb/redo01b.log' ) SIZE 204800 REUSE,
  GROUP 2 ( '/u04/oradata/auxdb/redo02a.log',
'/u04/oradata/auxdb/redo02b.log' ) SIZE 204800 REUSE
DATAFILE
  '/u04/oradata/auxdb/system01.dbf'
CHARACTER SET UTF8

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 02/20/2005 16:19:25 RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed

ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/u01/oradata/auxdb/control01.ctl'
ORA-17502: ksfdcre:4 Failed to create file /u01/oradata/auxdb/control01.ctl
ORA-17500: ODM err:ODM ERROR V-41-4-17 File exists
  MAXLOGFILES     64
  MAXLOGMEMBERS      3
  MAXDATAFILES      254
  MAXINSTANCES    32
  MAXLOGHISTORY      226

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Feb 20 2005 - 16:30:36 CST