<!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>Summary of Database Snapshot Steps</title>

</HEAD>

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

<a name="473816"></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_dbag96_473263.html" title="Previous - Upgrading from VERITAS Database Edition 3.5 for Oracle with Database FlashSnap">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch10flashsnap_sf_dbag98_474347.html" title="Next - Creating a Snapplan (dbed_vmchecksnap)">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="473816"></a>Summary of Database Snapshot Steps</font>
</h1>
 
  
  
  

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473817"></a>You can use Database FlashSnap commands to create a snapshot of your entire database on the same host or on a different one. Three types of snapshots can be created: <font face="Courier New, Courier, sansserif, sans serif" size="2">online</font>, <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>. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473823"></a>If the <font face="Courier New, Courier, sansserif, sans serif" size="2">SNAPSHOT_MODE</font> specified in the snapplan is set to <font face="Courier New, Courier, sansserif, sans serif" size="2">online</font>, <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmsnap</font> first puts the tablespaces to be snapshot into backup mode. After the snapshot is created, the tablespaces are taken out of backup mode, the log files are switched to ensure that the extra redo logs are archived, and a snapshot of the archive logs is created. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473824"></a>If the <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>, the database must be shut down before the snapshot is created. Online redo logs and control files are required and will be used to ensure a full database recovery.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473825"></a>If the <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">instant</font>, tablespaces are not put into and out of backup mode. Online redo logs and control files are required and will be used to ensure a full database recovery. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473826"></a>Both online and offline snapshots provide a valid backup copy of the database. You can use the snapshot as a source for backing up the database or creating a clone database for decision-support purposes. Instant snapshots <em>do not represent</em> a valid backup copy for point-in-time recovery.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473827"></a>The sections that follow explain how to create snapshots of all volumes on a database using the snapplan. Optionally, you can use the VxVM command (<font face="Courier New, Courier, sansserif, sans serif" size="2">vxsnap</font>) to create volume snapshots. However, unlike the Database FlashSnap commands, the <font face="Courier New, Courier, sansserif, sans serif" size="2">vxsnap</font> command does not automate disk group content reorganization functions. For more information about the <font face="Courier New, Courier, sansserif, sans serif" size="2">vxsnap</font> command, see <em>VERITAS Volume Manager Administrator's Guide</em>.</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="473831"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Make sure the volumes used by the database are configured properly before attempting to take a snapshot. This requires superuser (<font face="Courier New, Courier, sansserif, sans serif" size="2">root</font>) privileges. 
</font>
<hr noshade size="2" width="100%" color="#000000">
<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="473832"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Anytime you change the structure of the database (for example, by adding or deleting datafiles, converting <font face="Courier New, Courier, sansserif, sans serif" size="2">PFILE</font> to <font face="Courier New, Courier, sansserif, sans serif" size="2">SPFILE</font>, or converting <font face="Courier New, Courier, sansserif, sans serif" size="2">SPFILE</font> to <font face="Courier New, Courier, sansserif, sans serif" size="2">PFILE</font>), you must run <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_update</font>.
</font>
<hr noshade size="2" width="100%" color="#000000">
<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="473834"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Database FlashSnap commands must be run by the Oracle database administrator. 
</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="473835"></a>&nbsp;&nbsp;<b>To create a snapshot image of a database</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473838"></a>Perform the steps in <a href="oracle_hp_ch10flashsnap_sf_dbag95_472557.html#472998">Creating a Snapshot Mirror of a Volume or Volume Set Used by the Database</a>.
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473855"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmchecksnap</font> command to create a snapplan template and check the volume configuration to ensure that it is valid for creating volume snapshots of the database. 
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473856"></a>The snapplan contains detailed database and volume configuration information that is needed for snapshot creation and resynchronization. You can modify the snapplan template with a text editor.</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473857"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmchecksnap</font> command can also be used to:</font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473858"></a>List all snapplans associated with a specific <font face="Courier New, Courier, sansserif, sans serif" size="2">ORACLE_SID</font> (<font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmchecksnap</font><font face="Courier New, Courier, sansserif, sans serif" size="2">&nbsp;-o&nbsp;list</font>)<font face="Courier New, Courier, sansserif, sans serif" size="2">.</font></font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473859"></a>Remove the snapplan from the VxDBA repository (<font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmchecksnap -o remove -f </font><em>SNAPPLAN</em>).</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473860"></a>Copy a snapplan from the VxDBA repository to your local directory (<font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmchecksnap -o copy -f </font><em>SNAPPLAN</em>).</font>
</li>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473863"></a>For information about the snapplan file, see <a href="oracle_hp_ch10flashsnap_sf_dbag98_474347.html#474347">Creating a Snapplan (dbed_vmchecksnap)</a>.</font>
</p>
</ul>
</p>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473880"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmsnap</font> command to create snapshot volumes for the database. See <a href="oracle_hp_ch10flashsnap_sf_dbag101_476260.html#476260">Creating a Snapshot (dbed_vmsnap)</a> for more information.
</font>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473899"></a>On the secondary host, use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> command to create a clone database using the disk group deported from the primary host. See <a href="oracle_hp_ch10flashsnap_sf_dbag103_478287.html#478287">Cloning a Database (dbed_vmclonedb)</a> for more information.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473918"></a>If the primary and secondary hosts specified in the snapplan are different, the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> command imports the disk group that was deported from the primary host, recovers the snapshot volumes, mounts the file systems, recovers the database, and brings the database online with a different Oracle SID name than the primary host. If the secondary host is different, the database name can be same. You can use the <font face="Courier New, Courier, sansserif, sans serif" size="2">-o&nbsp;recoverdb</font> option to let <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_vmclonedb</font> perform an automatic database recovery, or you can use the <font face="Courier New, Courier, sansserif, sans serif" size="2">-o&nbsp;mountdb</font> option to perform your own point-in-time recovery and bring up the database manually. For a point-in-time recovery, the snapshot mode must be <font face="Courier New, Courier, sansserif, sans serif" size="2">online</font>.</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473919"></a>You can also create a clone on the primary host. Your snapplan settings specify whether a clone should be created on the primary or secondary host.</font>
</p>
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473920"></a>You can now use the clone database to perform database backup and other off-host processing work.
</font>
<li value="6">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473921"></a>The clone database can be used to reverse resynchronize the original volume from the data in the snapshot, or can be discarded by rejoining the snapshot volumes with the original volumes (that is, by resynchronizing the snapshot volumes) for future use.
</font>
</ol>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473922"></a>The following flow chart depicts the sequence of steps leading up to taking a snapshot using Database FlashSnap.</font>
</p>

<p><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="473924"></a>
<b>Prerequisites for Creating a Snapshot of your Database</b></font>
</p>

  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="snapshot_prepare_4_t.htm">
<img src="images/snapshot_prepare_4.gif" width="110" height="143" border="0" alt="Prerequisites for Creating a Snapshot of your Database"></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->



<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473934"></a>There are many actions you can take after creating a snapshot of your database using Database FlashSnap. You can create a clone of the database for backup and off-host processing purposes. You can resynchronize the snapshot volumes with the primary database. In the event of primary database failure, you can recover it by reverse resynchronizing the snapshot volumes. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473935"></a>The following flow chart depicts the actions you can perform after creating a snapshot of your database using Database FlashSnap.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="473936"></a></font>
</p>

<p><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="473937"></a>
<b>Actions you can perform after Creating a Snapshot of your Database</b></font>
</p>

  <!-- Start Image Code -->
  <!--
   CAUTION: If graphics output is truncated, change the paper size setting 
   of your WebWorks Rasterizer printer driver from "A4" to "Letter" and regenerate your project.
  -->

<p>
<a href="post_snapshot_actions_ora6_t.htm">
<img src="images/post_snapshot_actions_ora6.gif" width="110" height="142" border="0" alt="Actions you can perform after Creating a Snapshot of your Database"></a>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1"><em>Click the thumbnail above to view full-sized image. </font></em></p>
   <!-- End Image Code -->




<!-- 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_dbag97_473816.html" title="Summary of Database Snapshot Steps">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_dbag96_473263.html" title="Previous - Upgrading from VERITAS Database Edition 3.5 for Oracle with Database FlashSnap">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch10flashsnap_sf_dbag98_474347.html" title="Next - Creating a Snapplan (dbed_vmchecksnap)">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>
