Veritas FlashSnap Point-In-Time Copy Solutions 5.0 AdministratorÆs Guide, HP-UX 11i v3, First Edition, May 2008

ManualsBrandsHP ManualsSoftwareHP-UX 11i Volume Management (LVM/VxVM) Software

78 Preparing a replica Oracle database

SQL script to create a control file

SQL script to create a 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

;