« The Oracle-Validated rpm is available for all users | Main | Data Guard Fast Start Failover Reference Implementation »

Using Oracle Clusterware 11g to Protect a Single Instance Database

Protecting a single instance database using ASM and oracle Clusterware has been made simpler in 11g.

I did follow the instructions from Philip Newlan Paper "Using Oracle Clusterware to Protect A Single Instance Oracle Database 11g" and produced a step by step list of implementing this procedure on an existing cluster on Linux.

This is the report I've produced: Protecting a single instance with Oracle Clusterware 11g

This is a summary of the implementation steps:

1. Create a single instance on one of the nodes of an existing Oracle Cluster
2. Add a new virtual IP’s to /etc/hosts
3. Add to listener.ora a new Listener on both nodes
4. Add to tnsnames.ora the new listener on both nodes
5. Setup Management Scripts on $CRS_HOME/crs/public On Both Nodes
6. Create and register “resource group” rg1 for the instance to protect
7. Create and register the resource rg1.vip
8. Change the new resource vip permissions to root
9. Check the new vip by starting it
10. Test the application Listener
11. Create and register resource rg1.listener
12. Prepare the database to be registered as a cluster resource of the rg1 group
13. Create and register resource rg1.db_protsing for the protsing database
14. Test relocating the group
15. Create and register resource rg1.head that contros startup order of rg1 resources
16. Check that the resources on the group start
17. Test planned failover
18. Test unplanned failover
19. Test failover on node crash

TrackBack

TrackBack URL for this entry:
http://blogs.oracle.com/mte1521/mt-tb.cgi/8507

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

About This Entry

This page contains a single entry from the blog posted on November 15, 2008 1:11 PM.

The previous post in this blog was The Oracle-Validated rpm is available for all users.

The next post in this blog is Data Guard Fast Start Failover Reference Implementation.

Many more can be found on the main index page or by looking through the archives.

Top Tags

Powered by
Movable Type and Oracle