Hi Joe,
I'm allowing The Oracle team to manage the databases they have two databases Autosys does not know about the second one. My database crash and Autosys didn't failover he continue to run on the primary server no rollover. Oracle switch to there backup and resolved the issue and call me to tell me that everything is working as expected. There was no outage.
That was over a year ago. I'm not using a third machine bcp program none of that. Only primary (Jacksonville) secondary (Little rock) keep in mind since Oracle team is managing your database. they are backing it up. If it fails the backup takes over you will not know it... unless there is a major problem and your primary might not failover.
When we installed the primary server it asked what is your database name.. ? "autoprod" install was completed and move to the secondary the Oracle team did some magic and said start your install. We started the secondary install and I asked what is your database name "autoprod" the install was completed the config file shows using the VIP. Check with your network.
Believe me it's much better.. hope this helps... ask CA Support about it.
Jdcupautosys1 primary database
Lrlupautosys1 secondary database
Config File example
#-------------------------------------------------------------------#
# # # # # Application Server Parameters # # # # #
#-------------------------------------------------------------------#
#+----------
#
# Keyword: AutoServer=<hostname>
#
# Defines the host name of the application server that you want to
# connect to.
#
AutoServer=jdcupautosys1,lrlupautosys1
Thanks,
Ezra Carroll
281 728 8909
Thanks,
Ezra Carroll
Workload Automation AE – Prod Control
281-728-8909
This message is intended for the exclusive use of the intended addressee. If you have received this message in error or are not the intended addressee or his or her authorized agent, please notify me immediately by e-mail, discard any paper copies and delete all electronic files of this message.