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
65
4. CONNECT / AS SYSDBA
5. RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE
6. enter the archive log(s) you wish to apply
7. EXIT
Press <Return> after you have completed the above steps.
<Return>
Resetting logs on new database NEW9
Database instance NEW9 is up and running
To clone an Oracle instance with automatic Oracle recovery
•Use the dbed_clonedb command as follows:
$ /opt/VRTS/bin/dbed_clonedb -S NEW9 -m /local/oracle9/1 \
-c Checkpoint_988813047
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
Starting automatic (full) database recovery
Shutting down clone database
Altering clone database archive log directory
Updating log_archive_dest in clone database init file
Found archive log destination at /testvol
Mounting clone database
Resetting logs on new database NEW9
Database instance NEW9 is up and running
To shut down the clone database and unmount the Storage Checkpoint
•Use the dbed_clonedb command as follows:
$ /opt/VRTS/bin/dbed_clonedb -S NEW9 -o umount
To mount a Storage Checkpoint file system and start the clone database