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 184.108.40.206 Grid Infra with ASM and 220.127.116.11 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 18.104.22.168) 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 22.214.171.124 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 ..