<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>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>===========================================================================
Michael P.
Vergara
Oracle
DBA
Guidant
Corporation
(909)
914-2304
Received on Wed Aug 15 2001 - 15:45:58 CDT
