File rename in standby with OMF
Datfile on primary (Prod):
+DG1/prod/user.dbf
Datafile on Stdby
+DG1/prod/user.dbf
On stdy we wanted this file to in
the folder.
+DG1/std_prod/user.dbf
However, Oracle has created soft link and handling this internally which we can see within asmcmd.
Everytime we add a datafile on primary, we use OMF and let oracle handle the path.
But in the past somebody has added the datafile with absolute path and this resulted
in the soft link creation on stdby.
When we are cloning from stdby, we need to look into this path always. We want to get rid of this, and correct the path on Stdby.
How can we do this ?
The path on PRIMARY is correct. But on stdby we want the file to be moved to different folder.
Is this possible ?
We are on 11gR1 on Linux.