Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
RMAN - Duplicate DB

RMAN - Duplicate DB

2005-02-20       - By Sami Seerangan


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 (See ORA-00200.ora-code.com): controlfile could not be created
ORA-00202 (See ORA-00202.ora-code.com): controlfile: '/u01/oradata/auxdb/control01.ctl'
ORA-17502 (See ORA-17502.ora-code.com): ksfdcre:4 Failed to create file /u01/oradata/auxdb/control01.ctl
ORA-17500 (See ORA-17500.ora-code.com): 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 (See ORA-01503.ora-code.com): CREATE
CONTROLFILE failed
ORA-00200 (See ORA-00200.ora-code.com): controlfile could not be created
ORA-00202 (See ORA-00202.ora-code.com): controlfile: '/u01/oradata/auxdb/control01.ctl'
ORA-17502 (See ORA-17502.ora-code.com): ksfdcre:4 Failed to create file /u01/oradata/auxdb/control01.ctl
ORA-17500 (See ORA-17500.ora-code.com): 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