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:
- Contact us using the form here, or call us at 952.947.9300.
- Drowning in data but parched for predictive insights? Arrange a free half-day analytics health check.
- Talk to our experts face to face at one of our upcoming industry events.