Physical Standby using ASM & OMF
The problem I'm having is that if I create a datafile on the primary by explicitly specifying the disk group and the name of the disk group is different from the db_create_file_dest parameter, then the file created on the standby is in another disk group (specified by the db_create_file_dest parameter) on the standby. The parameter values are the same on both. Is there a way to overcome this behaviour? The only solution I see to this is by disabling OMF on the standby or on both the primary and standby. Setting the DB_FILE_NAME_CONVERT parameter will not work because if I happen to want