Re: Change Datafile Location on Standby Database - Sanity Check

  • From: "David Barbour" <david.barbour1@xxxxxxxxx>
  • To: GovindanK <gkatteri@xxxxxxxxx>
  • Date: Thu, 13 Dec 2007 14:06:38 -0500

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@xxxxxxxxx> 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
>
>

Other related posts: