Kbase 19591: SonicMQ: Files and Directories For Database Backup
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/8/2002 |
|
SUMMARY:
This solution applies to SonicMQ Versions 2000.x. 3.x, and 4.x,
and discusses the importance of backing up both the database and the
recovery logs.
EXPLANATION:
SonicMQ ships with an embedded Cloudscape database, a 100% pure Java
SQL database management system, as themessage broker's persistent
data store. SonicMQ can also use the third party databases ORACLE
8i and MS SQL Server.
The database is used to hold security information, configuration
information for multi-broker installations, persistent messages that
are not immediately deliverable, routing information, and other
information necessary for the reliable functioning of SonicMQ.
Backing up the database regularly helps prevent loss of that
information, ensuring the continued functioning of your SonicMQ
messaging application.
If you backup only the database, and restore that backup to disk, you
may see an exception and message similar to the following when
starting your message broker or server:
"[146] progress.message.broker.EStartupFailure: Mismatched log files
and database. Log files were initialized Sun Mar 12 16:04:33 CET
2000, database was initialized Fri Mar 10 17:07:55 CET 2000."
SOLUTION:
The exception above appears if the database and log files time stamps
don't match, because only the database was backed up.
Before doing a backup of the database(Cloudscape or a third party database) and files, you must shut down the SonicMQ broker.
The Cloudscape database resides in the SonicMQDB directory, which is
located immediately below the SonicMQ installion directory, as
specified by the database.home property in the file DefaultDB.ini.
To do a database backup, you should back up the whole SonicMQDB
directory structure.
In addition to backing up the database directory for the Cloudscape
database as described above, or doing a full database backup of your
third party database, a SonicMQ database backup must also include the
two recovery log files recoverylog1.bin and recoverylog2.bin, located
in the directory specified by the broker.ini parameter LOG_PATH, which
is set to <SonicMQ install dir>\log at installation.
References to Written Documentation:
SonicMQ Installation and Administration Guide
Online SonicMQ Product Information re Supported Platforms:
http://www.sonicsoftware.com/products/platforms.htm -
"Third Party Databases"