Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RMAN - Duplicate DB

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

 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>
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Feb 20 2005 - 16:30:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US