RE: Lost of all Control Files

[lhoska]

I said if you've done it before..Otherwise you're right :-(.

May be a call Oracle support would help.

-----Original Message-----
From: Ramon Estevez [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 3:48 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Lost of all Control Files

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