<!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:36:41">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="oracle_hp_appAcli.fm">
     
<title>Displaying Storage Checkpoints Using dbed_ckptdisplay</title>

</HEAD>

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

<a name="165619"></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_appAcli_sf_dbag144_165548.html" title="Previous - Creating Storage Checkpoints Using dbed_ckptcreate">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_appAcli_sf_dbag146_165726.html" title="Next - Mounting Storage Checkpoints Using dbed_ckptmount">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>
	
<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="165619"></a> Displaying Storage Checkpoints Using dbed_ckptdisplay</font>
</h2>

        
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165624"></a>You can use the VERITAS Storage Foundation for Oracle <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptdisplay</font> command to display the Storage Checkpoints associated with an Oracle database from the command line. You can also use it to display fileset quota values.</font>
</p>

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="165626"></a><b>Prerequisites</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165627"></a>You may be logged in as either the database administrator or <font face="Courier New, Courier, sansserif, sans serif" size="2">root</font>.</font>
</li>
</ul>
</p>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="165629"></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="165630"></a>In addition to displaying the Storage Checkpoints created by VxDBA, <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptdisplay</font> also displays other Storage Checkpoints (for example, Storage Checkpoints created by the Capacity Planning Utility and NetBackup).</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165631"></a>See the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptdisplay</font>(1M) manual page for more information.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165632"></a>The <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Status</b></font> field identifies if the Storage Checkpoint is partial (P), complete (C), invalid (I), mounted (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">M</font>), read-only (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">R</font>), writable (W), or of type online (<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">ON</font>), offline (OF), instant (IN), or unknown (UN).</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165635"></a>Database FlashSnap commands are integrated with Storage Checkpoint functionality. It is possible to display and mount Storage Checkpoints carried over with snapshot volumes to a secondary host. However limitations apply. For details, see <a href="oracle_hp_ch10flashsnap_sf_dbag102_477064.html#477682">Mounting the Snapshot Volumes and Backing Up</a>.</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="165643"></a>&nbsp;&nbsp;<b>To display Storage Checkpoints created by VERITAS Storage Foundation for Oracle</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165644"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptdisplay</font> command as follows to display information for Storage Checkpoints created by VERITAS Storage Foundation for <em>Oracle</em>:</font>
</p>

<a name="165645"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">	$ <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_ckptdisplay -S PROD </b></font>\<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>		-H /oracle/product/9i</b></font></font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165646"></a>&nbsp;Checkpoint_975876659&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sun&nbsp;Apr&nbsp;3&nbsp;12:50:59&nbsp;2004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;P+R+IN
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165647"></a>&nbsp;Checkpoint_974424522_wr001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thu&nbsp;May&nbsp;16&nbsp;17:28:42&nbsp;2004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C+R+ON
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165648"></a>&nbsp;Checkpoint_974424522&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thu&nbsp;May&nbsp;16&nbsp;17:28:42&nbsp;2004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;P+R+ON
</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="165650"></a>&nbsp;&nbsp;<b>To display other Storage Checkpoints</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165651"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptdisplay</font> command as follows:</font>
</p>

<a name="165652"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">	$ <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_ckptdisplay -S PROD </b></font>\<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>		-H /oracle/product/9i -o other</b></font></font>
<a name="165653"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">	NetBackup_incr_PROD_955133480																					NBU						/db01<br>	NetBackup_full_PROD_9551329																	52				NBU						/db01</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="165655"></a>&nbsp;&nbsp;<b>To display other Storage Checkpoints without updating the VxDBA repository</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165656"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptdisplay</font> command as follows:</font>
</p>

<a name="165657"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">	$ <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_ckptdisplay -S PROD </b></font>\<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>		-H /oracle/product/9i -o other -n</b></font></font>
<a name="165658"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">	NetBackup_incr_PROD_955133480																					NBU						/db01<br>	NetBackup_full_PROD_9551329																	52				NBU						/db01</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="165660"></a>&nbsp;&nbsp;<b>To display all Storage Checkpoints</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165661"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptdisplay</font> command as follows:</font>
</p>

<a name="165662"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">	$ <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_ckptdisplay -S PROD </b></font>\<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>		-H /oracle/product/9i -o all</b></font></font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165663"></a>&nbsp;Checkpoint_971672042&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sun&nbsp;May&nbsp;15&nbsp;13:55:53&nbsp;2004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C+R+IN
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165664"></a>&nbsp;Checkpoint_903937870&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fri&nbsp;May&nbsp;13&nbsp;22:51:10&nbsp;2004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C+R+ON
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165665"></a>&nbsp;Checkpoint_901426272&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Wed&nbsp;May&nbsp;11&nbsp;16:17:52&nbsp;2004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;P+R&nbsp;&nbsp;+ON
</font>
<a name="165666"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">	NetBackup_incr_PROD_955133480																					NBU						/db01<br>	NetBackup_full_PROD_9551329																	52				NBU						/db01</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="165668"></a>&nbsp;&nbsp;<b>To display all Storage Checkpoints without updating the VxDBA repository</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165669"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptdisplay</font> command as follows:</font>
</p>

<a name="165670"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">	$ <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_ckptdisplay -S PROD </b></font>\<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>		-H /oracle/product/9i -o all -n</b></font></font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165671"></a>&nbsp;Checkpoint_971672042&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sun&nbsp;May&nbsp;15&nbsp;13:55:53&nbsp;2004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C+R+IN
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165672"></a>&nbsp;Checkpoint_903937870&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fri&nbsp;May&nbsp;13&nbsp;22:51:10&nbsp;2004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C+R+ON
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165673"></a>&nbsp;Checkpoint_901426272&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Wed&nbsp;May&nbsp;11&nbsp;16:17:52&nbsp;2004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;P+R&nbsp;&nbsp;+ON
</font>
<a name="165674"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">	NetBackup_incr_PROD_955133480																					NBU						/db01<br>	NetBackup_full_PROD_9551329																	52				NBU						/db01</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="165676"></a>&nbsp;&nbsp;<b>To display fileset quota values</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165677"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptdisplay</font> command as follows:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165678"></a>&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_ckptdisplay&nbsp;-S&nbsp;PROD&nbsp;-c&nbsp;Checkpoint_903937870&nbsp;-Q</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165679"></a>&nbsp;Checkpoint_903937870&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Wed&nbsp;Mar&nbsp;19&nbsp;9:12:20&nbsp;2003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;C+R+ON
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165680"></a>&nbsp;&nbsp;Filesystem&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HardLim&nbsp;&nbsp;&nbsp;SoftLim&nbsp;&nbsp;&nbsp;&nbsp;CurrentUse
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165681"></a>&nbsp;&nbsp;/oradata1/indx1_1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;50000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2028
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165682"></a>&nbsp;&nbsp;/oradata1/user1_1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;50000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2028
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165683"></a>&nbsp;&nbsp;/oradata1/temp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;150000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;80000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2142
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="165684"></a>&nbsp;&nbsp;/oradata1/system1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;150000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;70000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3092
</font>



<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="165692"></a>Scheduling Storage Checkpoints Using dbed_ckptcreate and cron</font>
</h3>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165695"></a>You can use the VERITAS Storage Foundation for Oracle <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptcreate</font> command to schedule Storage Checkpoint creation in a <font face="Courier New, Courier, sansserif, sans serif" size="2">cron</font> job or other administrative script.</font>
</p>

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="165698"></a><b>Prerequisites</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165699"></a>You must be logged on as the database administrator (typically, the user ID <font face="Courier New, Courier, sansserif, sans serif" size="2">oracle</font>). </font>
</li>
</ul>
</p>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="165700"></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="165702"></a>Create a new <font face="Courier New, Courier, sansserif, sans serif" size="2">crontab</font> file or edit an existing <font face="Courier New, Courier, sansserif, sans serif" size="2">crontab</font> file to include a Storage Checkpoint creation entry with the following space-delimited fields:</font>
</li>
<a name="165703"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">			<em>minute hour day_of_month month_of_year day_of_week</em><em> </em>\<br>				/opt/VRTS/bin/dbed_ckptcreate</font>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165704"></a>where:</font>
</blockquote>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165705"></a><em>minute</em> - numeric values from 0-59 or *</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165706"></a><em>hour</em> - numeric values from 0-23 or *</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165707"></a><em>day_of_month</em> - numeric values from 1-31 or *</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165708"></a><em>month_of_year </em>- numeric values from 1-12 or *</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165709"></a><em>day_of_week</em><em> </em>- numeric values from 0-6, with 0=Sunday or *</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165710"></a>Each of these variables can either be an asterisk (meaning all legal values) or a list of elements separated by commas. An element is either a number or two numbers separated by a hyphen (meaning an inclusive range). </font>
</blockquote>
</ul>
</p>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165711"></a>See the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_ckptcreate</font>(1M), <font face="Courier New, Courier, sansserif, sans serif" size="2">cron</font>(1M), and <font face="Courier New, Courier, sansserif, sans serif" size="2">crontab</font>(1) manual pages for more information.</font>
</li>
</ul>
</p>



<h3><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="165713"></a>Scheduling Storage Checkpoint Creation in a cron Job</font>
</h3>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165715"></a>To create a Storage Checkpoint twice a day, at 5:00 a.m. and 7:00 p.m., every Monday through Friday, include the following entry in your <font face="Courier New, Courier, sansserif, sans serif" size="2">crontab</font> file:</font>
</li>
<a name="165716"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">			<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>0 5,19 * * 1-5 /opt/VRTS/bin/dbed_ckptcreate -S PROD </b></font>\<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>				-H /oracle/product/9i -o instant</b></font></font>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165718"></a>To create a Storage Checkpoint at 11:30 p.m., on the 1st and 15th day of each month, include the following entry in your <font face="Courier New, Courier, sansserif, sans serif" size="2">crontab</font> file:</font>
</li>
<a name="165719"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">			<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>30 23 1,15 * * /opt/VRTS/bin/dbed_ckptcreate -S PROD </b></font>\<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>				-H /oracle/product/9i -o instant</b></font></font>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165721"></a>To create a Storage Checkpoint at 1:00 a.m. every Sunday while the database is offline, include the following entry in your <font face="Courier New, Courier, sansserif, sans serif" size="2">crontab</font> file:</font>
</li>
<a name="165722"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">			<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>0 1 * * 0 /opt/VRTS/bin/dbed_ckptcreate -S PROD </b></font>\<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>				-H /oracle/product/9i -o offline</b></font></font>
</ul>
</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_appAcli_sf_dbag145_165619.html" title="Displaying Storage Checkpoints Using dbed_ckptdisplay">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_appAcli_sf_dbag144_165548.html" title="Previous - Creating Storage Checkpoints Using dbed_ckptcreate">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_appAcli_sf_dbag146_165726.html" title="Next - Mounting Storage Checkpoints Using dbed_ckptmount">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>
