Re: regenerate control file?
From: Mike Biggin <mbiggin_at_lands.sa.gov.au>
Date: 1996/10/04
Message-ID: <325499C4.2F1C_at_lands.sa.gov.au>#1/1
Date: 1996/10/04
Message-ID: <325499C4.2F1C_at_lands.sa.gov.au>#1/1
Joseph Lee wrote:
>
> Is there a way to regenerate the control file without wiping out my
> datafiles? That is, without creating a new database?
>
> Let's say backup control files are damaged as well.
> --
>
> Joseph S. Lee INRI
> (703)715-9605 x214
> ------------------
Yes!!
If you have a running database instance you can issue the following command from sqldba (or svrmgrl):-
ALTER DATABASE BACKUP CONTROLFILE TO TRACE; This will result in a 'STARTUP NOMOUNT;' AND 'CREATE CONTROLFILE .......' command being written to a trace file. You can then edit this file to extract the command script. Next step is to shutdown the database, after which you can run the script to regenerate the control files.
-- Mike Biggin (mbiggin_at_denr.sa.gov.au) Department of Environment and Natural Resources, South Australia Telephone: Oz: (08) 8204 9217; International: (618) 8204 9217 Mail: GPO Box 1047, ADELAIDE 5001 AustraliaReceived on Fri Oct 04 1996 - 00:00:00 CEST