OraFAQ Forum: Server Administration » Problem ReCreating ControlFile (urgent)

Home » RDBMS Server » Server Administration » Problem ReCreating ControlFile (urgent)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem ReCreating ControlFile (urgent) [message #56945]

Thu, 08 May 2003 14:09

Alex
Messages: 190
Registered: August 1999

Senior Member

I lost the controlfile, I am trying to recreate control file and oracle shows me some stupied errors

After executing CREATE CONTROLFILE statement I get

ORA-01503: CREATE CONTROLFILE failed
ORA-01158: database already mounted

!!! My database is not mounted, because ControlFile does not exist, so Oracle's Errors messessage doesn't make any sense.

-----------------------------------------------------
-- I run :

CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS NOARCHIVELOG
MAXLOGFILES 10
MAXLOGMEMBERS 1
MAXDATAFILES 300
MAXINSTANCES 3
MAXLOGHISTORY 60000
LOGFILE
GROUP 1 'E:ORANTDATABASELOG1ORCL.ORA' SIZE 1M,
GROUP 2 'E:ORANTDATABASELOG2ORCL.ORA' SIZE 1M,
GROUP 3 'E:ORANTDATABASELOG3ORCL.ORA' SIZE 1M
DATAFILE
'E:ORANTDATABASESYS1ORCL.ORA',
'Q:ORANTDATABASEUSR1ORCL.ORA',
'Q:ORANTDATABASERBS1ORCL.ORA',
'E:ORANTDATABASETMP1ORCL.ORA',
'Q:ORANTDATABASEUSR2ORCL.ORA',
'F:ORANTDATABASEUSR3ORCL.ORA',
'F:ORANTDATABASETMP2ORCL.ORA',
'G:ORANTDATABASEUSR4ORCL.ORA',
'G:ORANTDATABASEUSR5ORCL.ORA',
'G:ORANTDATABASEUSR6ORCL.ORA',
'G:ORANTDATABASEUSR7ORCL.ORA',
'D:ORANTDATABASEUSR8ORCL.ORA',
'D:ORANTDATABASETMP3ORCL.ORA',
'Q:ORANTDATABASEUSR8ORCL.ORA',
'F:ORANTDATABASEUSR9ORCL.ORA',
'G:ORANTDATABASEUSR10ORCL.ORA',
'Q:ORANTDATABASEUSR11ORCL.ORA',
'Q:ORANTDATABASESERDATA01.ORA',
'Q:ORANTDATABASEUSR12ORCL.ORA',
'Q:ORANTDATABASEUSR13ORCL.ORA',
'Q:ORANTDATABASETMP4ORCL.ORA',
'Q:ORANTDATABASEUSR16ORCL.ORA',
'Q:ORANTDATABASEUSR14ORCL.ORA',
'Q:ORANTDATABASESYS2ORCL.ORA',
'Q:ORANTDATABASEINDEXES01.ORA',
'Q:ORANTDATABASEBACKUP01.ORA',
'E:ORANTDATABASEUSR15ORCL.ORA',
'E:ORANTDATABASESERDATA02.ORA',
'Q:ORANTDATABASESERDATA03.ORA',
'Q:ORANTDATABASESERDATA04.ORA',
'Q:ORANTDATABASESERDATA05.ORA',
'Q:ORANTDATABASESERDATA06.ORA',
'Q:ORANTDATABASEUSR17ORCL.ORA',
'Q:ORANTDATABASEUSR18ORCL.ORA'
;

Report message to a moderator

Re:Problem ReCreating ControlFile (urgent) - Continue [message #56946 is a reply to message #56945]

Thu, 08 May 2003 14:14

Alex
Messages: 190
Registered: August 1999

Senior Member

Also in "orclALRT.log" I get the following:

Thu May 08 23:18:11 2003
ORA-09341: scumnt: unable to mount database
OSD-04400: unable to acquire internal semaphore for process
O/S-Error: (OS 183) Cannot create a file when that file already exists.

ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS...

Report message to a moderator

Re:Problem ReCreating ControlFile (urgent) - Continue [message #56947 is a reply to message #56946]

Thu, 08 May 2003 14:47

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

Since you are creating new control files, you need to make sure that the old control files are not present in that path.

Rename the old control files to something something else. (control01.ctl.old)

Good luck.

Report message to a moderator

Re:Problem ReCreating ControlFile (urgent) - Continue [message #56948 is a reply to message #56947]

Thu, 08 May 2003 15:11

Alex
Messages: 190
Registered: August 1999

Senior Member

I did Removed Old controlfiles

Report message to a moderator

Re: Problem ReCreating ControlFile (urgent) [message #56951 is a reply to message #56945]

Thu, 08 May 2003 23:04

mb
Messages: 51
Registered: March 2001

Member

Do you have control file mirrored to some other disk?
If yes then shutdown the database use OS command to copy it over to the place where it was existing then start and open the database.
MB

Report message to a moderator

Re:Problem ReCreating ControlFile (urgent) - Continue [message #56955 is a reply to message #56946]

Thu, 08 May 2003 23:48

K.K. Raj kumar
Messages: 33
Registered: July 2002

Member

You should ensure that the 'old' control file is not there. You can copy the old control file at some other directory and remove it, and then again run the script

Report message to a moderator

Previous Topic:	Oracle 9i installation on Caldera Open Unix 8
Next Topic:	how to create a vb script that deletes files older than 7 days??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:44:55 CDT 2024