Veritas Storage Foundation 5.1 SP1 Advanced Features Administrator"s Guide (5900-1503, April 2011)
Text control file for original production database
The following example shows the text control file for the original production
database.
/oracle/816/admin/dbase/udump/dbase_ora_20480.trc
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
ORACLE_HOME = /oracle/816
System name: SunOS
Node name: node01
Release: 5.8
Version: Generic_108528-02
Machine: sun4u
Instance name: dbase
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 20480, image: oracle@node01
*** SESSION ID:(#.##) YYYY-MM-DD hh:mm:ss.sss
*** YYYY-MM-DD hh:mm:ss.sss
# 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 NOMOUNT
CREATE CONTROLFILE REUSE DATABASE “DBASE” NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 70
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 ’/dbase_vol/log1’ SIZE 52428288,
# .
# . List of log files
# .
GROUP N ’/dbase_vol/logN’ SIZE 52428288
DATAFILE
’/dbase_vol/ts1’,
# .
# . List of tablespace datafiles
529Preparing a replica Oracle database
Text control file for original production database