Veritas FlashSnap Point-In-Time Copy Solutions 5.0.1 Administrators Guide, HP-UX 11i v3, First Edition, November 2009

ALTER SYSTEM ARCHIVE LOG ALL;
# Database can now be opened normally.
ALTER DATABASE OPEN;
# No tempfile entries found to add.
#
SQL script to create a control file
The following example shows the 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
;
Initialization file for original production database
The following example shows the initialization file for the original production
database.
#==================================================================+
# FILENAME initdbase.ora
# DESCRIPTION Oracle parameter file for primary database, dbase.
#==================================================================
db_block_size = 8192
Preparing a replica Oracle database
SQL script to create a control file
102