Oracle Database Standby Database Failover for Oracle 10g

Step 1. If the standby database is in managed recovery mode, it will need to be cancelled and the instance shutdown using the IMMEDIATE option:

SQL> recover managed standby database cancel;
Media recovery complete.

SQL> shutdown immediate

Step 2. Startup the instance and then MOUNT the DB in standby mode:

SQL> connect / as sysdba
Connected to an idle instance.

SQL> startup nomount

SQL> alter database mount standby database;

Database altered.


Step3. Apply the primary database’s archived logs by recovering the standby database:

SQL> recover standby database until cancel;

A CANCEL will need to be performed as this is Incomplete Recovery.

Step4. Activate the standby database.

In issuing the ALTER DATABASE ACTIVATE STANDBY DATABASE command, the standby bit in the control file is reset. This process takes the database back to nomount mode:

SQL> alter database activate standby database;

Database altered.

NOTE: This process can take several minutes to complete so be patient!


Step 7. Shutdown and restart the new primary database. This step ensures that all file headers are reset and clears all buffers.

SQL> shutdown immediate

SQL> startup open

SQL>select name,open_mode,database_role from v$database;

8. Check Listener

9.Try to connect “sqlplus username/passwd@pr1


About shanojkumar

• Oracle Certified Professional with over 15 years of IT experience in database administration and support. • Certifications: OCP (12c, 11g & 10g), Oracle Database 11g Performance Tuning Certified Expert (OCE), ITIL V3 Certified and LPIC-1(Linux). • Oracle Certified Expert in oracle database performance tuning has solved over 100 database performance problems. • Quality oriented IT professional with notable success in Banking, Airlines, Retails, FMGC, Telecommunication and Media projects. • Maintaining an online technical blog - contributed more than 54+ articles based on ‘Database Administration’ real life scenarios on: – 258,429 visitors all over the world. • Instructor of one of the most appreciated courses (Oracle Dataguard 12c) on Udemy with an average rating of 5 star. • Supervised a team of database administrators and technical infrastructure team members. Created documentation on best practices for database performance tuning and Oracle application installation practices.
This entry was posted in Oracle and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s