Home » Server Options » RAC & Failsafe » RAC/TAF does not support Transaction Failover - WHY
RAC/TAF does not support Transaction Failover - WHY [message #276727] Fri, 26 October 2007 02:14 Go to next message
vipassana
Messages: 2
Registered: October 2007
Junior Member
I am trying to understand RAC and have some questions. Appreciate anyone who can help me understand

1) The TAF in a RAC setup does not support transaction failover (DMLs will be rolled back), but only Query failover is supported. Why is this? If it can have the query image and using the instance which is alive, why cant it retain the DML image also and provide failover? Can someone please explain?

When a SELECT failsover, the instance still dies. But the SELECT statement from the dying instance is somehow taken and re-executed on the alive instance and fetched. For the User, its as if nothing happened.

In case of say an UPDATE, why cant Oracle take the UPDATE statement and re-execute in the alive instance again, so that its much as in the case of SELECT statment for the User as explained above as if nothing happnened.

The point is why does RAC demand for the User to re-execute the Update statement? It can rollback the transaction and re-execute the update statement on its own since it has the intelligence of what the Update statement was much like the select.

Please let me know, this is really important for me to understand



2) When a Query failover happens, I believe the select statment is re-issued. In this case will the SCN be different from the original. If so, how is read consistency maintained.

Thanks
Vipassana
Re: RAC/TAF does not support Transaction Failover - WHY [message #276889 is a reply to message #276727] Fri, 26 October 2007 11:09 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
AFAIK
Actually in RAC there are multiple redo threads depending on the nodes and undo tablespaces if you are using UNDO_MANAGEMENT=auto.

Basically cache fusion is the process for transferring dirty blocks among different instances for read consistancy.

let say a user A connected to NODE A using the thread A for his activities and i guess his data is not written to thread B and he try to perform DMLs on EMP table in the mean while the node crashes.
The surviving node will perform recovery for crashed node means LMON process initiates recovery action for the failed node in recovery process LMON re mastering the GCS and GES and instance recovery.


NOTE
at this stage the RAC enviroment is in a state of SYSTEM PAUSE and most of the TRANSACTIONS suspend until ORACLE completes recovery.
Re: RAC/TAF does not support Transaction Failover - WHY [message #277013 is a reply to message #276889] Sat, 27 October 2007 23:44 Go to previous messageGo to next message
vipassana
Messages: 2
Registered: October 2007
Junior Member
Dreamz thanks. I however think my question still remains unansweered Smile
Re: RAC/TAF does not support Transaction Failover - WHY [message #277020 is a reply to message #276727] Sun, 28 October 2007 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) because Oracle does not currently how to do it safely.
2) query is reexecuted as scn of first start

Regards
Michel
Re: RAC/TAF does not support Transaction Failover - WHY [message #283705 is a reply to message #277020] Wed, 28 November 2007 00:34 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Dear all!

I am a newbie on RAC environment, and would you like to answer some questions:

1/ What are the parameters must I have to configure using Load balancing and failover features on RAC?

2/ Why and how I can test the feature's actions?

Thank you very much!
Re: RAC/TAF does not support Transaction Failover - WHY [message #283720 is a reply to message #283705] Wed, 28 November 2007 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OracleŽ Database Concepts
Chapter 17 High Availability
Section Overview of Transparent Application Failover

Database Net Services Administrator's Guide
Chapter 13 Enabling Advanced Features of Oracle Net Services
Section Configuring Runtime Connection Load Balancing
Section Configuring Transparent Application Failover

Oracle Call Interface Programmer's Guide
Chapter 9 OCI Programming Advanced Topics
Section Transparent Application Failover Callbacks in OCI

C++ Call Interface Programmer's Guide
Chapter 11 Optimizing Performance of OCCI Applications
Section Transparent Application Failover

Database JDBC Developer's Guide and Reference
Chapter 28 Transparent Application Failover

...

Regards
Michel

[Updated on: Wed, 28 November 2007 00:50]

Report message to a moderator

Re: RAC/TAF does not support Transaction Failover - WHY [message #283773 is a reply to message #283720] Wed, 28 November 2007 02:19 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, Micheal!

Please view 2 my files Listener.ora and tnsname.ora

LISTENER.ora
Quote:


# listener.ora.db01 Network Configuration File: /oracle/db10gr2/network/admin/listener.ora.db01
# Generated by Oracle configuration tools.

LISTENER_DB01 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db01-vip)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.60.30)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)




TNSNAME.ora

Quote:


# tnsnames.ora Network Configuration File: /oracle/db10gr2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

GDKH_SVC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db01-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db02-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gdkh_svc)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)

GDKH =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db01-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db02-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gdkh)
)
)

GDKH2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db02-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gdkh)
(INSTANCE_NAME = gdkh2)
)
)

GDKH1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db01-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gdkh)
(INSTANCE_NAME = gdkh1)
)
)

LISTENERS_GDKH =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db01-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db02-vip)(PORT = 1521))
)
cabman =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.60.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = omch)
)
)




These above files are configured by the others, and I did not know that they were right or not.

Thank you!
Re: RAC/TAF does not support Transaction Failover - WHY [message #283775 is a reply to message #283773] Wed, 28 November 2007 02:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
At first sight it seems correct.

Regards
Michel
Re: RAC/TAF does not support Transaction Failover - WHY [message #283804 is a reply to message #283775] Wed, 28 November 2007 03:20 Go to previous message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, Michel!

Because of the old employee who configured this RAC system, leaved this company, now I have to manage it. Recently, some customer complained that their connections failures.

Executed AWR, STATSPACK, I found that our application cause the DB hang.

Thank you for your instructor!
Previous Topic: RAC listeners configuration problem
Next Topic: ownership of ocr and voting disk files
Goto Forum:
  


Current Time: Thu Mar 28 12:55:15 CDT 2024