QUICK GUIDE


old primary site

SQL>select switchover_status from v$database;
SQL>alter database commit to switchover to physical standby with session shutdown;
SQL>shutdown immediate
SQL>startup nomount
SQL>alter database mount standby database;
SQL>alter system set log_archive_dest_state_2=defer;
old standby site
SQL>select switchover_status from v$database;
SQL>alter database commit to switchover to primary;
SQL>shutdown immediate
SQL>startup
old primary site
SQL>recover managed standby database disconnect


EXPLANATIONS


1. Verify that it is possible to perform a switchover operation.

On the primary query the switchover_status column of v$database to verify that
switchover to standby is possible.

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

------------------

TO STANDBY

In order to perform a switchover all sessions to the database need to be disconnected. This process has been automated with the “with session shutdown” clause that has been added to the alter database commit to switchover command.
If SWITCHOVER_STATUS returns SESSIONS ACTIVE then you should either disconnect all sessions manually or when performing step 2 you should append the “with session shutdown” clause.

For example:

SQL> alter database commit to switchover to standby with session shutdown;

Note that the clause also works with the switchover to primary command.

The SWITCHOVER_STATUS column of v$database can have the following values:

NOT ALLOWED - Either this is a standby database and the primary database has not been switched first, or this is a primary database and there are no standby databases.

SESSIONS ACTIVE - Indicates that there are active SQL sessions attached to the primary or standby database that need to be disconnected before the switchover operation is permitted.

SWITCHOVER PENDING - This is a standby database and the primary database switchover request has been received but not processed.

SWITCHOVER LATENT - The switchover was in pending mode, but did not complete and went back to the primary database.

TO PRIMARY - This is a standby database, with no active sessions, that is allowed to switch over to a primary database.

TO STANDBY - This is a primary database, with no active sessions, that is allowed to switch over to a standby database.

RECOVERY NEEDED - This is a standby database that has not received the switchover request.

During normal operations it is acceptable to see the following values for
SWITCHOVER_STATUS on the primary to be SESSIONS ACTIVE or TO STANDBY.

During normal operations on the standby it is acceptable to see the values of
NOT ALLOWED or SESSIONS ACTIVE.


2. Convert the primary database to the new standby:

SQL> alter database commit to switchover to physical standby ;

Database altered.

3. Shutdown the former primary and mount as a standby database:

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 85020944 bytes

Fixed Size 454928 bytes

Variable Size 71303168 bytes

Database Buffers 12582912 bytes

Redo Buffers 679936 bytes

SQL> alter database mount standby database;

Database altered.

4. Defer the remote archive destination on the old primary:

SQL> alter system set log_archive_dest_state_3=defer;

5. Verify that the physical standby can be converted to the new primary:

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

------------------

SWITCHOVER PENDING

Note that if the status returns SESSIONS ACTIVE then you should append the with session shutdown clause to the command in step 6.

6. Convert the physical standby to the new primary:

SQL> alter database commit to switchover to primary;

Database altered.

7. Shutdown and startup the new primary:

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 85020944 bytes

Fixed Size 454928 bytes

Variable Size 71303168 bytes

Database Buffers 12582912 bytes

Redo Buffers 679936 bytes

Database mounted.

Database opened.

8. Enable remote archiving on the new primary to the new standby:

SQL> alter system set log_archive_dest_state_3=enable;

9. Start managed recover on the new standby database:

SQL> recover managed standby database disconnect;

Media recovery complete.

24 Responses so far.

  1. Anonymous says:

    Is it possible to switchover again and go back to initial scenario?
    I mean that old primary become the primary again.

    Can I do the same steps again?

    Thanks

  2. Hi,
    yes of course you can.

  3. Anonymous says:

    What about the ini files. Do I need to recreate pfile from spfile after this?

  4. McCool says:

    \This is a great sharing, I m glad to read such article. i appreciate the writer for sharing good info. Keep sharing such kind of nice info thanks

  5. Anonymous says:

    what changes do we need to make in the parameter files of both the database?

  6. Anonymous says:

    Last step in Quickguide has typo mistake:-

    old primary site
    SQL>recover managed standby database disconnect

    Old Primary site must be New Primary Site.

  7. Anonymous says:

    How would this work if you were running RAC?

  8. sravanthi says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.


    Oracle Fusion Financials Online Training

  9. WhatsApp Status Video Download :WhatsApp introduced the status feature in 2015, in which we can share images, videos, and gifs as our story for 24 hours. Before this feature, WhatsApp had only text status option in which we can write our bio, but the new status feature is different. The story or status disappears after 24 hours and can’t be archived as still in WhatsApp.

    Boy attitude status video download for whatsApp
    Boy attitude status video download
    Boy attitude status video download

    Most romantic status video download for whatsApp
    Sad video status download
    Most Romantic status video download

    video status download for whatsApp


    we have latest & best collection of video status download for whatsapp

  10. khushboo says:

    The registrations and auditions for the Bigg Boss 13 are going to start soon. The official list of contestants is not yet announced by the officials. That will be announced by the makers on the inaugural day which is 15 the of September. bigg boss 13 contestants name list with photo and details Though a few rumored names are coming up as the expected celebrity contestants of the year. They are Nia Sharma, Raghav Juyal, Punit Pathak, Divyanka Tripathi, Garima Chaurasia, Ridhima Pandit, Aditya Narayan, Jasmin Bhasin, Zain Imam, Bhuvan Bam, Chetna Pande, Krystle D’Souza, and Devoleena Bhattacharjee. This year too, the show will be back with a new theme and the star host, Salman Khan. Though the theme is not declared yet officially. Stay tuned with us to know more about the show Bigg Boss 13.

  11. Nice post. your article is really informative and helpful for me and other bloggers too

    Big Data and Hadoop Online Training
    Big Data Hadoop Training
    Hyderabad

  12. If you lack a Digital team or lack of budget to hire a PPC professional , grow the Web traffic with the best Outsource PPC Services. Mega Web Design is the only company to assure your affordable and quality service of Topmost eCommerce Development India. Also providing SEO services with affordable SEO plans. Contact us for more details at info@megawebdesign.in


  13. If you want to buy WPC Board & Shuttering Boards, then take a look at the JKD Plastics. JKD Plastics is one of the trusted WPC Board & Shuttering Boards Suppliers in India . The WPC Board & Shuttering Boards is the ideal choice for all builders, constructors, and retailers. Please get to know more about our products visit our website or call us now at 7404257964.

  14. Mate biz says:

    Want to give your Business Website a proper Brand name with the best logo design services? Matebiz is ready to provide your website with an aesthetic look with custom logo design services because good logo design counts and helps identify your Business. We are also known as the most hired PPC services provider Company , India, also providing SEO services with affordable SEO plans. Contact us for more details at info@matebiz.com.

  15. Are you Looking for India's best SMO Company , which can help you get more sales and leads from the internet? Here Local SEO Company is a person who can help you and your business to achieve your online business goals. We are India's top SEO & SMO Company; we help your company to achieve business goals at affordable rates. Contact Now!!!

  16. emedkit says:


    Are you searching for breast cancer, blood cancer, lung cancer, medicines at lowest price in India and worldwide? Order cancer drugs online at reasonable prices on Emedkit. We at Emedkit.com is India’s first and only online specialty pharmacy that provides cost-effective anti-cancer medicines.

  17. Anonymous says:

    Promote ABHI SEO Services company Delhi are essential when you are looking to rank your website on the search engine result pages. Promote Abhi, being the affordable SEO Company in Delhi, helps you with the result that you expect from a top SEO services company. What are you waiting for, COME ON NOW, FOLLOW MY LEAD!

  18. Teknoloji, film, dizi, sağlık ve sosyal medya içerik sitesi.

  19. The curriculum is a vital part of both online and offline teaching. A comprehensive curriculum means that half of the task of a good teaching pedagogy has been fulfilled. If you are in search of a good curriculum development service provider curriculum development service provider then Acadecraft is sure to be your first choice. We provide premium curriculum services at affordable prices.

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -