RE: Lost of all Control Files

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Wed, 15 Aug 2001 13:24:39 -0700
Message-ID: <F001.0036C0CC.20010815132032@fatcity.com>

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_at_codet       To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>  
                    el.net.do>                 cc:                                     
                             
                    Sent by:                   Subject:     RE: Lost of all Control 
Files                           
                    root_at_fatcity.com                                                   
                             
                                                                                       
                             
                                                                                       
                             
                    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
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-----
     From: Ramon Estevez [mailto:com.banilejas_at_codetel.net.do]
     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
          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-----
                From: Ramon Estevez [mailto:com.banilejas_at_codetel.net.do]
                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
                com.banilejas_at_codetel.net.do
                809-565-3121

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: DBarbour_at_austin.isd.tenet.edu

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: 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:24:39 CDT