Backup and Recovery Recommendations for Oracle Business Intelligence

The following sections describe backup and recovery recommendations for Oracle Business Intelligence:

• Backup and Recovery Recommendations for Oracle BI Enterprise Edition
• Backup and Recovery Recommendations for Oracle Business Intelligence Publisher

16.5.8.1 Backup and Recovery Recommendations for Oracle BI Enterprise Edition

This section describes the Oracle BI Enterprise Edition data that must be backed up and restored.

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

The NQSConfig.INI configuration file points to the Repository Publishing Directory (RPD) name. The NQSConfig.INI file must exist in the following location:

ORACLE_INSTANCE/bifoundation/OracleBIServerComponent/comp_instance name/repository/

Database Repository Dependencies

MDS and BIPLATFORM schemas

Backup Recommendations

Back up the Middleware home, the domain home, and the Oracle instance containing the Oracle BI EE components. On Windows, export Oracle BI EE Registry entries, as described in Section 17.3.3.

Back up the database containing the Oracle BI EE schemas.

Note:

Before you perform a backup, you must lock the Oracle BI Presentation Catalogs so that the catalog and RPD remain synchronized. Run the following script:

ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager/runcat.sh

Use the following command:

./runcat.sh -cmd maintenanceMode -on -online BIP_URL

     -login username -pwd password

After the backup is complete, turn off maintenance mode using the runcat command. For information on this command, see the help:

./runcat.sh -cmd maintenanceMode -help

Recovery Recommendations

Depending on the extent of the failure, recover the Middleware home, the domain, and the Oracle instance containing the Oracle BI EE components. On Windows, import Oracle BI EE Registry entries.

Recover the database to the most recent point in time, if needed.

For the steps to recover Oracle BI EE, see Section 18.2.7.10. For the steps specific to recovering from loss of host, see Section 18.3.4.9.

16.5.8.2 Backup and Recovery Recommendations for Oracle Business Intelligence Publisher

This section describes the Oracle Business Intelligence Publisher data that must be backed up and restored.

Configuration Files

Configuration files are located in the Middleware home, the domain home, and the Oracle Business Intelligence Publisher repository.

Database Repository Dependencies

BIPLATFORM schema

Backup Recommendations

Back up the Middleware home, the domain, and the BI Publisher repository.

The BI Publisher repository can be file-based or database-based.

Recovery Recommendations

Recover the Managed Server containing the Oracle BI Publisher component.

Recover the database to the most recent point in time, if needed.

For the steps to recover Oracle BI Publisher, see Section 18.2.7.11. For the steps specific to recovering from loss of host, see Section 18.3.4.10.