bismita

 Profile Answers by bismita 

• Jan 22nd, 2009

 

If other files like datafile and log files are intact then take the back up
of the control file to trace directory as follows.

1. Open the database in nomount mode i.e. startup nomount;

2. Take the backup of control file i.e.

ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

3.The back of control file will be generated in trace directory.
copy the control file creation script from there and run here.
Now your control file will be created.
open the database i.e. alter database open;