VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Chapter 10, Using Database FlashSnap for Backup and Off-Host Processing
Prerelease 8 September 2005, 8:55am Cloning a Database (dbed_vmclonedb)
243
◆ Before you can use the dbed_vmclonedb command with the -r relocate_path
option (which specifies the initial mount point for the snapshot image), the system
administrator must create the mount point and then change the owner to the Oracle database
administrator.
◆ If SNAPSHOT_MODE is set to offline or instant, a two-host configuration is required
and -r relocate_path is not allowed.
◆ The Oracle database must have at least one mandatory archive destination. For further details,
see “Establishing a Mandatory Archive Destination” on page 228.
Usage Notes
◆ The dbed_vmclonedb command can be used on the secondary host.
◆ In a single-host configuration, -r relocate_path is required. This command is also
needed if the name of the clone database is different than the primary database.
◆ In a two-host configuration, the vxdbavol=vol_name option is required.
◆ The initialization parameters for the clone database are copied from the primary database. This
means that the clone database takes up the same memory and machine resources as the primary
database. If you want to reduce the memory requirements for the clone database, shut down the
clone database and then start it up again using a different init.ora file that has reduced
memory requirements. If the host where dbed_vmclonedb is run has little available
memory, you may not be able to start up the clone database and the cloning operation may fail.
◆ See the dbed_vmclonedb(1M) manual page for more information.
▼ To mount a database and recover it manually
1. Start and mount the clone database to allow manual database recovery:
$ /opt/VRTS/bin/dbed_vmclonedb -S ORACLE_SID -g snap_dg \
-o mountdb,new_sid=new_sid[,vxdbavol=vol_name] -f SNAPPLAN \
[-H ORACLE_HOME] [-r relocate_path]
2. Recover the database manually.
3. Update the snapshot status information for the clone database in the VxDBA repository:
$ /opt/VRTS/bin/dbed_vmclonedb -o update_status,new_sid=new_sid \
-f SNAPPLAN [-r relocate_path]
Example
In this example, file systems are mounted without bringing up the clone database. The clone
database must be manually created and recovered before it can be used. This example is for a clone
created on the same host as the primary database.