OK. You need to manually create a new controlfile. It requires great
attention to detail. Syntax and an example can be found at
http://hojohn.photo.net/ora81/DOC/server.815/a67779/ch4f.htm#20116
Scroll down to "CREATE CONTROLFILE".
You must list all members of all redo log file groups after LOGFILE and you
must list all datafiles after DATAFILE. If you don't know this information
then CREATE CONTROLFILE will be worse than useless.
Good luck.
"Ramon Estevez"
<com.banilejas@codet To: Multiple recipients of list
ORACLE-L
el.net.do> <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Lost of all Control
Files
08/15/2001 03:47 PM
Please respond to
ORACLE-L
Hi Lyuda,
Alter database backup controlfile to trace doesn't work because the DB
doesn't mount. :-(
Ramon E. Estevez
[EMAIL PROTECTED]
809-565-3121
-----Mensaje original-----
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de
[EMAIL PROTECTED]
Enviado el: Wednesday, 15 August, 2001 2:01 PM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Lost of all Control Files
If� did 'alter database backup control file to trace'� prior to your
control files going bad check your user dump directory.� Open that control
file (it'll have .trc extension).� They syntax will be right there.� You
will have to edit it deleting unnecessary info.
HTH,
[Lyuda Hoska]
�-----Original Message-----
Sent: Wednesday, August 15, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L
Thanks,
And what is the sintax of the create controlfile command ?
How do I use it ?
Now I will backup them :-)
Ramon E. Estevez
[EMAIL PROTECTED]
809-565-3121
-----Mensaje original-----
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Djordje
Jankovic
Enviado el: Wednesday, 15 August, 2001 10:37 AM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Lost of all Control Files
If all three are corrupted, you have to run the "create controlfile"
statement and to make sure that you list all your data files and redo
logs.� You will loose the archiving and RMAN (if you have it) info though.
At least you will not forget now to backup control files regularly ;-).
Djordje
-----Original Message-----
Sent: Wednesday, August 15, 2001 10:22 AM
To: Multiple recipients of list ORACLE-L
Hi gurus,
When my DB is starting I am getting an error of corrupt block in
controlfile (block 1, block #1)
Ora-00202 'c:\oracle\oradata\control01.con'
Ora-00207
I have 3 controlfiles, no copies, sorry, shame.
In the init.ora I commented the line of the control file No1, then it
gives me the error in the No 2, then commented line of Control No 2, and
continues the error.
Don't know what to do.
I don't have backups of the control files.
Saludos,
Ramon E. Estevez
[EMAIL PROTECTED]
809-565-3121
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
