<!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="DocCD Manual Pages 1.4">
<meta name="LASTUPDATED" content="06/17/05 15:59:28">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="dbed_vmsnapplan.fm">
     
<title>dbed_vmsnapplan</title>

</HEAD>

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

<a name="427869"></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="man4_titlepage_docCD_sfora_man30_73700.vxhd" title="Previous - Devices (4)">Previous</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">Product:  
<a href="sf_oracle_manpages_splashpage_docCD_sfora_man1_103036.vxhd" title="Oracle Manual Pages for Storage Foundation title page ">Oracle Manual Pages for Storage Foundation</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="man4_titlepage_docCD_sfora_man30_73700.vxhd" title="Devices (4) title page ">Devices (4)</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>
	
<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="426995"></a>dbed_vmsnapplan</font>
</h2>

        

<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="427025"></a> NAME</font>
</h3>
<p>
<a name="427030"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">dbed_vmsnapplan - the file containing a snapplan for an Oracle database </font>
</p>

<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="427033"></a> DESCRIPTION</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427038"></a>The <em>dbed_vmsnapplan</em> file specifies the snapshot scenarios for an Oracle database (such as online, offline, or instant). The file name of the <em>dbed_vmsnapplan</em> file is specified by the user. Before using the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>dbed_vmsnap</b></font>(1M) command to create the snapshot image, a <em>dbed_vmsnapplan </em>file needs to be validated by running the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>dbed_vmchecksnap</b></font>(1M) command. Each entry in the <em>dbed_vmsnapplan</em> file is a line in <em>parameter</em>=<em>argument</em> format. </font>
</p>


<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="427086"></a> PARAMETERS</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427091"></a>The following parameters are specified in the <em>dbed_vmsnapplan</em> file: </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428405"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>SNAPSHOT_VERSION</b></font></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428406"></a>Specifies the snapshot version for this release of VERITAS Storage Foundation \fI<em>for Oracle\fP</em>. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427117"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>PRIMARY_HOST</b></font></font>
</p>
<p>
<a name="427984"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Specifies the name of the host where the primary database resides. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427131"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>SECONDARY_HOST</b></font></font>
</p>
<p>
<a name="427999"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Specifies the name of the host where the clone database will reside. When the primary and secondary hosts are the same, the snapshot volumes will not be deported. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427154"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>PRIMARY_DG</b></font></font>
</p>
<p>
<a name="428014"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Specifies the name of the Volume Manager disk group used by the primary database. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427168"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>SNAPSHOT_DG</b></font></font>
</p>
<p>
<a name="428029"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Specifies the name of the disk group containing the snaphot volumes. The snapshot volumes will be put into this disk group on the primary host and deported if the primary  and secondary hosts are different. The secondary host will import this disk group to start a clone database. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427209"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>ORACLE_SID</b></font></font>
</p>
<p>
<a name="428044"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Specifies the name of the Oracle database. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427223"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>ARCHIVELOG_DEST</b></font></font>
</p>
<p>
<a name="428059"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">The full path of the archive logs. There are several archive log destinations that can be used for database recovery if you are multiplexing the archive logs. You must specify which archive log destination to use. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427255"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>SNAPSHOT_ARCHIVE_LOG</b></font> (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>yes</b></font> | <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>no</b></font>)</font>
</p>
<p>
<a name="428098"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Specifies whether to create a snapshot of the archive log volumes. Specify <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>yes</b></font> to split the archive log volume mirrors and deport them to the secondary host in a two-host configuration. When using the Oracle remote archive log destination feature to send the archive logs to the secondary host, you can specify <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>no</b></font> to save some space. Since the archive logs may not always be delivered to the secondary host reliably, it is recommended that you specify <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>yes</b></font> here to use split mirrors as the archive log transport mechanism. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427340"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>SNAPSHOT_MODE</b></font> (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>online</b></font> | <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>offline</b></font> | <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>instant</b></font>)</font>
</p>
<p>
<a name="428137"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Specifies whether the database should be online, offline, or instant when the snapshot is created. If the snapshot is created while the database is online, the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>dbed_vmsnap</b></font> command will first put the tablespaces into backup mode. After <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>dbed_vmsnap</b></font> finishes creating the datafile snapshot, it will take the tablespaces out of backup mode, switch the log files to ensure that the extra redo logs are archived, and then create a snapshot of the archived logs. If the database is offline, it is not necessary to put the tablespaces into backup mode. If the database is instant, a snapshot will be taken regardless of whether the database is up or down, and will not put the tablespace into backup mode. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427416"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>SNAPSHOT_PLAN_FOR</b></font> (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>database</b></font>)</font>
</p>
<p>
<a name="428164"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">The default value is <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>database</b></font> and cannot be changed. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="428420"></a>Specifies the database object to create a snapshot of. To clone a database using a snapshot image, set <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>SNAPSHOT_PLAN_FOR=database</b></font>. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427455"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>SNAPSHOT_PLEX_TAG</b></font></font>
</p>
<p>
<a name="428187"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Specifies the snapshot plex tag. Use this variable to specify a tag for the plexes to be snapshot. The default plex tag is <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>dbed_flashsnap</b></font>. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427487"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>SNAPSHOT_VOL_PREFIX</b></font></font>
</p>
<p>
<a name="428202"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Specifies the snapshot volume prefix. Use this variable to specify a prefix for the snapshot volumes split from the primary disk group. A volume name cannot be more than 32 characters. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427519"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>ALLOW_REVERSE_RESYNC</b></font></font>
</p>
<p>
<a name="428225"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">By default, reverse resynchronization is off (set equal to <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>NO</b></font>). If it is set to <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>YES</b></font>, this parameter allows you to restore the original volume from a snapshot. The original database, however, must be down for this operation. </font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427560"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>SNAPSHOT_MIRROR</b></font></font>
</p>
<p>
<a name="428240"></a><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2">Specifies the number of snapshot mirrors. The default value is 1. To make snapshots highly available, the snaphsot volume should contain more than one mirror. Multiple mirrors allow the snapshot volume to be available even if one of the mirrors is disabled. Before taking a snapshot, make sure all tagged snapshot mirrors are in the SNAPDONE state. </font>
</p>

<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="427609"></a> EXAMPLE</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427614"></a>The following example shows how to create a snapplan and set the default values for a single host. In this example, the working directory is <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>/export/snap_dir</b></font>. </font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="427650"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">$&nbsp;/usr/bin/cd&nbsp;/export/snap_dir</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="427660"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">$&nbsp;/opt/VRTS/bin/dbed_vmchecksnap&nbsp;-S&nbsp;PROD&nbsp;-H&nbsp;/oracle/product/9i&nbsp;\<br>-f&nbsp;snap1&nbsp;-o&nbsp;setdefaults&nbsp;-t&nbsp;host1<br>Snapplan&nbsp;snap1&nbsp;for&nbsp;PROD.<br>=====================================================<br>SNAPSHOT_VERSION=4.0<br>PRIMARY_HOST=host1<br>SECONDARY_HOST=host1<br>PRIMARY_DG=PRODdg<br>SNAPSHOT_DG=SNAP_PRODdg<br>ORACLE_SID=PROD<br>ARCHIVELOG_DEST=/mytest/arch<br>SNAPSHOT_ARCHIVE_LOG=yes<br>SNAPSHOT_MODE=online<br>SNAPSHOT_PLAN_FOR=database<br>SNAPSHOT_PLEX_TAG=dbed_flashsnap<br>SNAPSHOT_VOL_PREFIX=SNAP_<br>ALLOW_REVERSE_RESYNC=no<br>SNAPSHOT_MIRROR=1</font>
</font>

<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="427869"></a> SEE ALSO</font>
</h3>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427874"></a><a href="dbed_vmchecksnap_sfora_man18_430267.html#428290"><font color="#0000ff"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>dbed_vmchecksnap </b></font></font></a>(1M), <a href="dbed_vmsnap_sfora_man20_429545.html#427919"><font color="#0000ff"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>dbed_vmsnap </b></font></font></a>(1M), <a href="dbed_vmclonedb_sfora_man19_430473.html#428297"><font color="#0000ff"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>dbed_vmclonedb </b></font></font></a>(1M) </font>
</blockquote>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="427916"></a><em>VERITAS Storage Foundation for Oracle Administrator's Guide </em></font>
</blockquote>

<!-- 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="dbed_vmsnapplan_sfora_man31_427869.html" title="dbed_vmsnapplan">Return to Top</a></font>

  </td>
  <td align="right"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="man4_titlepage_docCD_sfora_man30_73700.vxhd" title="Previous - Devices (4)">Previous</a>&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_oracle_manpages_splashpage_docCD_sfora_man1_103036.vxhd" title="Oracle Manual Pages for Storage Foundation title page ">Oracle Manual Pages for Storage Foundation</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="man4_titlepage_docCD_sfora_man30_73700.vxhd" title="Devices (4) title page ">Devices (4)</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>
