I have a doubt,i Think, the control file will have OS files location
information,so when we recreate the
control file ,i dont think it will delete the OS files rather the OS files
informations will be missed.

Regards
Saravanan

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Monday, December 30, 2002 2:40 PM
To: LazyDBA.com Discussion
Subject: RE: loss of all control files


Yes recreate the control file but Rember that all the New Datafiles that you
added will be missing.. U need to Rename the Datafiles.

Then do a Restore Database Backup Control file;

That will do the trick.

Regards,
Ganesh R

PS : Remeber to a Take a Backup !!!


Oracle LazyDBA home page