As part of new build we need to do node failover testing hence documenting some steps known to me
Objective
|
Action |
Expectations
|
To test
accidental change of |
Modify
etc/hosts and change |
The
cluster must not be able to |
To test
the failure of ASM instance |
On Node
1, kill the processes |
The
cluster must not be affected |
To test
the failover of the network |
Plug out
one of the cableconnecting |
The ping
from the client |
To test
the stability of the db by killing a
ora server process |
kill off
a process related to the |
The sql
session should not be |
To test
thecomplete failover of the session in event of a node(e.g. sudden shutdown |
1.
Connect from the client to the database via sqlplus. |
The sql
session should not be |
To test
the failover session of a |
1.
Connect from a client to node1 in the RAC Environment usingsqlplus. |
The sql
connection should be able to |
To test
Crash of Grid Processes |
Kill
Lmon process on rac node |
They
must be restarted |
To Test for automatically shifting of |
Reboot
Node 1 using the OS |
1. When
noe 1 goes down all scan |
To test
storage crash |
Forcibly
make scan disk unvisible to |
The
cluster must go down and |
TAF
failoer test |
to test
sql and session failover |
|
No comments:
Post a Comment