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

CREATE CONTROLFILE SET DATABASE "ndb" RESETLOGS \
NOARCHIVELOG
where odb is the name of the original database and ndb is the name of the
replica database (DBASE and REP1 in the example). Note that to reduce
unnecessary overhead, the new database is not run in archive log mode.
See “SQL script to create a control file” on page 102.
8
Copy the Oracle initialization file for the original database to a new
initialization file for the replica database.
For example, the Oracle initialization file for the original database is shown
as initdbase.ora.
See “Initialization file for original production database” on page 102.
For example, the initialization file for the replica database is shown as
initREP1.ora.
See “Initialization file for replica Oracle database” on page 104.
Edit the copied file and change the definitions of the following parameters:
background_dump_dest Background dump location.
core_dump_dest Core dump location.
db_name Database name to the name of the replica database.
log_archive_dest Archive log location, set equal to the path created in step
4 (for example, /rep/dbase_arch).
log_archive_start Archive log mode, log_archive_start, to FALSE.
user_dump_dest User dump location.
You may also wish to reduce the resource usage of the new database by
adjusting the values of parameters such as db_block_buffers.
See the Oracle Database Administrator’s Guide for more information.
9
Copy the Oracle remote password file (for example, orapwdbase) in
$ORACLE_HOME/dbs to a new file (for example, orapwREP1).
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
Preparing a replica Oracle database
Text control file for original production database
100