| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Lost of all Control Files
<SPAN
class=955182114-16082001>"I just paid my
price.<SPAN
class=706183014-16082001>"
We all
feel your pain.
Tom Mercadante <FONT face=Arial
size=2>Oracle Certified Professional
<FONT face=Tahoma
size=2>-----Original Message-----From: Ramon Estevez
[mailto:com.banilejas_at_codetel.net.do]Sent: Thursday, August 16,
2001 11:23 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Lost of all Control Files
<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><SPAN
class=288532620-15082001>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:59:47 CDT
 |
 |