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?
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.
My Oracle Support Community Administrator