<!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>Cloning the Oracle Instance Using dbed_clonedb</title>

</HEAD>

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

<a name="165980"></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_dbag152_165957.html" title="Previous - Managing Capacity Planning Utility Using dbed_ckptplan">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_appAcli_sf_dbag154_166297.html" title="Next - Creating and Working with Snapplans Using 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>
	
<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="165980"></a> Cloning the Oracle Instance Using dbed_clonedb</font>
</h2>

        
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165983"></a>You can use the VERITAS Storage Foundation for Oracle <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_clonedb</font> command to clone an Oracle instance using a Storage Checkpoint. Cloning an existing database using a Storage Checkpoint must be done on the same host.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165984"></a>You have the option to manually or automatically recover the Oracle database when using the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_clonedb</font> command:</font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165985"></a>Manual (interactive) recovery, which requires using the <font face="Courier New, Courier, sansserif, sans serif" size="2">-i</font> option, of the clone database allows the user to control the degree of recovery by specifying which archive log files are to be replayed.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165986"></a>Automatic (non-interactive) recovery, which is the default usage of the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_clonedb</font> command, recovers the entire database and replays all of the archive logs. You will not be prompted for any archive log names.</font>
</li>
</ul>
</p>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="165989"></a><b>Prerequisites</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165991"></a>You must be logged in as the database administrator.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165992"></a>Make sure you have enough space and system resources to create a clone database on your system.</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165993"></a>A clone database takes up as much memory and machine resources as the primary database.</font>
</blockquote>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="165996"></a>You must first create a Storage Checkpoint. (See <a href="oracle_hp_appAcli_sf_dbag144_165548.html#165548">Creating Storage Checkpoints Using dbed_ckptcreate</a>.)</font>
</li>
</ul>
</p>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="166011"></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="166012"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_clonedb</font> command is used to create a copy of an Oracle database, cloning all existing database files to new locations.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166013"></a>The ORACLE_SID and ORACLE_HOME environment variables must be set to the primary database.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166015"></a>It is assumed that the user has a basic understanding of the Oracle recovery process.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166016"></a>See the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_clonedb</font>(1M) manual page for more information.</font>
</li>
</ul>
</p>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="166092"></a><b>Options <Table width="100%" border="0" cellpadding="1" cellspacing="0" > <tr valign="top"><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166020"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-S </font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>CLONE_SID</em></font></font> </p>  </td><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166022"></a>Specifies the name of the new Oracle SID, which will be the name of the new database instance.</font> </p>  </td></tr><tr valign="top"><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166024"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-m </font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>MOUNT_POINT</em></font></font> </p>  </td><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166026"></a>Indicates the new mount point of the Storage Checkpoint.</font> </p>  </td></tr><tr valign="top"><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166028"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-c </font><font face="Courier New, Courier, sansserif, sans serif" size="2"><em>CKPT_NAME</em></font></font> </p>  </td><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166030"></a>Indicates the name of the Storage Checkpoint.</font> </p>  </td></tr><tr valign="top"><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166032"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-i</font></font> </p>  </td><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166034"></a>Runs the command in interactive mode where you must respond to prompts by the system. The default mode is non-interactive. (Optional)</font> </p>  </td></tr><tr valign="top"><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166036"></a>-o umount</font> </p>  </td><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166038"></a>Shuts down the clone database and unmounts the Storage Checkpoint file system. </font> </p>  </td></tr><tr valign="top"><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166040"></a>-o restartdb</font> </p>  </td><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166042"></a>Mounts the Storage Checkpoint file system and starts the clone database. The <font face="Courier New, Courier, sansserif, sans serif" size="2">-o restartdb</font> option will not attempt to recover the clone database.</font> </p>  </td></tr><tr valign="top"><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166044"></a>-d</font> </p>  </td><td><p> <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166046"></a>Used with the <font face="Courier New, Courier, sansserif, sans serif" size="2">-o umount</font> option. If the <font face="Courier New, Courier, sansserif, sans serif" size="2">-d</font> option is specified, the Storage Checkpoint used to create the clone database will be removed along with the clone database.</font> </p>  </td></tr> </Table>   <Table width="100%" border="0" cellpadding="1" cellspacing="0"> <tr><td> </Table></b></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="166093"></a>&nbsp;&nbsp;<b>To clone an Oracle instance with manual Oracle recovery</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166094"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_clonedb</font> command as follows:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166095"></a>&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_clonedb&nbsp;-S&nbsp;NEW9&nbsp;-m&nbsp;/local/oracle9/1&nbsp;</b></font>\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166096"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;-c&nbsp;Checkpoint_988813047&nbsp;-i</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166097"></a>&nbsp;Primary&nbsp;Oracle&nbsp;SID&nbsp;is&nbsp;TEST9i
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166098"></a>&nbsp;New&nbsp;Oracle&nbsp;SID&nbsp;is&nbsp;NEW9
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166099"></a>&nbsp;Checkpoint_988813047&nbsp;not&nbsp;mounted&nbsp;at&nbsp;/local/oracle9/1
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166100"></a>&nbsp;Mounting&nbsp;Checkpoint_988813047&nbsp;at&nbsp;/local/oracle9/1
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166101"></a>&nbsp;Using&nbsp;environment-specified&nbsp;parameter&nbsp;file
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166102"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/local/oracle9/links/dbs/initTEST9i.ora
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166103"></a>&nbsp;Default&nbsp;Oracle&nbsp;parameter&nbsp;file&nbsp;found:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166104"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/local/oracle9/links/dbs/initTEST9i.ora
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166105"></a>&nbsp;Copying&nbsp;/local/oracle9/links/dbs/initTEST9i.ora
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166106"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;to&nbsp;/local/oracle9/1/testvol
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166107"></a>&nbsp;Control&nbsp;file&nbsp;'ora_control2'
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166108"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;path&nbsp;not&nbsp;explicitly&nbsp;specified&nbsp;in&nbsp;init&nbsp;file;&nbsp;assuming
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166109"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ORACLE_HOME/dbs
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166110"></a>&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166111"></a>&nbsp;All&nbsp;redo-log&nbsp;files&nbsp;found
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166112"></a>&nbsp;Copying&nbsp;initTEST9i.ora&nbsp;to&nbsp;initNEW9.ora
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166113"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;in&nbsp;/local/oracle9/1/testvol
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166114"></a>&nbsp;Altering&nbsp;db_name&nbsp;in&nbsp;initNEW9.ora
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166115"></a>&nbsp;Altering&nbsp;control&nbsp;file&nbsp;locations&nbsp;in&nbsp;initNEW9.ora
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166116"></a>&nbsp;Creating&nbsp;new&nbsp;link&nbsp;for&nbsp;clone&nbsp;database&nbsp;init&nbsp;file
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166117"></a>&nbsp;Creating&nbsp;archive&nbsp;log&nbsp;directory
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166118"></a>&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166119"></a>&nbsp;About&nbsp;to&nbsp;start&nbsp;up&nbsp;new&nbsp;database&nbsp;and&nbsp;begin&nbsp;reconfiguration
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166120"></a>&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166121"></a>&nbsp;Database&nbsp;NEW9&nbsp;is&nbsp;being&nbsp;reconfigured
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166122"></a>&nbsp;Altering&nbsp;clone&nbsp;database&nbsp;archive&nbsp;log&nbsp;directory
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166123"></a>&nbsp;Updating&nbsp;log_archive_dest&nbsp;in&nbsp;clone&nbsp;database&nbsp;init&nbsp;file
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166124"></a>&nbsp;Found&nbsp;archive&nbsp;log&nbsp;destination&nbsp;at&nbsp;/testvol
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166125"></a>&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166126"></a>&nbsp;The&nbsp;latest&nbsp;archive&nbsp;log(s)&nbsp;must&nbsp;now&nbsp;be&nbsp;applied.&nbsp;To&nbsp;apply
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166127"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;the&nbsp;logs,&nbsp;open&nbsp;a&nbsp;new&nbsp;window&nbsp;and&nbsp;perform&nbsp;the&nbsp;following&nbsp;steps:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166128"></a>&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166129"></a>&nbsp;1.&nbsp;copy&nbsp;required&nbsp;archive&nbsp;log(s)&nbsp;from&nbsp;primary&nbsp;to&nbsp;clone:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166130"></a>&nbsp;&nbsp;&nbsp;primary&nbsp;archive&nbsp;logs&nbsp;in&nbsp;/testvol
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166131"></a>&nbsp;&nbsp;&nbsp;clone&nbsp;archive&nbsp;logs&nbsp;expected&nbsp;in&nbsp;/local/oracle9/1/testvol
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166132"></a>&nbsp;2.&nbsp;ORACLE_SID=NEW9;&nbsp;export&nbsp;ORACLE_SID&nbsp;#&nbsp;sh&nbsp;and&nbsp;ksh,&nbsp;OR
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166133"></a>&nbsp;&nbsp;&nbsp;setenv&nbsp;ORACLE_SID&nbsp;NEW9&nbsp;#csh
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166134"></a>&nbsp;3.&nbsp;/local/oracle9/links/bin/sqlplus&nbsp;/nolog
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166135"></a>&nbsp;4.&nbsp;CONNECT&nbsp;/&nbsp;AS&nbsp;SYSDBA
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166136"></a>&nbsp;5.&nbsp;RECOVER&nbsp;DATABASE&nbsp;UNTIL&nbsp;CANCEL&nbsp;USING&nbsp;BACKUP&nbsp;CONTROLFILE
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166137"></a>&nbsp;6.&nbsp;enter&nbsp;the&nbsp;archive&nbsp;log(s)&nbsp;you&nbsp;wish&nbsp;to&nbsp;apply
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166138"></a>&nbsp;7.&nbsp;EXIT
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166139"></a>&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166140"></a>&nbsp;Press&nbsp;&lt;Return&gt;&nbsp;after&nbsp;you&nbsp;have&nbsp;completed&nbsp;the&nbsp;above&nbsp;steps.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166141"></a>&nbsp;&lt;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>Return</b></font>&gt;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166142"></a>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166143"></a>&nbsp;Resetting&nbsp;logs&nbsp;on&nbsp;new&nbsp;database&nbsp;NEW9
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166144"></a>&nbsp;Database&nbsp;instance&nbsp;NEW9&nbsp;is&nbsp;up&nbsp;and&nbsp;running
</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="166148"></a>&nbsp;&nbsp;<b>To clone an Oracle instance with automatic Oracle recovery</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166149"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_clonedb</font> command as follows:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166150"></a>&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_clonedb&nbsp;-S&nbsp;NEW9&nbsp;-m&nbsp;/local/oracle9/1&nbsp;</b></font>\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166151"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;-c&nbsp;Checkpoint_988813047</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166152"></a>&nbsp;Primary&nbsp;Oracle&nbsp;SID&nbsp;is&nbsp;TEST9i
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166153"></a>&nbsp;New&nbsp;Oracle&nbsp;SID&nbsp;is&nbsp;NEW9
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166154"></a>&nbsp;Checkpoint_988813047&nbsp;not&nbsp;mounted&nbsp;at&nbsp;/local/oracle9/1
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166155"></a>&nbsp;Mounting&nbsp;Checkpoint_988813047&nbsp;at&nbsp;/local/oracle9/1
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166156"></a>&nbsp;Using&nbsp;environment-specified&nbsp;parameter&nbsp;file
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166157"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/local/oracle9/links/dbs/initTEST9i.ora
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166158"></a>&nbsp;Default&nbsp;Oracle&nbsp;parameter&nbsp;file&nbsp;found:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166159"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/local/oracle9/links/dbs/initTEST9i.ora
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166160"></a>&nbsp;Copying&nbsp;/local/oracle9/links/dbs/initTEST9i.ora
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166161"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;to&nbsp;/local/oracle9/1/testvol
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166162"></a>&nbsp;Control&nbsp;file&nbsp;'ora_control2'
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166163"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;path&nbsp;not&nbsp;explicitly&nbsp;specified&nbsp;in&nbsp;init&nbsp;file;&nbsp;assuming
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166164"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ORACLE_HOME/dbs
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166165"></a>&nbsp;
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166166"></a>&nbsp;All&nbsp;redo-log&nbsp;files&nbsp;found
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166167"></a>&nbsp;Copying&nbsp;initTEST9i.ora&nbsp;to&nbsp;initNEW9.ora
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166168"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;in&nbsp;/local/oracle9/1/testvol
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166169"></a>&nbsp;Altering&nbsp;db_name&nbsp;in&nbsp;initNEW9.ora
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166170"></a>&nbsp;Altering&nbsp;control&nbsp;file&nbsp;locations&nbsp;in&nbsp;initNEW9.ora
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166171"></a>&nbsp;Creating&nbsp;new&nbsp;link&nbsp;for&nbsp;clone&nbsp;database&nbsp;init&nbsp;file
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166172"></a>&nbsp;Creating&nbsp;archive&nbsp;log&nbsp;directory
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166173"></a>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166174"></a>&nbsp;About&nbsp;to&nbsp;start&nbsp;up&nbsp;new&nbsp;database&nbsp;and&nbsp;begin&nbsp;reconfiguration
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166175"></a>&nbsp;Database&nbsp;NEW9&nbsp;is&nbsp;being&nbsp;reconfigured
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166176"></a>&nbsp;Starting&nbsp;automatic&nbsp;(full)&nbsp;database&nbsp;recovery
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166177"></a>&nbsp;Shutting&nbsp;down&nbsp;clone&nbsp;database
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166178"></a>&nbsp;Altering&nbsp;clone&nbsp;database&nbsp;archive&nbsp;log&nbsp;directory
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166179"></a>&nbsp;Updating&nbsp;log_archive_dest&nbsp;in&nbsp;clone&nbsp;database&nbsp;init&nbsp;file
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166180"></a>&nbsp;Found&nbsp;archive&nbsp;log&nbsp;destination&nbsp;at&nbsp;/testvol
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166181"></a>&nbsp;Mounting&nbsp;clone&nbsp;database
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166182"></a>&nbsp;Resetting&nbsp;logs&nbsp;on&nbsp;new&nbsp;database&nbsp;NEW9
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166183"></a>&nbsp;Database&nbsp;instance&nbsp;NEW9&nbsp;is&nbsp;up&nbsp;and&nbsp;running
</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="166278"></a>&nbsp;&nbsp;<b>To shut down the clone database and unmount the Storage Checkpoint</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166279"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_clonedb</font> command as follows:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166280"></a>&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_clonedb&nbsp;-S&nbsp;NEW9&nbsp;-o&nbsp;umount</b></font>
</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="166281"></a>&nbsp;&nbsp;<b>To mount a Storage Checkpoint file system and start the clone database</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166282"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_clonedb</font> command as follows:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166283"></a>&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_clonedb&nbsp;-S&nbsp;NEW9&nbsp;-o&nbsp;restartdb</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166284"></a>&nbsp;Database&nbsp;instance&nbsp;NEW9&nbsp;is&nbsp;up&nbsp;and&nbsp;running.
</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="166285"></a>&nbsp;&nbsp;<b>To delete a clone database and the Storage Checkpoint used to create it</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="166286"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbed_clonedb</font> command as follows:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="166287"></a>&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/dbed_clonedb&nbsp;-S&nbsp;NEW9&nbsp;-o&nbsp;umount&nbsp;-d</b></font>
</font>

<!-- 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_dbag153_165980.html" title="Cloning the Oracle Instance Using dbed_clonedb">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_dbag152_165957.html" title="Previous - Managing Capacity Planning Utility Using dbed_ckptplan">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_appAcli_sf_dbag154_166297.html" title="Next - Creating and Working with Snapplans Using 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>
