Veritas Storage Foundation 5.0 for Oracle RAC Configuration Guide Extracts for HP Serviceguard Storage Management Suite, Second Edition, May 2008

Using Storage Checkpoints and Storage Rollback
Examples of Using the Command Line Interface
Chapter 4
64
To clone an Oracle instance with manual Oracle recovery
•Use the dbed_clonedb command as follows:
$ /opt/VRTS/bin/dbed_clonedb -S NEW9 -m /local/oracle9/1 \
-c Checkpoint_988813047 -i
Primary Oracle SID is TEST10g
New Oracle SID is NEW9
Checkpoint_988813047 not mounted at /local/oracle9/1
Mounting Checkpoint_988813047 at /local/oracle9/1
Using environment-specified parameter file
/local/oracle9/links/dbs/initTEST10g.ora
Default Oracle parameter file found:
/local/oracle9/links/dbs/initTEST10g.ora
Copying /local/oracle9/links/dbs/initTEST10g.ora to
/local/oracle9/1/testvol
Control file 'ora_control2' path not explicitly specified in init
file; assuming ORACLE_HOME/dbs
All redo-log files found
Copying initTEST10g.ora to initNEW9.ora
in /local/oracle9/1/testvol
Altering db_name in initNEW9.ora
Altering control file locations in initNEW9.ora
Creating new link for clone database init file
Creating archive log directory
About to start up new database and begin reconfiguration
Database NEW9 is being reconfigured
Altering clone database archive log directory
Updating log_archive_dest in clone database init file
Found archive log destination at /testvol
The latest archive log(s) must now be applied. To apply the logs, open
a new window and perform the following steps:
1. copy required archive log(s) from primary to clone:primary archive
logs in /testvolclone archive logs expected in
/local/oracle9/1/testvol
2. ORACLE_SID=NEW9; export ORACLE_SID # sh and ksh, OR setenv
ORACLE_SID NEW9 #csh
3. /local/oracle9/links/bin/sqlplus /nolog
-o restartdb Mounts the Storage Checkpoint file system and starts the clone
database. The -o restartdb option will not attempt to recover the
clone database.
-d Used with the -o umount option. If the -d option is specified,
the Storage Checkpoint used to create the clone database is
removed along with the clone database.
Table 4-13 dbed_clonedb Command Options (Continued)
Option Description