Database - RAC/Scalability (MOSC)

MOSC Banner

Transparent Application Continuity For DML and DRL

in Database - RAC/Scalability (MOSC) 20 commentsAnswered

Hi Team,

We have implemented Oracle 19c RAC at our premises and trying to achieve Oracle Transparent Application Continuity. We have used the below command to create the database service:

srvctl add service -db DBSID -service DBSERVICE –preferred inst1 -available

serv2 -failover_restore AUTO -failoverretry 1 -failoverdelay 3 -

commit_outcome TRUE -failovertype AUTO -replay_init_time 600 -retention

86400 -notification TRUE -drain_timeout 300 -stopoption IMMEDIATE

After creating the service, we are connecting to the database through the service and running a set of DML Queries.

Whilst the DML is running, we shutdown the instance the client is connected to and when this happens, we get various oracle errors due to which we are required to close and re-establish the session.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center