Users Guide

Database Recovery Procedures | Oracle Database Management
174 OMNM 6.5.3 Installation Guide
Database Recovery Procedures
You can recover Oware’s backed up databases if your system fails. The quality of recovery naturally
depends on the frequency and integrity of the database backups. The more frequent the backups,
the less data loss occurs. Since Oware supports multiple database types, the method used to recover
the databases differs according to type.
If RMAN is in place, use it for recovery. If it is not in place, and you have used the OS backups (
On-
line/Off-line Backup (OS)
on page 173), consult Oracle’s manuals for their recovery procedures.
Oracle Failover
Oracle RAC is a clustering solution from Oracle that allows this application to communicate with a
database cluster using one service name. This also provides failover and load balancing.
• Oracle versions that support RAC: 9.2.0.5 or newer. In an RAC configuration, all nodes access
a single database. Dorado Software applications built with Oware 6.0.2 and later support
Oracle RAC. See
Software Requirements on page 15.
• RAC requires specific hardware and Cluster Manager software to run. Refer to Oracle’s
instructions for installing this feature.
• You need apply any schema changes only once for RAC regardless of the number of nodes
accessing the database.
To support RAC, you must manually configure the property
com.dorado.oracle.rac.connect.url listed in the owdatabase.properties file, in
addition to all existing oracle properties. See
Oracle RAC installation.properties File on page 175
for information about that file.
The property
com.dorado.oracle.rac.connect.url defines a database connection URL
used by the JBoss connection pool at application server startup. This property defines the following
configurable attributes:
Address List—A list of database servers in the RAC cluster.
Failover—On/Off
Load Balancing—On/Off
Dedicated Server—On/Off
Service Name—This is a Global Database Name and not a SID.
The Oracle 10g jdbc jar is included in the Oware classpath by default (in oware/lib3rd ). This is
backward compatible with Oracle 9i. Modify the RAC property by overriding it in the
owareapps/installprops/installed.properties file. Make sure the URL is well-
formed, with the brackets that appear in the sample property in the
oware/lib/
owdatabase.property
file. See Software Requirements on page 15 for more about the JDBC
driver.