New Features for DBA’s

Subscribe to Posts by Email


 

Subscriber Count

    699

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages
«  
  »

11g RAC Failover Test Cases

Hello All,

We all build RAC infrastructure and we have seen many cases that environment is not stable after live or when start using it.

The reasons may be many, but due to vast technologies involvement in high availability concepts we do not know or we ignore many aspects while doing environment testing.

It is indeed very important, We need to do end to end test cases with regards to failovers as the high availability infrastructure is meant for that.  Zero failure tolerance, or Connection failover or what ever the case this test cases should be structured, well organized so that our high availability solution to business critical systems should be fool proof.

Have collected the RAC failover test cases from various sources and modified a bit , attached here in with categorical wise which may be useful to you all when some one ask you about to do testing of RAC new environment.

This documents contains,

Category of testing

Action & Target we are testing

Steps to carry out testing

Expected result of testing

Test result to record

Category Test Cases Document Remarks
Clusterware
Testing		 Private Network Cable FailuresPublic Network Cable Failures

RAC Host Failures

Oracle HA Features

Vendor HA Features

11gR2 New Features testing (OCR/Voting/HAIP etc)

 Download here
Storage RAC Host-to-Storage Cable FailuresRAC Host-to-Storage NIC/HBA Failures

Storage Rack/Enclosure Failures

Oracle File Corruption or I/O Fencing Scenarios

NAS/SAN Storage Administrative Tasks

 

 Download here
Stress Run heavy database load Download here
ASM Kill ASM InstanceFail ASM Disks

Reboot node while adding one ASM Disk

Destroy One failgroup while in normal redundancy

 Download here
ACFS Kill VDBG ProcessPhysically fail one of the ASM failure diskgroups

Resize ACFS disks by acfsutil

 Download here

-Thanks

Geek DBA

October 23rd, 2012 | Tags: | Category: GridInfrastructure, RACFailoverCases

Comments are closed.