Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

scope=spfile in DB_FILE_NAME_CONVERT

Neo-bApr 9 2013 — edited Apr 9 2013
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,

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 7 2013
Added on Apr 9 2013
4 comments
5,316 views