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!

How to make poor man's dataguard switch role?

Beauty_and_dBestFeb 15 2019 — edited Mar 4 2019

11gR1

OL5

Hi ALL,

We are configuring a "poor man's dataguard" for Standard Edition database.

I want to switch role back and forth from PRIMARY to STANDBY and back to PRIMARY.

How does dataguard technology able to do it? Can I imitate the process using the SE database?

Scenario:

MyOld site x running

MyStandby remote site y running

Continuous applying logs to MyStandby.

MyOld takes a long nap.

Failover to MyStandby (yey promotion), processing new entries.

(open database reset logs)

Goal: Reuse MyOld as standby when it wakes up without transferring terabytes across the network.

New situation:

MyStandby: primary

MyOld: standby

Please help...

Kind regards,

jc

This post has been answered by JohnWatson2 on Feb 18 2019
Jump to Answer
Comments
Post Details
Added on Feb 15 2019
13 comments
376 views