Re: Recreating Control Files

From: Steve <smontgomerie_at_hotmail.com>
Date: 30 Jul 2002 21:29:26 -0700
Message-ID: <156709aa.0207302029.2b664c8b@posting.google.com>

patrick.philpott_at_orcinc.com (Patrick) wrote in message news:<ebc0fc4b.0207291404.3a9e1103_at_posting.google.com>...
> How can I recreate control files on Oracle 7.3 ?
>
> Thanks Patrick

if you have a current working copy of the control file issue ALTER DATABASE BACKUP CONTROLFILE TO TRACE and then look in the udump dest for a trace file that you can easily edit
to recreate your control file.

If you don't have a valid copy of your control file take Richard's advice and create one from scratch...reference the SQL Ref guide for Create control file

steve Received on Tue Jul 30 2002 - 23:29:26 CDT