Re: Change Datafile Location on Standby Database - Sanity Check

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-l