<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Transitional//EN">
<HTML>
<HEAD>
  <!--
    *************************************************************************************
    * Copyright (c) 2005 VERITAS Software Corporation. All rights reserved. *

      For third-party license citations, please see the bottom of this file.
    *************************************************************************************
  -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="TEMPLATEBASE" content="vx_vxhelp_2005c">
<meta name="LASTUPDATED" content="06/13/05 10:35:46">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="oracle_hp_ch10flashsnap.fm">
     
<title>Cloning a Database (dbed_vmclonedb)</title>

</HEAD>

<BODY bgcolor="#FFFFFF" link="#000066" vlink="#0000ff" marginheight="0" topmargin="0">
<basefont=1>

<a name="478287"></a>

<div align="left">
<table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
   <td height="2" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#000000">
   </td>
 </tr>
 <tr>
   <td height="15" width="50%" border="0" cellspacing="0" cellpadding="0" bgcolor="#cccccc">
    <img src="images/vxsymbol.gif" height="20" width="31" border="0" cellspacing="0" cellpadding="0" align="left">
     
     
   </td>
   <td align="right" width="50%" bgcolor="#cccccc">

<!-- Header Breadcrumbs -->
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="oracle_hp_ch10flashsnap_sf_dbag102_477064.html" title="Previous - Backing Up the Database from Snapshot Volumes (dbed_vmclonedb)">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch10flashsnap_sf_dbag104_479995.html" title="Next - Resynchronizing the Snapshot to Your Database">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
   </td>
 </tr>

 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="sf_dbag_splashpage_docCD_sf_dbag1_103036.vxhd" title="Storage Foundation for Databases Guides title page ">Storage Foundation for Databases Guides</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>
 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="oracle_hp_dbag_titlepage_docCD_sf_dbag2_73700.vxhd" title="Storage Foundation 4.1 for Oracle Administrator's Guide title page ">Storage Foundation 4.1 for Oracle Administrator's Guide</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>


</table>
</div>

<div align="left">
 <table border="0" width="100%" bgcolor="#FFFFFF">
  <tr>
   <td width="100%" valign="top" bgcolor="#FFFFFF">

<!-- Start Main Topic Content -->
        <a name="startcontent"></a>
	
<h1><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="+1" color="#000000"><a name="478287"></a>Cloning a Database (dbed_vmclonedb)</font>
</h1>
 
  
  
  

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478288"></a>This section explains how to create a clone database using the snapshot volumes. You can use snapshots of a primary database to create a clone of the database at a given point in time. You can then implement decision-support analysis and report generation operations that take their data from the database clone rather than from the primary database to avoid introducing additional burdens on the production database. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478291"></a>A clone database can also serve as a valid backup of the primary database. See <a href="oracle_hp_ch10flashsnap_sf_dbag102_477064.html#477064">Backing Up the Database from Snapshot Volumes (dbed_vmclonedb)</a> for more information. You can backup the primary database to tape using snapshot volumes. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478305"></a>The resynchronization functionality of Database FlashSnap allows you to quickly refresh the clone database with up-to-date information from the primary database. Reducing the time taken to update decision-support data also lets you generate analysis reports more frequently. </font>
</p>




<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="478307"></a>Using Database FlashSnap to Clone a Database</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478308"></a>In a single-host configuration, the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> command creates a clone database on the same host. The command can also be used to shut down the clone database and unmount its file systems. When creating or unmounting the clone database in a single-host configuration, <font face="Courier New, Courier, sansserif, sans serif" size="2">-r relocate_path</font> is required so that the clone database's file systems use different mount points than those used by the primary database. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478309"></a>When used in a two-host configuration, the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> command imports the snapshot disk group <font face="Courier New, Courier, sansserif, sans serif" size="2">SNAP_dg</font>, mounts the file systems on the snapshot volumes, and starts a clone database. It can also reverse the process by shutting down the clone database, unmounting the file systems, and deporting the snapshot disk group. When creating the clone off host, <font face="Courier New, Courier, sansserif, sans serif" size="2">-o vxdbavol=vol_name</font> is required. </font>
</p>

<hr noshade size="2" width="100%" color="#000000">
<img src="images/caution.gif" alt="Caution " height="16" width="16">&nbsp;<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="478311"></a><b>Caution  &nbsp;&nbsp;</b></font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000"> When creating a clone database, all Storage Checkpoints in the original database are discarded.</font>
<hr noshade size="2" width="100%" color="#000000">
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="478312"></a><b>Prerequisites</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478313"></a>You must be logged in as the Oracle database administrator.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478314"></a>Before you can use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> command, you must complete the steps in <a href="oracle_hp_ch10flashsnap_sf_dbag97_473816.html#473816">Summary of Database Snapshot Steps</a>, <a href="oracle_hp_ch10flashsnap_sf_dbag99_475279.html#475279">Validating a Snapplan (dbed_vmchecksnap)</a>, and <a href="oracle_hp_ch10flashsnap_sf_dbag101_476260.html#476260">Creating a Snapshot (dbed_vmsnap)</a>.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478357"></a>The volume snapshot must contain the entire database.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478358"></a>The system administrator must provide the database administrator with access to the necessary volumes and mount points.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478359"></a>Before you can use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> command with the <font face="Courier New, Courier, sansserif, sans serif" size="2">-r relocate_path</font> 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.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478360"></a>If <font face="Courier New, Courier, sansserif, sans serif" size="2">SNAPSHOT_MODE</font> is set to <font face="Courier New, Courier, sansserif, sans serif" size="2">offline</font> or <font face="Courier New, Courier, sansserif, sans serif" size="2">instant</font>, a two-host configuration is required and <font face="Courier New, Courier, sansserif, sans serif" size="2">-r </font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>relocate_path</em></font> is not allowed.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478361"></a>The Oracle database must have at least one mandatory archive destination. For further details, see <a href="oracle_hp_ch10flashsnap_sf_dbag98_474347.html#474621">Establishing a Mandatory Archive Destination</a>.</font>
</li>
</ul>
</p>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="478369"></a><b>Usage Notes</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478370"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> command can be used on the secondary host.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478372"></a>In a single-host configuration, <font face="Courier New, Courier, sansserif, sans serif" size="2">-r&nbsp;</font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>relocate_path</em></font> is required. This command is also needed if the name of the clone database is different than the primary database.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478373"></a>In a two-host configuration, the <font face="Courier New, Courier, sansserif, sans serif" size="2">vxdbavol=</font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>vol_name</em></font> option is required.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478374"></a>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 <font face="Courier New, Courier, sansserif, sans serif" size="2">init.ora</font> file that has reduced memory requirements. If the host where <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> is run has little available memory, you may not be able to start up the clone database and the cloning operation may fail.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478375"></a>See the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font>(1M) manual page for more information.</font>
</li>
</ul>
</p>
</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="478378"></a>&nbsp;&nbsp;<b>To mount a database and recover it manually</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478379"></a>Start and mount the clone database to allow manual database recovery:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478380"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-S&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>ORACLE_SID</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;-g&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>snap_dg</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478381"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-o&nbsp;mountdb,new_sid=</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>new_sid</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>[,vxdbavol=</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>vol_name</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>]&nbsp;-f&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>SNAPPLAN</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478382"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>[-H&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>ORACLE_HOME</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>]&nbsp;[-r&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>relocate_path</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>]</b></font>
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478383"></a>Recover the database manually.
</font>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478398"></a>Update the snapshot status information for the clone database in the VxDBA repository:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478399"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-o&nbsp;update_status,new_sid=</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>new_sid</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478400"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-f&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>SNAPPLAN</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;[-r&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>relocate_path</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>]</b></font>
</font>
</ol>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="478401"></a><b>Example</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478402"></a>In this example, file systems are mounted <em>without bringing up the clone database</em>. 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.</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478403"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-S&nbsp;PROD&nbsp;-g&nbsp;SNAP_PRODdg</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478404"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-o&nbsp;mountdb,new_sid=NEWPROD&nbsp;-f&nbsp;snap1&nbsp;-r&nbsp;/clone</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478405"></a>dbed_vmclonedb&nbsp;started&nbsp;at&nbsp;2004-04-02&nbsp;15:34:41
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478406"></a>Mounting&nbsp;/clone/prod_db&nbsp;on&nbsp;/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_db.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478407"></a>Mounting&nbsp;/clone/prod_ar&nbsp;on&nbsp;/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_ar.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478408"></a>All&nbsp;redo-log&nbsp;files&nbsp;found.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478409"></a>Database&nbsp;NEWPROD&nbsp;(SID=NEWPROD)&nbsp;is&nbsp;in&nbsp;recovery&nbsp;mode.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478411"></a>If&nbsp;the&nbsp;database&nbsp;NEWPROD&nbsp;is&nbsp;recovered&nbsp;manually,&nbsp;you&nbsp;must&nbsp;run
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478412"></a>dbed_vmclonedb&nbsp;-o&nbsp;update_status&nbsp;to&nbsp;change&nbsp;the&nbsp;snapshot&nbsp;status.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478413"></a>dbed_vmclonedb&nbsp;ended&nbsp;at&nbsp;2004-04-02&nbsp;15:34:59
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478421"></a>The database is recovered manually using <font face="Courier New, Courier, sansserif, sans serif" size="2">dbinitdb</font>. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478422"></a>The database status (<font face="Courier New, Courier, sansserif, sans serif" size="2">database_recovered</font>) needs to be updated for a clone database on the primary host after manual recovery has been completed. </font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478423"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-o&nbsp;update_status,new_sid=NEWPROD</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478424"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-f&nbsp;snap1&nbsp;-r&nbsp;/clone</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478425"></a>dbed_vmclonedb&nbsp;started&nbsp;at&nbsp;2004-04-02&nbsp;15:19:16
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478426"></a>The&nbsp;snapshot&nbsp;status&nbsp;has&nbsp;been&nbsp;updated.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478427"></a>dbed_vmclonedb&nbsp;ended&nbsp;at&nbsp;2004-04-02&nbsp;15:19:42
</font>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="478431"></a><b>Example</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478432"></a>In this example, file systems are mounted <em>without recovering the clone database</em>. The clone database must be manually recovered before it can be used. This example is for a clone created on a secondary host.</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478433"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-S&nbsp;-g&nbsp;SNAP_PRODdg</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478434"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-o&nbsp;mountdb,new_sid=NEWPROD,vxdbavol=SNAP_arch&nbsp;-f&nbsp;snap2</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478435"></a>dbed_vmclonedb&nbsp;started&nbsp;at&nbsp;2004-04-09&nbsp;23:26:50
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478436"></a>Mounting&nbsp;/clone/arch&nbsp;on&nbsp;/dev/vx/dsk/SNAP_PRODdg/SNAP_arch.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478437"></a>Mounting&nbsp;/clone/prod_db&nbsp;on&nbsp;/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_db.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478438"></a>All&nbsp;redo-log&nbsp;files&nbsp;found.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478439"></a>Database&nbsp;NEWPROD&nbsp;(SID=NEWPROD)&nbsp;is&nbsp;in&nbsp;recovery&nbsp;mode.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478441"></a>If&nbsp;the&nbsp;database&nbsp;NEWPROD&nbsp;is&nbsp;recovered&nbsp;manually,&nbsp;you&nbsp;must&nbsp;run&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478442"></a>dbed_vmclonedb&nbsp;-o&nbsp;update_status&nbsp;to&nbsp;change&nbsp;the&nbsp;snapshot&nbsp;status.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478443"></a>dbed_vmclonedb&nbsp;ended&nbsp;at&nbsp;2004-04-09&nbsp;23:27:17
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478451"></a>The database is recovered manually.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478452"></a>The snapshot status (<font face="Courier New, Courier, sansserif, sans serif" size="2">database_recovered</font>) is updated for a clone database on a secondary host after manual recovery has been completed. </font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478453"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-o&nbsp;update_status,new_sid=NEWPROD</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478454"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-f&nbsp;snap2</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478455"></a>dbed_vmclonedb&nbsp;started&nbsp;at&nbsp;2004-04-09&nbsp;23:34:01
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478456"></a>The&nbsp;snapshot&nbsp;status&nbsp;has&nbsp;been&nbsp;updated.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478457"></a>dbed_vmclonedb&nbsp;ended&nbsp;at&nbsp;2004-04-09&nbsp;23:34:35
</font>
</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="478461"></a>&nbsp;&nbsp;<b>To clone the database automatically</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478462"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> command as follows:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478463"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-S&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>ORACLE_SID</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;-g&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>snap_dg</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478464"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-o&nbsp;recoverdb,new_sid=</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>new_sid</em></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>[,vxdbavol=</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>vol_name</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>]&nbsp;-f&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>SNAPPLAN</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478465"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>[-H&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>ORACLE_HOME</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>]&nbsp;[-r&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>relocate_path</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>]</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478466"></a>Where:</font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478467"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><i>ORACLE_SID</i></font> is the name of the Oracle database used to create the snapshot.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478468"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><i>snap_dg</i></font> is the name of the diskgroup that contains all the snapshot volumes.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478469"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">new_sid</font> specifies the <font face="Courier New, Courier, sansserif, sans serif" size="2"><i>ORACLE_SID</i></font> for the clone database. </font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478470"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">vxdbavol</font> is the volume that contains the snapplan data. This name is provided after you run <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmsnap -o snapshot</font>. </font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478471"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><i>SNAPPLAN</i></font> is the name of the snapplan file.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478472"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><i>ORACLE_HOME</i></font> is the <font face="Courier New, Courier, sansserif, sans serif" size="2"><i>ORACLE_HOME</i></font> setting for the <font face="Courier New, Courier, sansserif, sans serif" size="2"><i>ORACLE_SID</i></font> database.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478473"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>relocate_path</em></font> is the name of the initial mount point for the snapshot image.</font>
</li>
<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="478474"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">When cloning a database on a secondary host, ensure that <font face="Courier New, Courier, sansserif, sans serif" size="2">PRIMARY_HOST</font> and <font face="Courier New, Courier, sansserif, sans serif" size="2">SECONDARY_HOST</font> parameters in the snapplan file are different.
</font>
<hr noshade size="2" width="100%" color="#000000">
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478475"></a>When the <font face="Courier New, Courier, sansserif, sans serif" size="2">-o recoverdb</font> option is used with <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font>, the clone database is recovered automatically using all available archive logs. If the <font face="Courier New, Courier, sansserif, sans serif" size="2">-o recoverdb</font> option is not used, you can perform point-in-time recovery manually. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478478"></a>For information on cloning a database using the GUI, see <a href="oracle_hp_ch12vxdbagui_sf_dbag112_246491.html#246491">Using the VERITAS Storage Foundation for Oracle Graphical User Interface</a>.</font>
</p>

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="478492"></a><b>Example</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478493"></a>In the following example, a clone of the primary database is automatically created on the same host as the primary database.</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478494"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-S&nbsp;PROD&nbsp;-g&nbsp;SNAP_PRODdg</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478495"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-o&nbsp;recoverdb,new_sid=NEWPROD&nbsp;-f&nbsp;snap1&nbsp;-r&nbsp;/clone</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478496"></a>dbed_vmclonedb&nbsp;started&nbsp;at&nbsp;2004-04-02&nbsp;14:42:10
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478497"></a>Mounting&nbsp;/clone/prod_db&nbsp;on&nbsp;/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_db.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478498"></a>Mounting&nbsp;/clone/prod_ar&nbsp;on&nbsp;/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_ar.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478499"></a>All&nbsp;redo-log&nbsp;files&nbsp;found.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478500"></a>Database&nbsp;NEWPROD&nbsp;(SID=NEWPROD)&nbsp;is&nbsp;running.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478501"></a>dbed_vmclonedb&nbsp;ended&nbsp;at&nbsp;2004-04-02&nbsp;14:43:05
</font>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="478516"></a><b>Example</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478517"></a>In the following example, a clone of the primary database is automatically created on a secondary host.</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478518"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-S&nbsp;PROD&nbsp;-g&nbsp;SNAP_PRODdg</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478519"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-o&nbsp;recoverdb,new_sid=NEWPROD,vxdbavol=SNAP_arch&nbsp;-f&nbsp;snap2</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478520"></a>dbed_vmclonedb&nbsp;started&nbsp;at&nbsp;2004-04-09&nbsp;23:03:40
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478521"></a>Mounting&nbsp;/clone/arch&nbsp;on&nbsp;/dev/vx/dsk/SNAP_PRODdg/SNAP_arch.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478522"></a>Mounting&nbsp;/clone/prod_db&nbsp;on&nbsp;/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_db.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478523"></a>All&nbsp;redo-log&nbsp;files&nbsp;found.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478524"></a>Database&nbsp;NEWPROD&nbsp;(SID=NEWPROD)&nbsp;is&nbsp;running.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478525"></a>dbed_vmclonedb&nbsp;ended&nbsp;at&nbsp;2004-04-09&nbsp;23:04:50
</font>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="478537"></a>Shutting Down the Clone Database and Unmounting File Systems</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478539"></a>When you are done using the clone database, you can shut it down and unmount all snapshot file systems with the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb -o umount</font> command. If the clone database is used on a secondary host that has shared disks with the primary host, the <font face="Courier New, Courier, sansserif, sans serif" size="2">-o umount</font> option also deports the snapshot disk group.</font>
</p>

<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="478540"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Any mounted Storage Checkpoints mounted need to be unmounted before running <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb -o</font> <font face="Courier New, Courier, sansserif, sans serif" size="2">umount</font>.
</font>
<hr noshade size="2" width="100%" color="#000000">
</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="478541"></a>&nbsp;&nbsp;<b>To shut down the clone database and unmount all snapshot file systems</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478542"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> command as follows:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478543"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-o&nbsp;umount,new_sid=</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>new_sid</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478544"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-f&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>SNAPPLAN</em></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;[-r&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>relocate_path</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>]</b></font>
</font>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="478545"></a><b>Example</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478546"></a>In this example, the clone database is shut down and file systems are unmounted for a clone on the same host as the primary database (a single-host configuration).</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478547"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-o&nbsp;umount,new_sid=NEWPROD</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478548"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-f&nbsp;snap1&nbsp;-r&nbsp;/clone</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478549"></a>dbed_vmclonedb&nbsp;started&nbsp;at&nbsp;2004-04-02&nbsp;15:11:22
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478550"></a>NOTICE:&nbsp;Umounting&nbsp;/clone/prod_db.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478551"></a>NOTICE:&nbsp;Umounting&nbsp;/clone/prod_ar.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478552"></a>dbed_vmclonedb&nbsp;ended&nbsp;at&nbsp;2004-04-02&nbsp;15:11:47
</font>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="478553"></a><b>Example</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478554"></a>In this example, the clone database is shut down, file systems are unmounted, and the snapshot disk group is deported for a clone on a secondary host (a two-host configuration).</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478555"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-o&nbsp;umount,new_sid=NEWPROD</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478556"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-f&nbsp;snap2</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478557"></a>dbed_vmclonedb&nbsp;started&nbsp;at&nbsp;2004-04-09&nbsp;23:09:21
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478558"></a>NOTICE:&nbsp;Umounting&nbsp;/clone/arch.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478559"></a>NOTICE:&nbsp;Umounting&nbsp;/clone/prod_db.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478560"></a>dbed_vmclonedb&nbsp;ended&nbsp;at&nbsp;2004-04-09&nbsp;23:09:50
</font>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="478562"></a>Restarting a Clone Database</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478563"></a>If the clone database is down as a result of using dbed_vmclonedb<font face="Courier New, Courier, sansserif, sans serif" size="2"> -o umount</font> or rebooting the system, you can restart it with the <font face="Courier New, Courier, sansserif, sans serif" size="2">-o restartdb</font> option.</font>
</p>

<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="478564"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">This option can only be used when a clone database is created successfully. If the clone database is recovered manually, <font face="Courier New, Courier, sansserif, sans serif" size="2">-o update_status</font> must be run to update the status before <font face="Courier New, Courier, sansserif, sans serif" size="2">-o restartdb</font> will work.
</font>
<hr noshade size="2" width="100%" color="#000000">
</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="478566"></a>&nbsp;&nbsp;<b>To start the clone database</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478567"></a>Use the dbed_vmclonedb command as follows:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478568"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-S&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>ORACLE_SID</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;-g&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>snap_dg</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478569"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-o&nbsp;restartdb,new_sid=</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>new_sid</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;-f&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>SNAPPLAN</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;[-H&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>ORACLE_HOME</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>]</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478570"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>[-r&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>relocate_path</em></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>]</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478573"></a>For information on restarting the clone database using the GUI, see <a href="oracle_hp_ch12vxdbagui_sf_dbag112_246491.html#246491">Using the VERITAS Storage Foundation for Oracle Graphical User Interface</a>.</font>
</p>

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="478587"></a><b>Example</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478588"></a>In this example, the clone database is re-started on the same host as the primary database (a single-host configuration).</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478589"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-S&nbsp;PROD&nbsp;-g&nbsp;SNAP_PRODdg</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478590"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-o&nbsp;restartdb,new_sid=NEWPROD&nbsp;-f&nbsp;snap1&nbsp;-r&nbsp;/clone</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478591"></a>dbed_vmclonedb&nbsp;started&nbsp;at&nbsp;2004-04-02&nbsp;15:14:49
</font>
<a name="478592"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">Mounting /clone/prod_db on 	<br>/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_db.</font>
<a name="478593"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">Mounting /clone/prod_ar on 	<br>/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_ar.</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478594"></a>Oracle&nbsp;instance&nbsp;NEWPROD&nbsp;successfully&nbsp;started.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478595"></a>dbed_vmclonedb&nbsp;ended&nbsp;at&nbsp;2004-04-02&nbsp;15:15:19
</font>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="478607"></a><b>Example</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478608"></a>In this example, the clone database is re-started on the secondary host (a two-host configuration).</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478609"></a>$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_vmclonedb&nbsp;-S&nbsp;PROD&nbsp;-g&nbsp;SNAP_PRODdg</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478610"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>-o&nbsp;restartdb,new_sid=NEWPROD,vxdbavol=SNAP_arch&nbsp;-f&nbsp;snap2</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478611"></a>dbed_vmclonedb&nbsp;started&nbsp;at&nbsp;2003-04-09&nbsp;23:03:40
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478612"></a>Mounting&nbsp;/clone/arch&nbsp;on
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478613"></a>/dev/vx/dsk/SNAP_PRODdg/SNAP_arch.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478614"></a>Mounting&nbsp;/clone/prod_db&nbsp;on
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478615"></a>/dev/vx/dsk/SNAP_PRODdg/SNAP_prod_db.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478616"></a>Oracle&nbsp;instance&nbsp;NEWPROD&nbsp;successfully&nbsp;started.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478617"></a>dbed_vmclonedb&nbsp;ended&nbsp;at&nbsp;2003-04-09&nbsp;23:04:50
</font>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="478630"></a>Recreating Oracle tempfiles</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478631"></a>After a clone database is created and opened, the tempfiles are added <em>if they were residing on the snapshot volumes</em>. If the tempfiles were not residing on the same file systems as the datafiles, <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmsnap</font> does not include the underlying volumes in the snapshot. In this situation, <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> issues a warning message and you can then recreate any needed tempfiles on the clone database as described in the following procedure.</font>
</p>

</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="478632"></a>&nbsp;&nbsp;<b>To recreate the Oracle tempfiles</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478633"></a>If the tempfiles were not residing on the same file systems as the datafiles, <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> will display the <font face="Courier New, Courier, sansserif, sans serif" size="2">WARNING</font> and <font face="Courier New, Courier, sansserif, sans serif" size="2">INFO</font> messages similar to the following:
</font>
<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478634"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WARNING:&nbsp;Not&nbsp;all&nbsp;tempfiles&nbsp;were&nbsp;included&nbsp;in&nbsp;snapshot&nbsp;for&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font>,
</font>

<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478635"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;there&nbsp;is&nbsp;no&nbsp;snapshot&nbsp;volume&nbsp;for&nbsp;
</font>

<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478636"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>clone_path</em></font>/<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>temp02</em></font>.dbf.
</font>

<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478637"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WARNING:&nbsp;Could&nbsp;not&nbsp;recreate&nbsp;tempfiles&nbsp;for&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font>&nbsp;due&nbsp;to&nbsp;lack&nbsp;of&nbsp;
</font>

<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478638"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;free&nbsp;space.
</font>

<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478639"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INFO:&nbsp;The&nbsp;sql&nbsp;script&nbsp;for&nbsp;adding&nbsp;tempfiles&nbsp;to&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font>&nbsp;is&nbsp;at&nbsp;
</font>

<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478640"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/tmp/add_tf.<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font>.sql.
</font>

<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="478641"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000"><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font> is the name of the clone database.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478642"></a>A script named <font face="Courier New, Courier, sansserif, sans serif" size="2">add_tf.</font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font><font face="Courier New, Courier, sansserif, sans serif" size="2">.sql</font> is provided in the <font face="Courier New, Courier, sansserif, sans serif" size="2">/tmp</font> directory for the purpose of recreating Oracle tempfiles. This script contains the SQL*Plus commands to recreate the missing tempfiles. 
</font>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478643"></a>Make a copy of the <font face="Courier New, Courier, sansserif, sans serif" size="2">/tmp/add_tf.</font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font><font face="Courier New, Courier, sansserif, sans serif" size="2">.sql</font> script and open it to view the list of missing tempfiles. 
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478644"></a>An example of the <font face="Courier New, Courier, sansserif, sans serif" size="2">add_tf.</font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font><font face="Courier New, Courier, sansserif, sans serif" size="2">.sql</font> script is shown below:</font>
</p>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478645"></a>&nbsp;&nbsp;$&nbsp;cat&nbsp;/tmp/add_tf.<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font>.sql
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478646"></a>&nbsp;&nbsp;--&nbsp;Commands&nbsp;to&nbsp;add&nbsp;tempfiles&nbsp;to&nbsp;temporary&nbsp;tablespaces.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478647"></a>&nbsp;&nbsp;--&nbsp;Online&nbsp;tempfiles&nbsp;have&nbsp;complete&nbsp;space&nbsp;information.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478648"></a>&nbsp;&nbsp;--&nbsp;Other&nbsp;tempfiles&nbsp;may&nbsp;require&nbsp;adjustment.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478649"></a>&nbsp;&nbsp;ALTER&nbsp;TABLESPACE&nbsp;TEMP&nbsp;ADD&nbsp;TEMPFILE&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478650"></a>&nbsp;&nbsp;'/<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>clone_path</em></font>/<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>temp01</em></font>.dbf'
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478651"></a>&nbsp;&nbsp;SIZE&nbsp;4194304&nbsp;REUSE&nbsp;AUTOEXTEND&nbsp;ON&nbsp;NEXT&nbsp;1048576&nbsp;MAXSIZE&nbsp;33554432&nbsp;;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478652"></a>&nbsp;&nbsp;ALTER&nbsp;TABLESPACE&nbsp;TEMP&nbsp;ADD&nbsp;TEMPFILE&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478653"></a>&nbsp;&nbsp;'/<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>clone_path</em></font>/<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>temp02</em></font>.dbf'&nbsp;REUSE;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478654"></a>&nbsp;&nbsp;ALTER&nbsp;DATABASE&nbsp;TEMPFILE&nbsp;'/<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>clone_path2</em></font>/<font face="Courier New, Courier, sansserif, sans serif" size="2"><em>temp02</em></font>.dbf'&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="478655"></a>&nbsp;&nbsp;OFFLINE;
</font>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478656"></a>Evaluate whether you need to recreate any temp files. If you want to recreate tempfiles, proceed to the next step.
</font>
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478657"></a>In the <font face="Courier New, Courier, sansserif, sans serif" size="2">add_tf.</font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font><font face="Courier New, Courier, sansserif, sans serif" size="2">.sql</font> file, edit the sizes and default path names of the tempfiles as needed to reside on cloned volumes configured for database storage.
</font>
<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="478658"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Do not run the script without first editing it because path names may not exist and the specified mount points may not contain sufficient space.
</font>
<hr noshade size="2" width="100%" color="#000000">
<li value="6">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478659"></a>After you have modified the <font face="Courier New, Courier, sansserif, sans serif" size="2">add_tf.</font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>$ORACLE_SID</em></font><font face="Courier New, Courier, sansserif, sans serif" size="2">.sql</font> script, execute it against your clone database.
</font>
<li value="7">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478660"></a>After you have successfully run the script, you may delete it.
</font>
</ol>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="478661"></a></font>
</p>


<!-- End Main Topic Content -->

   </td>
  </tr>
 </table>
</div>

<div>
<table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
  <td height="18" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#FFFFFF">
  </td>
 </tr>
  <td align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&nbsp;&#94;&nbsp;<a href="oracle_hp_ch10flashsnap_sf_dbag103_478287.html" title="Cloning a Database (dbed_vmclonedb)">Return to Top</a></font>

  </td>
  <td align="right"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="oracle_hp_ch10flashsnap_sf_dbag102_477064.html" title="Previous - Backing Up the Database from Snapshot Volumes (dbed_vmclonedb)">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch10flashsnap_sf_dbag104_479995.html" title="Next - Resynchronizing the Snapshot to Your Database">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
  </td>
 <tr>
   <td height="9" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#FFFFFF">
   </td>
 </tr>

<!-- Footer Breadcrumbs -->
<tr>
<td bgcolor="#FFFFFF" colspan="2" height="15" align="right">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="sf_dbag_splashpage_docCD_sf_dbag1_103036.vxhd" title="Storage Foundation for Databases Guides title page ">Storage Foundation for Databases Guides</a>&nbsp;&nbsp;</font></td>
</tr>

<tr>
<td bgcolor="#FFFFFF" colspan="2" height="15" align="right">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="oracle_hp_dbag_titlepage_docCD_sf_dbag2_73700.vxhd" title="Storage Foundation 4.1 for Oracle Administrator's Guide title page ">Storage Foundation 4.1 for Oracle Administrator's Guide</a>&nbsp;&nbsp;</font></td>
</tr>


 <tr>
  <td colspan="2" align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" color="#000000" align="right" size="-2">
<em>VERITAS Software Corporation
</em></font><br>

<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">www.veritas.com</font><br>
  </td>
 </tr>
</table>
</div>

</BODY>
  <!--
    *************************************************************************************
    * Copyright (c) 2005 VERITAS Software Corporation. All rights reserved. *

    VERITAS, VERITAS SOFTWARE, the VERITAS Logo, and VERITAS Software Documentation 
    are trademarks or registered trademarks of VERITAS Software Corporation 
    or its affiliates in the U.S. and other countries. Other names may be 
    trademarks of their respective owners. 

    Apache Jakarta Lucene:
    Apache Software License
    Version 1.1

    Copyright (c) 2000 The Apache Software Foundation. All rights reserved.

    Redistribution and use in source and binary forms, with or without modification, 
    are permitted provided that the following conditions are met:

    1. Redistributions of source code must retain the above copyright notice, this 
    list of conditions and the following disclaimer.

    2. Redistributions in binary form must reproduce the above copyright notice, this 
    list of conditions and the following disclaimer in the documentation and/or other 
    materials provided with the distribution.

    3. The end-user documentation included with the redistribution, if any, must include 
    the following acknowledgment: "This product includes software developed by the Apache 
    Software Foundation (http://www.apache.org/)." Alternately, this acknowledgment may 
    appear in the software itself, if and wherever such third-party acknowledgments 
    normally appear.

    4. The names "Apache" and "Apache Software Foundation" must not be used to endorse or 
    promote products derived from this software without prior written permission. For 
    written permission, please contact apache@apache.org.

    5. Products derived from this software may not be called "Apache", nor may "Apache" 
    appear in their name, without prior written permission of the Apache Software Foundation.

    THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, 
    BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A 
    PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION 
    OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, 
    OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS 
    OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND 
    ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING 
    NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF 
    ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

    This software consists of voluntary contributions made by many individuals on behalf 
    of the Apache Software Foundation. For more information on the Apache Software Foundation, 
    please see <http://www.apache.org/>. Portions of this software are based upon public domain 
    software originally written at the National Center for Supercomputing Applications, University 
    of Illinois, Urbana-Champaign.
    
    This product includes WebWindow Software developed by Horst Heistermann.
    *************************************************************************************
  -->
</HTML>
