CAWA DE Failover to Dataguard Database

[TRAVIS ANDERSON]

Hello everyone,

Wondering if anyone has any experience with changing the db connection for DE and utilizing the dataguard database. We will be migrating our production database in a few months and will failing the product over to our dataguard db. Also, do you recommend stopping all jobs before shutting down DE or can we get by without doing this? I've outlined the steps i have so far.

1. Shutdown DE
2. Change jdbc URL using the setdbparm utility located in bin
3. Test the connection using the validateDbConnection script
4. Start DE

[Nitin Pande]

Hi Travis,
You can hold all the events.  Then shut down the DE server.  Next, move the database and change the DB information in DE to point to new DB.
You can change the DB location by setting the JDBC URL via setdbparm utility (in bin).

setdbparm jdbc.URL
Changing JDBC url (jdbc.URL)
Enter new JDBC url: <your_new_JDBC_url_with_new_host>

Run validateDbConnection.sh (in bin) to check the connection to DB.
Restart DE.  It will connect to your new DB.  Jobs that were active (running), if completed will then update as Agents send new states messages to DE.
You can then un-hold or un-suspend the events.

HTH,

Nitin Pande

------------------------------
Support
Broadcom
Toronto
------------------------------

[TRAVIS ANDERSON]

Ok so we don't need to kill all jobs before bringing down DE then. I know what is expected with a simple change role but wasn't sure when changing databases how DE handles the states and any updates to the jobs.

So just to confirm, when DE is down and we are changing the DB connection, if a job fails on the server level (agent side) or if it simply completes then the state will be updated accordingly when DE is brought up correct?

[Nitin Pande]

Yes, if DE is down, the agent will simply keep trying to reach the manager and will not lose the job state information unless something is done to the agent (e.g. stop or uninstall etc.).  Once DE is backup, all the agents will be able to reach it and offload all the job information.

------------------------------
Support
Broadcom
Toronto
------------------------------