How to recover control file without backup and without 'create control file' command?

Mohammed Abdul Afroze

• Oct 4th, 2007

 

If we lost the controlfile and there is no controlfile backup trace. The only soln is for that is recreate the controlfile script by own.

sanjayoracle

 Profile Answers by sanjayoracle 

• Apr 24th, 2008

 

if we don;t have any backup of Controlfile...then we have to use create controlfile command..

chetan.ind

 Profile Answers by chetan.ind 

• Mar 18th, 2009

 

If this is the situation, simple process is :

1. Take a trace of control file from clone do the changes in that like database name and datafile name and location.
2. Save it as < name >.ora
3. Run the file in nomount stage.
 
This will create your control file .

Note : Always make a habit of taking control file trace with the cold back.