Oracle Training Oracle Support
Oracle Training
SQL Tuning Consulting
Oracle Tuning Consulting
Data Warehouse Consulting
Oracle Project Management
Oracle Security Assessment
Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Internals Magazine
Oracle Links
Oracle Monitoring
Remote Support Benefits
Remote Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices
 

Free Oracle Tips


 
HTML Text AOL
 
 

Using Oracle RAC Guard Commands for Planned Outages

September 4,  2003
Don Burleson

 

When planned outages occur, use pfsctl commands to shut down the instance on the node where maintenance will be performed. The next procedure contains general instructions for shutting down both the primary role node and secondary role node. When one node is unavailable, Oracle RAC Guard cannot perform failover.

Planned Outage on the Secondary Node

The procedure for using pfsctl commands for a planned outage on the secondary node follows:

  1. Stop the secondary instance. Use commands similar to the following:

# pfsctl
PFSCTL> stop_secondary

  1. When the command completes you will see output similar to the following:

stop_secondary command succeeded.

  1. Complete the desired maintenance on the secondary node.

  2. Restore the secondary instance to the secondary node. Use the following command:

PFSCTL> restore

The output is similar to:

restore command succeeded.

Planned Outage on the Primary Node

For a planned outage on the primary node use the following pfsctl commands:

  1. Move the primary role to the secondary instance. Use commands similar to the following:

# pfsctl
PFSCTL> move_primary

When the command completes you will see output similar to the following:

move_primary command succeeded.

  1. Complete the desired maintenance on the former primary node.

  2. Restore the secondary role to the former primary node. Use the following command:

PFSCTL> restore

When the command completes you will see output similar to the following:

restore command succeeded.

(Optional) Move the primary role back to the original primary node and restore the secondary role to the original secondary node. Use the following command:

PFSCTL> switchover

When the command completes you will see output similar to the following:

switchover command succeeded.


If you like Oracle tuning, check out my latest book
"Oracle Tuning: The Definitive Reference". 

It's 980 pages of hard-core tuning insights, tips and scripts, and you can buy it direct from the publisher for 30%-off. 

 

 
 

 

 

   

Copyright © 1996 -  2011 by Burleson Enterprises. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.