Veritas Storage Foundation 5.1 SP1 Advanced Features Administrator"s Guide (5900-1503, April 2011)

# .
’/dbase_vol/tsN’
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;
# 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
;
Preparing a replica Oracle database
SQL script to create a control file
530