From NDATFM@labor.state.ny.us Thu, 16 Aug 2001 07:59:47 -0700 From: "Mercadante, Thomas F" Date: Thu, 16 Aug 2001 07:59:47 -0700 Subject: RE: Lost of all Control Files Message-ID: MIME-Version: 1.0 Content-Type: text/plain "I just paid my price."   We all feel your pain. Tom Mercadante Oracle Certified Professional -----Original Message-----From: Ramon Estevez [mailto:com.banilejas@codetel.net.do]Sent: Thursday, August 16, 2001 11:23 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Lost of all Control Files   -----Mensaje original-----De: Ramon Estevez [mailto:com.banilejas@codetel.net.do]Enviado el: Thursday, 16 August, 2001 9:23 AMPara: 'ORACLE-L@fatcity.com'Asunto: RE: Lost of all Control Files Friends   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.   I just paid my price.   Gracias,   Ramon E. Estevez com.banilejas@codetel.net.do 809-565-3121 -----Mensaje original-----De: root@fatcity.com [mailto:root@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 Ramon:   Here's a copy of the script generated by the 'alter database backup controlfile to trace' command on my sandbox machine. Basically, you trim off everything above the 'STARTUP MOUNT' command, start svrmgrl, and execute the script.   Remember, you need to put in your own database name, path names, and file names.  If you don't know your database's file locations you'll have to go hunting.  This is for an 8.1.6 database - I forget what version you're using.  The only significant difference will be the 'ADD TEMPFILE' command at the end - that is for 8iR2 and higher.   I recommend that since you're unfamiliar with this technique, that you create a test database, delete the control files, and practice running this script there until you're confident that you can run it against production.   Good Luck! 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@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> --- =========================================================================== Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304