create controlfile in standby database
we are having physical standby database and production database .
we have create a soft link for a datafile in production to another mount point
ex- /disk1/data1 to /disk2/data1
now we want to keep the datafile in /disk2/data1 and remove the softlink
As we are having physical standby database . i need to know what are step to be taken.
my action plan is as follows:
1. synchronise both standby(apply archive logs) and production.
2.shut down the standby
3.create controlfile in production in ascii format and edit the path (/disk1/data1 to /disk2/data1)
4. run the @control.sql that i have created
4.create a standby control file in production .
In standby :
1. take the backup of controlfile.
2.place the newly create controlfile(from production) to the location of controlfile
3. remove soft link.
5. then we can apply logs as usual to make the standby sync.
please help me to know whether my action plan is 100% correct or any changes to be done .
Thanks in advance.