Here are some ideas on how to create an OBIEE 11g backup environment, in case of a disaster.

Full Server Backup

One option is to backup the entire server. For instance, you can perform:

  •  a complete backup in a quiet period of activity (normally Sunday)
  • and a incremental backup for the rest of the week

Clearly, there are a multitude of cons in this approach such as the ever increasing need for storage space, the cost of storage, and the larger length of time required to complete a full server backup

Precision Backup

Oracle’s recommended approach is to take more of a surgical backup approach, taking only the core elements of the environment into consideration for the backup plan. Precision backups have much fewer cons than the full server backup strategy. Though more effort is involved upfront the maintenance of this type of backup plan is substantially less of a headache.

Configuration Files:

ORACLE_INSTANCE/bifoundation/OracleBIApplication
ORACLE_INSTANCE/bifoundation/OracleBIClusterControllerComponent
ORACLE_INSTANCE/bifoundation/OracleBIJavaHostComponent
ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent
ORACLE_INSTANCE/bifoundation/OracleBISchedulerComponent
ORACLE_INSTANCE/bifoundation/OracleBIServerComponent
ORACLE_INSTANCE/bifoundation/OracleBIODBCComponent
ORACLE_INSTANCE/config/OracleBIApplication
ORACLE_INSTANCE/config/OracleBIClusterControllerComponent
ORACLE_INSTANCE/config/OracleBIJavaHostComponent
ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent
ORACLE_INSTANCE/config/OracleBISchedulerComponent
ORACLE_INSTANCE/config/OracleBIServerComponent
ORACLE_INSTANCE/config/OracleBIODBCComponent
ORACLE_INSTANCE/diagnostics/logs/OracleBIApplication
ORACLE_INSTANCE/diagnostics/logs/OracleBIClusterControllerComponent
ORACLE_INSTANCE/diagnostics/logs/OracleBIJavaHostComponent
ORACLE_INSTANCE/diagnostics/logs/OracleBIPresentationServicesComponent
ORACLE_INSTANCE/diagnostics/logs/OracleBISchedulerComponent
ORACLE_INSTANCE/diagnostics/logs/OracleBIServerComponent
ORACLE_INSTANCE/diagnostics/logs/OracleBIODBCComponent

In addition, the following files in a file-based repository:

ORACLE_INSTANCE/bifoundation/OracleBIServerComponent/comp_instance name/repository/*.rpd
ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/comp_instance name/catalog/catalog-name

Database Repository Dependencies:

• UserStats, SCHEDULER, and BIPUBLISHER schemas

Backup Recommendations:

• Back up the Middleware home, the domain home, and Oracle instance containing the Oracle BI EE components.
• Back up the database containing the Oracle BI EE schemas

Maintenance Mode

• Oracle recommends a “Maintenance Mode” in the backup plan. This alerts users that a backup is occurring.
• Oracle recommends locking the Oracle BI Presentation (Web) Catalog before conducting a backup so that the RPD and Presentation (Web) Catalog stay in sync. That can be conducted with the following syntax:

o ./runcat.sh -cmd maintenanceMode -on -online BIP_URL
o -login username -pwd password

Resources

http://download.oracle.com/docs/cd/E21764_01/core.1111/e10105/br_intro.htm#ASADM11238

Have more questions? We can help: