OraFAQ Forum: Backup & Recovery » control file missing

Home » RDBMS Server » Backup & Recovery » control file missing

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

control file missing [message #232538]

Sat, 21 April 2007 01:15

sanjay_kant
Messages: 25
Registered: February 2007

Junior Member

How to recover database when we miss our control file and we dont have any backup of control file??

Report message to a moderator

Re: control file missing [message #232542 is a reply to message #232538]

Sat, 21 April 2007 01:30

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You search in your memory what are all your database parameters and files and where there are and you manually build a control file using the create controlfile statement.

But you should aways have at least 2 control files (on different disks) and regularly make backups.

Regards
Michel

Report message to a moderator

Re: control file missing [message #232547 is a reply to message #232542]

Sat, 21 April 2007 01:40

sanjay_kant
Messages: 25
Registered: February 2007

Junior Member

how to search parameters in memory.????

Report message to a moderator

Re: control file missing [message #232552 is a reply to message #232547]

Sat, 21 April 2007 02:13

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Myself, I think where should I put this bloody configuration form I fulled when I created the database.
For you, I don't know, have a look on your desktop.

memory here means something you have (or would have) between eyes and hair, just behind the forehead. Smile

Regards
Michel

Report message to a moderator

Re: control file missing [message #232557 is a reply to message #232552]

Sat, 21 April 2007 02:49

kamkan
Messages: 27
Registered: April 2007
Location: Chennai, INDIA

Junior Member

Hi,
Agree with Michel and in addition to that If u have the the alert log file atleast there u can find the init parameter values. Ur backup strategy shd take the trace of the control file atleast.

Kamal

Report message to a moderator

Re: control file missing [message #232562 is a reply to message #232538]

Sat, 21 April 2007 04:21

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
go through below link possible condition when controlfile missing or corrupted.

http://dbataj.blogspot.com/2007/04/all-control-file-lost-without-backup.html

http://dbataj.blogspot.com/2007/03/all-control-file-missing-without-backup.html

http://dbataj.blogspot.com/2007/03/control-file-inconsistent.html

http://dbataj.blogspot.com/2007/03/control-file-corrupted.html

Report message to a moderator

Previous Topic:	Recovering Tablespace in Maintenance from Production database backup
Next Topic:	how to backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 00:34:14 CDT 2024