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

Other related posts: