Skip to Main Content

Oracle Database Discussions

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!

RAC physical standby for single instance primary database ?

Tiny_Aug 5 2019 — edited Aug 5 2019

Dear sirs,

I have the following situation:

  • Primary single instance database (12.2) with file-system data files (no ASM)
  • A two nodes RAC database with ASM (same version 12.2)
  • I need to use data guard (physical standby) to replicate the single instance database into RAC one, then perform switch-over in order to make the RAC database as primary database.

Questions:

  • Is this possible ?
  • What about standby logfiles, how to create standby logfiles for both threads (because it's 2 nodes database) on primary database (the single instance one) or this is not required ?
  • Do the parameters (log_file_name_convert and db_file_name_convert) help to avoid the difference in directory names (/u01/... to +DATA/... for example) ? .. can I make successful switch-over even if storage options are different?

Kindly advice and thanks ..

Comments
Post Details
Added on Aug 5 2019
2 comments
1,838 views