VERITAS FlashSnap Point-In-Time-Copy Solutions Administrator's Guide

Appendix B, Preparing a Replica Oracle Database
SQL Script to Create Control File
85
SQL Script to Create Control File
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE “REP1” RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 70
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 ’/rep/dbase_vol/log1’ SIZE 52428288,
# .
# . List of log files
# .
GROUP N ’/rep/dbase_vol/logN’ SIZE 52428288
DATAFILE
’/rep/dbase_vol/ts1’,
# .
# . List of tablespace datafiles
# .
’/rep/dbase_vol/tsN’
CHARACTER SET US7ASCII
;