Hello All,
I am using Oracle 11g R2 and I am configuring Data guard between a primary database (RAC 2 nodes) and a physical standby database single instance.
I want to create my standby database without shutting down the primary database, one of the requirement is to set the below 2 parameters :
alter system set DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/STANDBY','+DATA/ORCL/DATAFILE' scope=spfile;
alter system set LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/STANDBY','+DATA/ORCL/ONLINELOG' scope=spfile;
These parameters cannot be set at the memory level, it can be set only if i mentioned "scope=spfile"
Does that require to restart my primary database? or it will directly take affect even if scope=spfile?
Regards,