Oracle Articles, Oracle Tools, Oracle Tips, Database Articles and DBA Tips  

The Largest Online Resource for Oracle Articles, Oracle Tips, Oracle Scripts & Oracle Tools!!


Enter your Email:
 
Navigate at FreeMegaZone Home      Articles      Tools      Jobs      Games      Support      Submit Content      Advertise
Advertise at http://www.articles.freemegazone.com

Advertise at FreeMegaZone

Give tremendous boost to your business by advertising at FreeMegaZone. Contact webmaster@freemegazone.com

 

Rating: *****                                             Rate this article:    

 Author: Donald K. Burleson

Page: 1 2

In this article I will discuss recovery from an unplanned outage by using Oracle RAC Guard.

Oracle Recovery on Single Node:

Oracle RAC Guard automatically fails over to the secondary node when an unplanned outage occurs on the primary node. It notifies the user that a role change has occurred. In such scenario Oracle RAC Guard operates in a non-resilient state with the primary role on the former secondary node.

After you have performed root cause analysis and repaired the source of the fault, restore the secondary role on the former primary node by using the restore command

PFSCTL> restore

The primary and secondary roles have now been reversed. You can now continue to operate in one of the following modes.

Operate with Reversed Primary and Secondary Roles

 

  • After restoring both packs, you can continue to operate with primary and secondary roles that are reversed from the initial state.
  • For sites with symmetric configurations, there is no need to return to the original state.
  • Returning to the original roles requires a planned outage and can be avoided.
  • Some users intentionally operate with role reversal on a fixed schedule (such as every three months), in order to test the capabilities of the system.

Return to the Original Primary/Secondary Configuration

 

  • Returning to the original primary/secondary configuration requires a planned outage while the primary role is moved.
  • Plan it for a less busy part of your business cycle and give advance notice to users. Execute it as

# pfsctl
PFSCTL> switchover

Choose a Less Critical Application to Restore

 

  • If there is more than one uniquely identified database on each node, then performance will be degraded after a failover, under most conditions.
  • If a two-node cluster is in a primary/secondary configuration and an unrelated database is running on the secondary node, then the secondary node runs the primary services, as well as the unrelated database, after failover and may be overloaded. In this situation, move the less critical service to the other node when it is restored.
  • Perform the following steps for each of the services that are moved to the restored node
  • Set the oracle_service and db_name environment variables.

$ export ORACSLE_SERVICE=SALES
$ export DB_NAME=sales

  • Restore the instance with secondary role

# pfsctl
PFSCTL> restore

  • Move the primary role to the original primary node

PFSCTL> switchover

Page: 1 2

 More Oracle Articles, Database Articles and DBA Tips
   Database Security: Step by step guideline
   Oracle: Achieving performance goal - Part I
   Performance Gains by improving Oracle indexes!!
   Oracle Remote DBA and Oracle Remote DBA Support Services
   Great Tips for Protecting Oracle Listener!!


FreeMegaZone Jobs!!

 

 
HOME      ABOUT US      SUPPORT      SITE MAP      PRIVACY POLICY      TERMS OF USE      SUBMIT CONTENT      ADVERTISE
Copyright © 2007 - 2012 Oriole Intellect Inc. All rights reserved.

The name Oracle is a trademark of Oracle Corporation. Any other names used on this website may be trademarks of their respective owners