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.
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
Hi,
yes of course you can.
What about the ini files. Do I need to recreate pfile from spfile after this?
\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
what changes do we need to make in the parameter files of both the database?
Last step in Quickguide has typo mistake:-
old primary site
SQL>recover managed standby database disconnect
Old Primary site must be New Primary Site.
How would this work if you were running RAC?
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
1movies
movies whatsapp groups
dtc bus app
dtc bus
dtc bus app download
dtc bus pass
dtc bus route
dtc bus route app
dtc bus app download
funny WiFi names
cool WiFi names
claver WiFi names
cool and claver WiFi names
funny WiFi names list
Good wifi names
wifi names 2020
Disney wifi names
wifi name for gamers
bollywood movies funny WiFi names
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
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.
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
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
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.
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.
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!!!
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.
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!
Teknoloji, film, dizi, sağlık ve sosyal medya içerik sitesi.
good blog. your blog is really informative and helpful for me
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Oracle Integration Cloud Online Training
Oracle Fusion Technical Online Training
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.