Oracle 12c database switchover steps using OEM and blackout mode steps

This article will show Oracle 12c database switchover steps using OEM and blackout mode steps:


  • Oracle database switchover steps using OEM

Search the primary database name in the Search Target Name Textbox and the respective Standby database will get 
display to their below which I numbered as 2. If you have multiple standby database for single primary then too all standby 
database will be shown in number 2 section with their respective hostname in next field.
There is Switchover button marked will green box in below image, you have click it to begin switchover

Primary database information Page


















From above,

  1. Primary database name
  2. Standby database name
  3. Primary server hostname
  4. Standby server hostname


Now OEM will ask credentials which are set or you can enter manually by selecting 'New'but here I have used 'Named'
credentials. Below image will show the database name and hostname on which your Primary database will get switchover
,read this image information very carefully and press the continue button.

Ask for credentials


















Here it will ask for confirmation to switchover database, press yes button if you are agree

Ask for Confirmation















Your switchover is now in processing meanwhile you can read the information on page, it will be handy for 
referencing in future

Switchover Inprogress















After switchover below information will get display, this info is vice versa of image 1

From Below:

  1. Primary database name which was standby before switchover.
  2. Standby database name which was primary before switchover.

Vice-Versa Information with reference to Image 1


















  • How to put Host/databases in blackout mode from OEM

We use to put host/database in blackout mode when there is any activity on server or databases, so that any alerts will not pop-up in OEM.
For making blackout do below steps

1) Goto OEM select >> Enterprise----->Monitoring----->Blackouts
2) Click "Create" button
3) Next click on "Add" button
4) From "Target Type" select "Host"
5) In target name write hostname which you wanted to put in blackout mode, for example: test1 or test2 etc..
6) Click >> "Go" -------> select checkbox of hostname which pop-up below and press "Select"
7) Click >> "Next"------->Keep clicking "Next" upto step 5 ---->Now in 5 Step from "Duration" select "Indefinite"----> press Next

Now your Server will be in Blackout mode.....

Hope this information will help you for swictover and to put database in blackout mode, please share this info if you like it…

Please share If you like..Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on Yummly


Add a Comment
  1. You got to push it-this essinteal info that is!

  2. There’s noticeably a bundle to find out about this. I assume you made sure good factors in options also.

  3. After study a number of of the blog posts in your website now, and I actually like your method of blogging. I bookmarked it to my bookmark website listing and can be checking again soon. Pls check out my web site as well and let me know what you think.

  4. Youre so cool! I dont suppose Ive read something like this before. So good to search out someone with some authentic thoughts on this subject. realy thank you for starting this up. this web site is one thing that is wanted on the internet, somebody with slightly originality. useful job for bringing something new to the internet!

  5. Hi there! I simply want to give an enormous thumbs up for the nice info you’ve gotten right here on this post. I shall be coming back to your weblog for more soon.

  6. WONDERFUL Post.thanks for share..more wait .. ?

  7. you’ve gotten a great weblog right here! would you prefer to make some invite posts on my weblog?

  8. I happen to be commenting to make you know of the beneficial encounter my cousin’s child undergone browsing your web page. She realized such a lot of pieces, which included what it’s like to have a great giving heart to have the rest effortlessly understand some grueling topics. You really exceeded visitors’ desires. I appreciate you for rendering the beneficial, trusted, edifying and even easy guidance on this topic to Evelyn.

  9. WONDERFUL Post.thanks for share..more wait .. ?

  10. Oh my goodness! a tremendous article dude. Thank you Nevertheless I am experiencing situation with ur rss . Don抰 know why Unable to subscribe to it. Is there anyone getting identical rss downside? Anyone who knows kindly respond. Thnkx

Leave a Reply

Your email address will not be published. Required fields are marked *

Fariddin Shaikh's Oracle DBA Blog © 2016 Being DBA
Go Back