Understanding Actuate BIRT iHub architecture : Understanding BIRT iHub architecture : Managing the backup, recovery, and failover capabilities of the Encyclopedia volume database and data files
 
Managing the backup, recovery, and failover capabilities of the Encyclopedia volume database and data files
The iHub administrator uses third-party RDBMS tools to manage the backup, recovery, and failover capabilities of the system and Encyclopedia volume database. The iHub administrator uses standard operating system or other third‑party tools to manage the backup and recovery of the data files.
The third-party database schemas that contain iHub system and Encyclopedia volume metadata are critical components of BIRT iHub System. To guard against data loss, the database administrator must back up the Encyclopedia volume schemas and all related file data to ensure recoverability in the event of failure. For more information on backing an iHub installation, see Chapter 10, “Backing up an Encyclopedia volume,” later in this book.
In iHub and iServer Release 11, it is not necessary to back up the system schema, although future versions may require this operation to protect critical system metadata. The administrator can restore a corrupted or missing system schema using the System Data Store Administrator utility. For more information on this utility, see “Specifying System Data Store Administrator properties” in Chapter 11, “Working with BIRT iHub utilities,” later in this book.
An iHub system administrator must take all necessary precautions to ensure that a database is properly backed up and available to safeguard system and Encyclopedia volume metadata. Please consult Actuate Support at the time of installation if you have any questions about the backup, recovery, or failover procedures necessary to protect against the possibility of catastrophic failure.
In Actuate iHub, there is no concept of volume failover, since each node in a cluster can operate on all the volumes. Configuring system and Encyclopedia volume database failover is the responsibility of the third-party RDBMS administrator. The database administrator must use the facilities available in the RDBMS to configure this failover capability. Consult the third-party RDBMS documentation for detailed information on how to use native system tools to configure backup, recovery, and failover operations for the externally managed system and Encyclopedia volume database.
Documentation for a PostgreSQL RDBMS is available at:
http://www.postgresql.org/docs/8.4/static/release-8-4.html
Documentation for an Oracle RDBMS is available at:
http://www.oracle.com/technetwork/database/enterprise-edition/documentation/index.html
Documentation for Microsoft SQL Server RDBMS is available at:
http://msdn.microsoft.com/en-us/sqlserver/bb671149
Documentation for IBM DB2 RDBMS is available at:
https://www-304.ibm.com/support/docview.wss?uid=swg27009474