CREATE CONTROLFILE- HELP!!

From: Brian Schanblatt <brigo_at_u3.farm.idt.net>
Date: 1998/05/04
Message-ID: <6ikds5$a0b_at_u3.farm.idt.net>#1/1

Hello and Help!!.
We are:
RISC 6000 AIX 4.1.2
ORACLE 7.3.3.4 (Please respond by email:
bshan_at_ymail.yu.edu)

I know that "cloning" a database by issuing a create controlfile command is not officially supported by by ORACLE. However, we have done this successfully in the past with ORACLE 7.1.6. i We upgraded to 7.3.3.4 in January and now we are trying to clone our Production (YUPROD) instance into a test instance (YUTEST). It does not work. We get an error that says that another instance has  the same database mounted. When I check the trace file, it says that YUPROD: /u01/oracle/home/product/7.1.6
has the same database mounted! This cannot be possible. There are no 7.1.6 instances running.
In fact ALL databses are down when I try this.

I HAVE successfully cloned our other 7.3.3 databases just to see if it works. it does.

I have even cloned our current TEST 7.3.3 database which itself was a clone of our PROD when it was a 7.1.6 database.

I have checked out my create controlfile syntax by running the copy controlfile to trace on the existing PROD database.

It appears that only that specific database has a problem. The errors:

ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/u04/cloneprod/syst_YUFATEST_01.dbf'
ORA-09782: sfifi: another instance has the same database mounted.

Is it possible that the system tablespace or system datafiles are corrupt in some way? Is there a way to repair the datafiles or system tablespace? I considered renaming the datafiles,
per ORACLE 7.3.3 documentation, but you need to have the  database mounted - which you can't do without control files!! I would prefer not to do the ORACLE supported  import/export to create a copy of our production system,  but I am getting desparate.
Any suggestions/comments/criticisms/flames will be very much appreciated.

Below is my cloning script:

---

connect internal
startup nomount
create controlfile
set database YUTEST RESETLOGS

logfile group 1 ('/u03/oradata/YUTEST/redo_YUTEST_01.dbf') size 3M,
        group 2 ('/u03/oradata/YUTEST/redo_YUTEST_02.dbf') size 3M,
        group 3 ('/u03/oradata/YUTEST/redo_YUTEST_03.dbf') size 3M
datafile '/u03/oradata/YUTEST/syst_YUTEST_01.dbf' ,


         '/u03/oradata/YUTEST/syst_YUTEST_02.dbf' ,

         '/u03/oradata/YUTEST/syst_YUTEST_03.dbf' ,

         '/u03/oradata/YUTEST/rlbk_YUTEST_01.dbf' ,

         '/u03/oradata/YUTEST/tool_YUTEST_01.dbf' ,

         '/u03/oradata/YUTEST/temp_YUTEST_01.dbf' ,

         '/u03/oradata/YUTEST/devl_YUTEST_01.dbf' ,

         '/u03/oradata/YUTEST/devl_YUTEST_02.dbf' ,

         '/u03/oradata/YUTEST/devl_YUTEST_03.dbf' ,

         '/u03/oradata/YUTEST/devl_YUTEST_04.dbf' ,

         '/u03/oradata/YUTEST/devl_YUTEST_05.dbf' ,

         '/u03/oradata/YUTEST/user_YUTEST_01.dbf' ,


         '/u03/oradata/YUTEST/user_YUTEST_02.dbf' ;

Received on Mon May 04 1998 - 00:00:00 CEST