Oracle 1204 RAC failover test (1)

Source: Internet
Author: User
Tags failover

1. Check if RAC is normal
[Oracle @ racdb01 ~] $ Crs_stat-T
Name type target State host
------------------------------------------------------------
Ora. RAC. DB application online racdb01
Ora... s1.inst application online racdb01
Ora... s2.inst application online racdb02
Ora... esdb. CS application online racdb01
Ora... es1.srv application online racdb01
Ora... es2.srv application online racdb02
Ora... 01. lsnr application online racdb01
Ora... b01.gsd application online racdb01
Ora... b01.ons application online racdb01
Ora... b01.vip application online racdb01
Ora... 02. lsnr application online racdb02
Ora... b02.gsd application online racdb02
Ora... b02.ons application online racdb02
Ora... b02.vip application online racdb02

2. Connect to the database and check the instance
Select instance_name from V $ instance;

Instance_name
--------------
Rac2

3. Test

Test 1

Remove the public network cable of rac2

Rac2 automatic reboot

[Oracle @ racdb01 ~] $ Crs_stat-T
Name type target State host
------------------------------------------------------------
Ora. RAC. DB application online racdb01
Ora... s1.inst application online racdb01
Ora... s2.inst application online offline
Ora... esdb. CS application online racdb01
Ora... es1.srv application online racdb01
Ora... es2.srv application online offline
Ora... 01. lsnr application online racdb01
Ora... b01.gsd application online racdb01
Ora... b01.ons application online racdb01
Ora... b01.vip application online racdb01
Ora... 02. lsnr application online offline
Ora... b02.gsd application online offline
Ora... b02.ons application online offline
Ora... b02.vip application online racdb01
 
Check the connection status and find that instance 1 is automatically connected.
Select instance_name from V $ instance;

Instance_name
--------------
Rac1

Refer to the original rac2 network, reboot rac2

[Oracle @ racdb02 ~] $ Crs_stat-T
Name type target State host
------------------------------------------------------------
Ora. RAC. DB application online racdb01
Ora... s1.inst application online racdb01
Ora... s2.inst application online racdb02
Ora... esdb. CS application online racdb01
Ora... es1.srv application online racdb01
Ora... es2.srv application online racdb02
Ora... 01. lsnr application online racdb01
Ora... b01.gsd application online racdb01
Ora... b01.ons application online racdb01
Ora... b01.vip application online racdb01
Ora... 02. lsnr application online racdb02
Ora... b02.gsd application online racdb02
Ora... b02.ons application online racdb02
Ora... b02.vip application online racdb02

Check the connection status and still connect to instance 1
Select instance_name from V $ instance;

Instance_name
--------------
Rac1

Test 2

Remove the public network cable of Rac1

Check the status and find that VIP1 is flowing to rac2

[Oracle @ racdb01 ~] $ Crs_stat-T
Name type target State host
------------------------------------------------------------
Ora. RAC. DB application online racdb01
Ora... s1.inst application online racdb01
Ora... s2.inst application online racdb02
Ora... esdb. CS application online racdb01
Ora... es1.srv application online offline
Ora... es2.srv application online racdb02
Ora... 01. lsnr application online offline
Ora... b01.gsd application online racdb01
Ora... b01.ons application online racdb01
Ora... b01.vip application online racdb02
Ora... 02. lsnr application online racdb02
Ora... b02.gsd application online racdb02
Ora... b02.ons application online racdb02
Ora... b02.vip application online racdb02

After two minutes, check the status again and find an exception. VIP1 & VIP2 are all down and the database cannot be used.
[Oracle @ racdb01 ~] $ Crs_stat-T
Name type target State host
------------------------------------------------------------
Ora. RAC. DB application online racdb01
Ora... s1.inst application online racdb01
Ora... s2.inst application online offline
Ora... esdb. CS application offline
Ora... es1.srv application online offline
Ora... es2.srv application online offline
Ora... 01. lsnr application online offline
Ora... b01.gsd application online racdb01
Ora... b01.ons application online racdb01
Ora... b01.vip application online offline
Ora... 02. lsnr application online offline
Ora... b02.gsd application online offline
Ora... b02.ons application online offline
Ora... b02.vip application online offline

Try to check the CRS status on rac2 and report an error. It is fruitless to manually start CRS.
[Oracle @ racdb02 ~] $ Crs_stat-T
CRS-0184: cannot communicate with the CRS daemon.

Test failed. Find the cause .......

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.