RE: RAC Failover testing
- From: "Rich Amick" <rAmick@xxxxxxxxxxx>
- To: <anuragdba@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 25 Aug 2006 13:20:17 -0700
Even with TAF, the code is responsible for replaying any uncompleted
transactions.
Please see:
http://download-west.oracle.com/docs/cd/B10501_01/rac.920/a96597/pshavdtl.ht
m#7001
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Anurag Verma
Sent: Friday, August 25, 2006 10:17 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RAC Failover testing
Hi,
I am doing Testing on Oracle 9i RAC databases now.
Ours is a 2-node RAC on IBM HACMP with GPFS.
The TNS entry on the client side, I use is given below:
MYDB =
(DESCRIPTION =
(ENABLE=BROKEN)
(FAILOVER=ON)
(LOAD_BALANCE=ON)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST=RAC1.NODE1.com)(PORT=1521))
(ADDRESS = (PROTOCOL = TCP)(HOST=RAC2.NODE2.com)(PORT=1521)))
(CONNECT_DATA =
(SERVICE_NAME=FNWFI1)
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=250)(DELAY=5))
)
)
For Failover testing, I connected to the first node, and ran a long SELECT
query.
When the SELECT runs, I shut down the instance in the first node, with
"shutdown immediate" command.
I get the following message.
======================================================================
ERROR:
ORA-01089: immediate shutdown in progress - no operations are permitted
960 rows selected.
SQL>
SQL> ex
ERROR:
ORA-25408: can not safely replay call
======================================================================
Here above, if I do not exit and check the V$instance, it shows the session
got switched over
to the surviving instance, even though the SELECT got stopped.
Why this is happening, as I am using (ENABLE=BROKEN) and (TYPE=SELECT)
options???
Surprisingly, the test succeeds on some other servers with the same DB
Physical structure
and memory parameters, by automatically failing over the SELECT query to the
surviving node, and without the
query being halted.
Is there any Operating System setting we need to set for successful
failover?
Thanks in advance,
Best Regards,
Anurag
Other related posts:
