Home » RDBMS Server » Backup & Recovery » control file missing
icon3.gif  control file missing [message #232538] Sat, 21 April 2007 01:15 Go to next message
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??
Re: control file missing [message #232542 is a reply to message #232538] Sat, 21 April 2007 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: control file missing [message #232547 is a reply to message #232542] Sat, 21 April 2007 01:40 Go to previous messageGo to next message
sanjay_kant
Messages: 25
Registered: February 2007
Junior Member

how to search parameters in memory.????
Re: control file missing [message #232552 is a reply to message #232547] Sat, 21 April 2007 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: control file missing [message #232557 is a reply to message #232552] Sat, 21 April 2007 02:49 Go to previous messageGo to next message
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
Re: control file missing [message #232562 is a reply to message #232538] Sat, 21 April 2007 04:21 Go to previous message
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
Previous Topic: Recovering Tablespace in Maintenance from Production database backup
Next Topic: how to backup
Goto Forum:
  


Current Time: Sun Dec 04 14:28:47 CST 2016

Total time taken to generate the page: 0.08307 seconds