Here
is the problem . Use SET instead of REUSE
CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS
ARCHIVELOG
instead use
CREATE
CONTROLFILE SET DATABASE "PROD"
RESETLOGS ARCHIVELOG
Brijesh
-----Original Message-----I am attempting to recreate a clone of our production database on our test machine and I get the following errors when I try to start it up:
From: Catherine LeBlanc [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 17, 2001 9:15 PM
To: Multiple recipients of list ORACLE-L
Subject: ORA-09782 & ORA-09783
----------------------------------------------------------------
SVRMGR> startup mount
ORACLE instance started.
Total System Global Area 169900992 bytes
Fixed Size 50832 bytes
Variable Size 80024880 bytes
Database Buffers 89620480 bytes
Redo Buffers 204800 bytes
ORA-00205: error in identifying control
file '/usr/u17/oradata/dbs/ctrl1PROD.ctl'
ORA-09782: sfifi: another instance has the same database mounted.
SVRMGR> shutdown
ORA-01507: database not mounted
ORACLE instance shut down.
-----------------------------------------------------------------
I dropped that control file and got the same error, and when I try creating new control files I get:
-----------------------------------------------------------------
ORACLE instance started.
Total System Global Area 169900992 bytes
Fixed Size 50832 bytes
Variable Size 80024880 bytes
Database Buffers 89620480 bytes
Redo Buffers 204800 bytes
CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS ARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/usr/u17/oradata/prod/syst_PROD.dbf'
ORA-09783: sfifi: Cannot determine if another instance has mounted the same database.
Digital Unix Error: 20: Not a directory
ALTER DATABASE OPEN RESETLOGS
*
ORA-01507: database not mounted
ORA-01507: database not mounted
ORACLE instance shut down.
---------------------------------------------------------------------------
I tried SET and NORESTLOGS, and rearranging the datafiles in the script,
all with no difference. The files definitely exist, and the source database
was shutdown during the copy.
This happened before when I tried to change the instance name, but I am not
doing that now. I know that this error occurs when cloning on the same machine
with the source database running, but I am on a totally different machine.
Does anyone know what Oracle checks internally that makes it think the
instance is mounted when it is not?
--
Catherine A. LeBlanc, Database Analyst
Bates College, Administrative Computing
[EMAIL PROTECTED] (207)786-6431
Oracle7 Server Release 7.3.4.3
Digital UNIX V4.0G (Rev. 1530)
