How to Set Up SQL Server 2012 AlwaysOn Availability Groups

Advantages

• fail over automatically
• ability to run reports on the live database
• Run backup on standby server

Prerequisites

• 2 Windows Server 2008 R2 Enterprise servers
• NET Framework 3.5.1 feature
• Failover Clustering feature

Steps

• Configure Failover Cluster Manager.
• Join 2 servers to the the same domain
• Create Cluster Wizard
• Install SQL Server stand-alone installation
• In Configuration Manager, enable AlwaysOn by clicking SQL Server Services

Diagnose RAC Problems

How to displays the top-level view of the cluster.
# cd /u01/app/11.2.0/grid/bin
# ./crsctl check cluster -all

How to gives information about the individual resources.
# ./crsctl stat res -t
Once the Oracle software is installed, the cluvfy utility is available to provide useful post-installation information. Use the "-help" flag for usage information.

$ cluvfy stage -help
$ cluvfy stage -post crsinst -n ol6-112-rac1,ol6-112-rac2
Oracle provide the RACcheck tool (MOS [ID 1268927.1]) to audit the configuration of RAC, CRS, ASM, GI etc. It supports database versions from 10.2-11.2, making it a useful starting point for most analysis. The MOS note includes the download and setup details.

$ unzip raccheck.zip
$ cd rachcheck
$ chmod 755 raccheck
$ ./raccheck -a