This content has been marked as final. Show 2 replies
995587 wrote:Yes... It complete possible, but your application need support Oracle RAC.
I have RAC with Dbnode1 and Dbnode2 and my application submit job in Dbnode1 .job is running and Dbnode1 is down .
It possible running Job automatically move on the Dbnode2 .
1 App1 and App2 node /DBNode2 and DBNode1 node are running.
2 Application batch submit successfully from Appnod1/DBnode1 and DBNode1 goes down in middle of the batch.
3 Pending Job will not switch automatically on DBnode2.
Client Failover Best Practices for Highly Available Oracle Databases: Oracle Database 11g Release 2
Application Failover with Oracle Database 11g
How to develop it:
Transparent Application Failover in OCI
Yes, iti is possible. All you need to do is to
- create a service with preferred node as Dbnode1 and available node as Dbnode2.
- Create a job class JC which maps to above service
- Assign your job to the job class (JC) created above
Now, when DBnode1 is down,
- service fails over to Dbnode2
- All the jobs belonging to the job class JC failover to Dbnode2 along with the service
Hope it helps