Database Failover Questions
By Owen Allen on Jan 16, 2014
In the post about installing Ops Center, one of the steps is setting up the database that Ops Center will use. You can use a co-located database on the EC system, or you can set up your own database and configure Ops Center to use it.
On that second option, I saw a couple of questions:
Can Ops Center be installed using a Data Guard customer managed database?
Data Guard is an Oracle tool for providing high availability and disaster recovery for an Oracle database. It can be used with Ops Center. The only thing to keep in mind is that, if your database fails over to a system with different connection parameters, you need to direct Ops Center to use the new system using the Changing the Customer-Managed Database Location procedure.
Can the RemoteDBProps.txt contain entries for both the active and standby databases?
No. The RemoteDBProps.txt file is used for the initial configuration. If you have a standby database in a separate location, you have to switch using the procedure described above.