RE: ORA-09782 & ORA-09783

From: Gupta, Brijesh <Brijesh.Gupta_at_Airliquide.com>
Date: Mon, 18 Jun 2001 09:48:44 -0700
Message-ID: <F001.0032D40A.20010618090101@fatcity.com>

Here
is the problem . Use SET instead of REUSE
<SPAN

class=780245515-18062001> 
CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS ARCHIVELOG
<FONT face=Arial color=#0000ff

size=2>instead use
 

CREATE
CONTROLFILE SET DATABASE "PROD"
RESETLOGS ARCHIVELOG
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2>Brijesh

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Catherine LeBlanc   [mailto:cleblan2_at_abacus.bates.edu]Sent: Sunday, June 17, 2001 9:15   PMTo: Multiple recipients of list ORACLE-LSubject:   ORA-09782 & ORA-09783<FONT face="Courier, Courier"   size=3>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:----------------------------------------------------------------SVRMGR> 

  startup mountORACLE instance started.Total System Global   Area     169900992 bytesFixed

  Size                       

  50832 bytesVariable

  Size                 

  80024880 bytesDatabase
  Buffers             
  89620480 bytesRedo

  Buffers                    

  204800 bytesORA-00205: error in identifying controlfile   '/usr/u17/oradata/dbs/ctrl1PROD.ctl'ORA-09782: sfifi: another instance has   the same database mounted.SVRMGR> shutdownORA-01507: database not   mountedORACLE 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 bytesFixed

  Size                       

  50832 bytesVariable

  Size                 

  80024880 bytesDatabase
  Buffers             
  89620480 bytesRedo

  Buffers                    

  204800 bytesCREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS   ARCHIVELOG*ORA-01503: CREATE CONTROLFILE failedORA-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 directoryALTER DATABASE OPEN   RESETLOGS*ORA-01507: database not mountedORA-01507: database not   mountedORACLE 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 databasewas   shutdown during the copy. This happened before when I tried to change the   instance name, but I am notdoing 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 AnalystBates College,   Administrative
  Computingcleblan2_at_bates.edu        
  (207)786-6431Oracle7 Server Release 7.3.4.3Digital UNIX V4.0G (Rev.   1530) Received on Mon Jun 18 2001 - 11:48:44 CDT