Re: Recreating Control Files

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 30 Jul 2002 11:47:48 +1000
Message-ID: <L7m19.47072$Hj3.143453@newsfeeds.bigpond.com>

Hi Patrick,

Stretching the memory here but the CREATE CONTROLFILE statement was still the way to go here (with a nomounted database). The syntax is a bit verbose and requires you to know the name and location of all your data files and redo log files. Much easier if you previously saved a current copy of the syntax via a 'alter database backup controlfile to trace' statement.

Failing all that, you might have to restore a controlfile from backup and 'recover database using backup controlfile' (then open DB with resetlogs).

Check out the Backup and Recovery manual for more info.

Good Luck

Richard

"Patrick" <patrick.philpott_at_orcinc.com> wrote in message news:ebc0fc4b.0207291404.3a9e1103_at_posting.google.com...
> How can I recreate control files on Oracle 7.3 ?
>
> Thanks Patrick
Received on Mon Jul 29 2002 - 20:47:48 CDT