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.
