Ramon,
If you don't already have a .trc file in your udump directory (that's OFA)
with the 'CREATE CONTROLFILE' command embedded in it somewhere, then you're
just going to have to manually create a sql file with all the ingredients
needed to bring your DB back.
This command requires a thorough knowledge of what your database looked
like at the time you trashed the controlfiles. For the syntax of the
command, consult one of your reference books. If you haven't had a chance
to go out and get any yet, look on http://otn.oracle.com. You'll have to
register, but it's free, they don't hassle you, and there is certainly a
lot of good information available.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Ramon Estevez"
<com.banilejas@codet To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
el.net.do> cc:
Sent by: Subject: RE: Lost of all Control
Files
[EMAIL PROTECTED]
08/15/2001 02: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-----
From: Ramon Estevez [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Lost of all Control Files
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-----
From: Ramon Estevez [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 10:22 AM
To: Multiple recipients of list ORACLE-L
Subject: Lost of all Control Files
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).
