DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=DOJDXLe9nGg93Tz0QZVLDG5mWIYojupazAjwA3sHY0CtA8RRC1DIzOZYFgxGC8ZhAf1d52bqEA8JN5VqHbsAzzJI1eSzNuOhM1HmUVrpnEW9RN7Y0jIv1m3whJJoHJhGa+wuU0Uir7tsp3UPu8840rENDgPTnaBbNwSoN5kwlTA=
Message-ID: <69eafc3f0712131106s4ef69b79y37276a2279f8109b@mail.gmail.com>
Date: Thu, 13 Dec 2007 14:06:38 -0500
From: "David Barbour" <david.barbour1@gmail.com>
To: GovindanK <gkatteri@gmail.com>
Subject: Re: Change Datafile Location on Standby Database - Sanity Check
Cc: oracle-l <oracle-l@freelists.org>
In-Reply-To: <475DCE7D.2080007@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_31203_27713162.1197572798831"
References: <69eafc3f0712070854n1925cb77y67086d24ff14301f@mail.gmail.com>
	 <475DCE7D.2080007@gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: david.barbour1@gmail.com
------=_Part_31203_27713162.1197572798831
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Thanks everybody.  GovindanK was/is correct, there was no need to do
anything on the primary.  Worked like a charm.

On 12/10/07, GovindanK <gkatteri@gmail.com> wrote:
>
>  I do not see the need to touch the standby_file_management parameter in
> Primary. In your scenario, your steps on Standby require little
> modifications.
>
> Here are the *comments*:
>
> 1. I would prefer to have mapping for *ALL*  the files mentioned in the
> db_file_name_convert and log_file_name_convert parameters.
> 2. After you mount the standby instance verify with *show parameter
> management, show parameter convert.  *If your standby_file_management is
> set to auto they should show up. *
> *3. Step 1 should be done before Step 8; Your order would be 2,
> 3,4,5,7,1,8,9 (I am assuming that your init.ora in standby contains
>     standby_file_management=auto by default hence you are doing alter
> system to make it manual).
>
> HTH
> GovindanK
>
>

------=_Part_31203_27713162.1197572798831
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Thanks everybody.&nbsp; 
GovindanK was/is correct, there was no need to do anything on the primary.&nbsp; Worked like a charm.<br><br><div><span class="gmail_quote">On 12/10/07, <b class="gmail_sendername">GovindanK</b> &lt;<a href="mailto:gkatteri@gmail.com">
gkatteri@gmail.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">


<div bgcolor="#ffffff" text="#000000">
I do not see the need to touch the standby_file_management parameter in
Primary. In your scenario, your steps on Standby require little
modifications. <br>
<br>
Here are the <b>comments</b>:<br>
<br>
1. I would prefer to have mapping for <b>ALL</b>&nbsp; the files mentioned
in the db_file_name_convert and log_file_name_convert parameters.<br>
2. After you mount the standby instance verify with <b>show parameter
management, show parameter convert.&nbsp; </b>If your
standby_file_management is set to auto they should show up. <b><br>
</b>3. Step 1 should be done before Step 8; Your order would be 2,
3,4,5,7,1,8,9 (I am assuming that your init.ora in standby contains<br>
&nbsp;&nbsp;&nbsp; standby_file_management=auto by default hence you are doing alter
system to make it manual).<br>
<br>
HTH<br>
GovindanK<br>
<br>
</div>

</blockquote></div><br>

------=_Part_31203_27713162.1197572798831--
--
http://www.freelists.org/webpage/oracle-l