RE: Lost of all Control Files

From: Ramon Estevez <com.banilejas_at_codetel.net.do>
Date: Thu, 16 Aug 2001 07:10:53 -0700
Message-ID: <F001.0036D0E0.20010816072322@fatcity.com>

 

  <FONT face=Tahoma
  size=2>-----Mensaje original-----De: Ramon Estevez   [mailto:com.banilejas_at_codetel.net.do]Enviado el: Thursday, 16   August, 2001 9:23 AMPara: 'ORACLE-L_at_fatcity.com'Asunto:   RE: Lost of all Control Files
  <SPAN
  class=955182114-16082001>Friends
  <SPAN
  class=955182114-16082001> 
  Thanks to
  all of you helped me with the problem. The create controlfile worked fine,   but
  the
  system tablespace needed recovery and unfortunately the archives were   corrupted too.
  <SPAN
  class=955182114-16082001> 
  I just
  paid my price.
  <SPAN
  class=955182114-16082001> 
  <SPAN
  class=955182114-16082001>Gracias,
   
  Ramon E. Estevez
  <A
  href="mailto:com.banilejas_at_codetel.net.do">com.banilejas_at_codetel.net.do   809-565-3121   

<FONT face=Tahoma

    size=2>-----Mensaje original-----De: root_at_fatcity.com     [mailto:root_at_fatcity.com]En nombre de Vergara, Michael     (TEM)Enviado el: Wednesday, 15 August, 2001 4:42     PMPara: Multiple recipients of list ORACLE-LAsunto:     RE: Lost of all Control Files
<SPAN

    class=288532620-15082001>Ramon:
<SPAN

    class=288532620-15082001> 
<SPAN

    class=288532620-15082001>Here's a copy of the script generated by the 'alter     database
<SPAN

    class=288532620-15082001>backup controlfile to trace' command on my sandbox     machine.
<SPAN

    class=288532620-15082001>Basically, you trim off everything above the     'STARTUP MOUNT'
<SPAN

    class=288532620-15082001>command, start svrmgrl, and execute the     script.
<SPAN

    class=288532620-15082001> 
<SPAN

    class=288532620-15082001>Remember, you need to put in your own database     name, path names,
<SPAN

    class=288532620-15082001>and file names.  If you don't know your     database's file locations
<SPAN

    class=288532620-15082001>you'll have to go hunting.  This is for an     8.1.6 database - I forget
<SPAN

    class=288532620-15082001>what version you're using.  The only     significant difference will be
<SPAN

    class=288532620-15082001>the 'ADD TEMPFILE' command at the end - that is for     8iR2 and higher.
<SPAN

    class=288532620-15082001> 
<SPAN

    class=288532620-15082001>I recommend that since you're <FONT 
    color=#0000ff face="Courier New" size=2><SPAN 
    class=288532620-15082001>unfamiliar with this technique, 

    that
<SPAN

    class=288532620-15082001>you create a test database, <FONT 
    color=#0000ff face="Courier New" size=2><SPAN 
    class=288532620-15082001>delete the control files, and 

    practice
<SPAN

    class=288532620-15082001>running this script there <FONT     color=#0000ff face="Courier New" size=2>until     you're confident that you can run
<SPAN

    class=288532620-15082001>it against production.      
<SPAN

    class=288532620-15082001>Good Luck!
<SPAN

    class=288532620-15082001>Mike
     
    rhc117:oracle8> cat
    ora_5472_dba2.trcDump file
    /ofa/u02/app/oracle/admin/DBA2/udump/ora_5472_dba2.trcOracle8i     Enterprise Edition Release 8.1.6.0.0 - ProductionWith the Partitioning     optionJServer Release 8.1.6.0.0 - ProductionORACLE_HOME =     /ofa/u02/app/oracle/product/8.1.6System name:   

    HP-UXNode name:      
    rhc117Release:        
    B.11.00Version:        
    AMachine:        9000/777Instance 

    name: DBA2Redo thread mounted by this instance: 1Oracle process     number: 11Unix process pid: 5472, image: oracle_at_rhc117      

• SESSION ID:(10.1) 2001-05-16 16:36:43.683*** 2001-05-16 16:36:43.683# The following commands will create a new control file and use it# to open the database.# Data used by the recovery manager will be lost. Additional logs may# be required for media recovery of offline data files. Use this# only if the current version of all online logs are available.STARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "DBA2" NORESETLOGS ARCHIVELOG    MAXLOGFILES 32    MAXLOGMEMBERS 2    MAXDATAFILES 255    MAXINSTANCES 8    MAXLOGHISTORY 907LOGFILE  GROUP 1 (    '/ofa/u01/oradata/oralog1a/DBA2/redo01a.log',    '/ofa/u01/oradata/oralog1b/DBA2/redo01b.log'  ) SIZE 5M,  GROUP 2 (    '/ofa/u01/oradata/oralog2a/DBA2/redo02a.log',    '/ofa/u01/oradata/oralog2b/DBA2/redo02b.log'  ) SIZE 5M,  GROUP 3 (    '/ofa/u01/oradata/oralog1a/DBA2/redo03a.log',    '/ofa/u01/oradata/oralog1b/DBA2/redo03b.log'  ) SIZE 5M,  GROUP 4 (    '/ofa/u01/oradata/oralog2a/DBA2/redo04a.log',    '/ofa/u01/oradata/oralog2b/DBA2/redo04b.log'  ) SIZE 5MDATAFILE  '/ofa/u01/oradata/DBA2/system01.dbf',  '/ofa/u01/oradata/DBA2/rbs01.dbf',  '/ofa/u02/oradata/DBA2/users01.dbf'CHARACTER SET US7ASCII;# Recovery is required if any of the datafiles are restored backups,# or if the last shutdown was not normal or immediate.RECOVER DATABASE# All logs need archiving and a log switch is needed.ALTER SYSTEM ARCHIVE LOG ALL;# Database can now be opened normally.ALTER DATABASE OPEN;# Commands to add tempfiles to temporary tablespaces.# Online tempfiles have complete space information.# Other tempfiles may require adjustment.ALTER TABLESPACE TEMP ADD TEMPFILE '/ofa/u01/oradata/DBA2/temp01.dbf' REUSE;# End of tempfile additions.#rhc117:oracle8>
  <FONT color=#0000ff face="Courier New"
  size=2>---
  <FONT color=#0000ff face="Courier New"
  size=2>=========================================================================== Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304

            Received on Thu Aug 16 2001 - 09:10:53 CDT