OBIEE backups

There will come a time when you drop that important report / dashboard or make that configuration change or edit joins in the repository and regret it as soon as you hit save.

A partial solution is to backup some of those important files and directories.

Backing up OBIEE.

So what would you need to recreate your OBI install.

1. Repository obviously
2. A catalog of dashboards and reports
3. The instanceconfig.xml file
4. The NQSConfig.ini file

This should be enough to get you back up and running. I have excluded settings like map server settings and usage tracking (now a bean setting in 11.1.1.6), though some of the settings are visible in the configuration files.

The following script assumes the following

• Your middleware home is D:\OBIMW
• Your backup destination is E:\BIbackups

The script creates a directory dynamically in the format YYYYMMDD and saves the backup to that location.

echo off
for /F "tokens=1-4 delims=/ " %%i in ('date /t') do (
set Day=%%i
set Month=%%j
set Year=%%k
)

echo making directory E:\BIbackups\%Year%%Month%%Day%
mkdir E:\BIbackups\%Year%%Month%%Day%
cd E:\BIbackups\%Year%%Month%%Day%
echo copying catalog.....
xcopy /e/y/h/c/k/q/i "D:\OBIMW\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog" E:\BIbackups\%Year%%Month%%Day%
echo copying repository....
mkdir E:\BIbackups\%Year%%Month%%Day%\repository
xcopy /e/y/h/c/k/q/i "D:\OBIMW\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository" E:\BIbackups\%Year%%Month%%Day%\repository
echo copying presentation services config....
mkdir E:\BIbackups\%Year%%Month%%Day%\presentationservicesconfig
xcopy /y/h/c/k/q/i "D:\OBIMW\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1" E:\BIbackups\%Year%%Month%%Day%\presentationservicesconfig
echo copying server config....
mkdir E:\BIbackups\%Year%%Month%%Day%\serverconfig
xcopy /y/h/c/k/q/i "D:\OBIMW\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1" E:\BIbackups\%Year%%Month%%Day%\serverconfig
echo on

I'll leave the housekeeping and archival and removal of expired backups to you.