Re: CREATE CONTROLFILE- HELP!!

I thought the command was 'alter database resetlogs'

Brian Schanblatt (brigo_at_u3.farm.idt.net) wrote:

: 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' ;

--
Jared Hecker	| HWA Inc. - Oracle architecture and Administration
jared_at_hwai.com	|  ** serving NYC and New Jersey **