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

Manual (interactive) recovery, which requires using the -i option, of the clone database

allows the user to control the degree of recovery by specifying which archive log files are

to be replayed.

Automatic (non-interactive) recovery, which is the default usage of the command,

recovers the entire database and replays all of the archive logs. You will not be prompted

for any archive log names.

Before cloning the Oracle instance, the following conditions must be met:

Table 4-13 lists the options for the dbed_clonedb command.

Table 4-12 Cloning Oracle Instance Notes

Prerequisites • You must first create a Storage Checkpoint. You must be logged

in as the database administrator.

• Make sure you have enough space and system resources to

create a clone database on your system.

• A clone database takes up as much memory and machine

resources as the primary database.

Usage Notes • The dbed_clonedb command is used to create a copy of a

database, cloning all existing database files to new locations.

• The ORACLE_SID and ORACLE_HOME environment variables

must be set to the primary database.

• It is assumed that the user has a basic understanding of the

database recovery process.

• See the dbed_clonedb(1M) manual page for more information.

Limitations

for SG Oracle

RAC

• Note that the database cloning using Instant Checkpoint is not

supported for SG Oracle RAC.

• When you clone the database by using Checkpoint, the node can

be any node in the same SG Oracle RAC cluster but the archive

log destination is required to be on CFS file system. Otherwise,

you must manually copy the archive log files.

Table 4-13 dbed_clonedb Command Options

Option Description

-S CLONE_SID Specifies the name of the new Oracle SID, which will be the name

of the new database instance.

-m MOUNT_POINT Indicates the new mount point of the Storage Checkpoint.

-c CKPT_NAME Indicates the name of the Storage Checkpoint.

-i Runs the command in interactive mode where you must respond

to prompts by the system. The default mode is non-interactive.

(Optional)

-o umount Shuts down the clone database and unmounts the Storage

Checkpoint file system.