| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Lost of all Control Files
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_at_codet To: Multiple recipients of list
ORACLE-L
el.net.do> <ORACLE-L_at_fatcity.com>
Sent by: cc:
root_at_fatcity.com 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
com.banilejas_at_codetel.net.do
809-565-3121
-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de
lhoska_at_calibresys.com
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
com.banilejas_at_codetel.net.do
809-565-3121
-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]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
com.banilejas_at_codetel.net.do
809-565-3121
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: tday6_at_csc.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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). Received on Wed Aug 15 2001 - 15:00:08 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |