Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Change Datafile Location on Standby Database - Sanity Check
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_at_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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 13 2007 - 13:06:38 CST
![]() |
![]() |