DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT
646155Nov 1 2010 — edited Nov 1 2010hello guys,
I am configuring a data guard with one physical standby on VMWARE.. with primary database on one system and physical standby on the other.. database 11g r2
oracle document says that the DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT has to mentioned if the directory structure is going to be different on both the sites.
directory structure on the primary database will be
/u01/app/oracle/oradata/oracle/
and on standby will be
/u01/app/oracle/oradata/oracles/
now my question is do we have to set this parameter on the standby system (i use RMAN to create the standby using DUPLICATE command so it renames the filepath of all the datafiles on the standby system during duplication process.) or on the primary database tooo please tell me..
i believe the log_file_name_convert parameter need not be set as the RMAN will automatically create the logfiles. please tell me if i am correct..