Home » RDBMS Server » Backup & Recovery » Very urgent: recovery without control file!
Very urgent: recovery without control file! [message #103274] Fri, 11 April 2003 01:11 Go to next message
Muhammad Waqas Shabir
Messages: 26
Registered: April 2003
Junior Member
Thanks for standing by!
I have my control file gone! How will i recover my database. Please Explain Step by step!
Thanking you in anticipation.
Re: Very urgent: recovery without control file! [message #103301 is a reply to message #103274] Fri, 09 May 2003 05:06 Go to previous message
Messages: 12
Registered: June 2002
Junior Member
You can create the control file using create control file statement. You can get the syntax from any other database.
In some other database login as dba and issue
Alter Database backup controlfile to trace;
By this you will get one trace file in Udump directory which shows you the syntax of control file.
In this syntax change all parameters according to your database.
All the best.
Previous Topic: register database error in rman tool
Next Topic: RMAN...can not restore or recover tablespace
Goto Forum:

Current Time: Fri Jun 02 06:06:55 CDT 2023