Oracle 12c SE Switch-Over

3583830 wrote:

 

Hi ,

 

We are using Oracle 12c Standard Edition, we maintain manual physical standby DR site , In which, we transfer the archive log files manually to the DR site and then apply them there. In such cases, it is very difficult to use oracle internal switch over mechanism.The customers wants to do the DR drill with this manual DR site.

please share your valuable suggestion on this .Thank you

What "oracle internal switch over mechanism" are you referring to?  Since this is SE, DataGuard is not supported, so there is no concept of 'switchover'.  You've created your own DG (common with SE installations) and so have to create you own switchover accordingly.  It would involve modifying everyone's tnsnames.ora.

BTW, did you notice the name of the forum space in which you posted this?

Hi 3583830,

Thank you for your post! You have published your question within the Community Feedback and Suggestions (No Product Questions) (MOSC) space, which is designated for community platform related inquiries. To help you find the best place to move this question to and get you in touch with the best Oracle and customer experts, I suggest you review this document, How to Find the Right Space in Which to Post Your Product Question.

Additionally, we also ask that all community users Update Your Community Display Name and Avatar! This will help others more easily identify with you in the community, and provide the most successful communication.

Thank you!

Alexis

My Oracle Support Community Administrator

This post was moved from *Community Feedback and Suggestions (No Product Questions) (MOSC) to IDGOUG - (International Data Guard Oracle User Group)

There is no official switchover activity with Standard edition. still, you can try with other methods, Worth to check https://blog.pythian.com/oracle-11g-se-switch-over/