Food for thoughts Rac One a first Step to explore

Introduction.

Some months ago I have implemented an Active Passive Solution on Oracle 11gr2 for on one of the customers.  Basically this was almost reliving old days where  tools like HP MC Service Guard (using packages where one or more database and listener configurations are stored)  or  Veritas Clusterware  (where and Agent controls the status of the resources being a database and or a listener). They would  monitor  the health of the Database/Listener,  would stop and start the Database/ Listener. With the technology at hand at that point and time ( implemented 11.2.0.2 Grid Infra with ASM and 11.2.0.2 Rdbms )  it was not   having all the required   setups to implement anything else.  Now we are 9 months further in time,  standards have been adapted and we have latest Oracle version at hand ( being 11.2.0.3) so it is time for a fresh start. Besides that recently I have been asked to  implement the Active Passive solution on more environments (since it does cover  part off HA and it controls the monitoring  of the Database/ Instance  by HP-Openview).

Instead I have recommended to investigate in which way RAC One can be an option for us as a Solution for new / existing  environments that will have to  be on 11.2.0.3 GI and Rdbms . Meanwhile we also got new experiences with Acfs  which we will use as a shared Diag_destination.   So my  challenge will be now  that I have to set up and test and compare the solotions (Active Passive  Instance in Grid Infra  versus Rac One ). So it is time to do a lot of reading , and soon testing. Since  I really believe Internet is an awesome source I have been looking what colleagues and Documentation I could find already on this topic.  Below you will find a Number of Usefull links on this topic. It is a mix  of Documentation and posts and it might grow a bit even.  A special word of thanks to Martin Bach  and  Bernhard de Cock Buning for their sharing on the web with regard to this topic. From first analyses  i can only say  that i love the way  that Omotion is  promising the relocate / fail-over so i look forward to work with it and get a better experience about it.

# presentation on rac One 
http://www.ogh.nl/downloads/ogh20120214_b._de_cock_bunning.pdf
#Rac one Rac Sig webcast v2.1.pdf
http://www.google.nl/url?sa=t&rct=j&q=&esrc=s&source=web&cd=10&ved=0CJoBEBYwCQ&url=http%3A%2F%2Fwww.oracleracsig.org%2Fpls%2Fapex%2FAPEX_UTIL.COUNT_CLICK%3Fp_url%3DRAC_SIG.download_my_file%3Fp_file%3D1003078%26p_id%3D1003078%26p_cat%3Ddocuments%26p_user%3Dnobody%26p_company%3D994323795175833&ei=oIzMUK-6NoKM0wWMvYGACg&usg=AFQjCNFwldtOQ1SzxVVyy0S2ff_bT00nTw&sig2=uVDDXm_S92w59eSGHi7OJw&bvm=bv.1355325884,d.d2k
 
## Great post by Martin Carstenbach on topic of Rac One
http://martincarstenbach.wordpress.com/tag/rac-one-node/
## Administering Oracle RAC One Node
http://docs.oracle.com/cd/E11882_01/rac.112/e16795/onenode.htm
# How to proceed if you convert  to Oracle Rac  and Racle Rac One node from Single Instance:
http://docs.oracle.com/cd/E11882_01/install.112/e24660/cvrt2rac.htm
##The DBA’s Guide to Setting Up Oracle RAC One Node and Oracle Data Guard by Martin Bach
http://www.oracle.com/technetwork/articles/oem/raconenode-dataguard-435121.html
## Oracle RAC One Node 11g Release 2 User Guide
http://www.oracle.com/technetwork/products/clustering/overview/ug-raconenode-2009-130760.pdf?ssSourceSiteId=otncn
##The DBA’s Guide to Setting Up Oracle RAC One Node and Oracle Data Guard, Part 2 (Advanced) by Martin Bach
http://www.oracle.com/technetwork/articles/oem/raconenode-dataguard-2-435128.html

The  links above , the offered documentation I will use for my test scenarios where I will set up  a for various scenarios before offering it as an option to the business.

Basically  the following scenarios will be used:

  • Set up a complete Rac One database  via DBCA  and after that  see and look under the hood  how such instance is generated and implemented.
  • Parallel to that would set op A  Single Database – Instance  and set it up similar to my current environment and see how much effort it will be to convert it to rac one.
  • A special point  that needs to be taken care of  in both scenarios is the fact how a Monitoring Tool like HP Openview can deal with a Database that is  relocating to another server using the Omotion that  Rac one is offering. I will have to find a solution to switch of the  Hp Openview agent and activate it again after a relocate. So  that might be a bit of an extra challenge . Smiles but no one said it all would be easy  right ?

Happy reading , and stay tuned for another article on this topic . Oh and before I forget of course it would be great if you want to share your experience with Rac One with me ..

Mathijs

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s