Backup OBIEE (RPD, Catalog, Configuration, Roles etc) Daily Basis

Hi,


Steps  to OBIEE11g archive catalog manager on a regular basis create bat like run.bat inthat batch file just include below script


@echo offecho Backing up Repository files…
if not exist "E:\2012\OBIEE_Auto_Run_backup" mkdir "E:\2012\OBIEE_Auto_Run_backup"
copy /Y D:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository\Test_BI0003.rpd E:\2012\OBIEE_Auto_Run_backup
echo Backing up web catalog.Please wait….
if not exist "E:\2012\OBIEE_Auto_Run_backup\" mkdir "E:\2012\OBIEE_Auto_Run_backup\"
xcopy /s/Y/Q D:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\Test E:\2012\OBIEE_Auto_Run_backup\Test
echo Backing up Configuration files…
copy /Y D:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\config.xml E:\2012\OBIEE_Auto_Run_backup
echo Backing up User Roles Configuration files…



copy /Y D:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\fmwconfig\jps-config.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\fmwconfig\system-jazn-data.xml E:\2012\OBIEE_Auto_Run_backup
echo Backing up User Configuration files…
copy /Y D:\Oracle\Middleware\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1\NQSConfig.INI E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1\DBFeatures.INI E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1
instanceconfig.xml E:\2012\OBIEE_Auto_Run_backup\web_instanceconfig.xml
copy /Y D:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\credentialstore.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\instances\instance1\config\OracleBISchedulerComponent\coreapplication_obisch1\instanceconfig.xml E:\2012\OBIEE_Auto_Run_backup\scheduler_instanceconfig.xml
copy /Y D:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\Configuration\xmlp-server-config.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\Security\principals.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\Security\security.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\DataSource\datasources.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\bifoundation\web\msgdb\l_en\messages\logonmessages.xml E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\portal\portallogo.gif E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\b_mozilla_4\bg_banner.jpg E:\2012\OBIEE_Auto_Run_backup
copy /Y D:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\sk_blafp\answers\answerslogo.gif E:\2012\OBIEE_Auto_Run_backup
echo Backing up User COmmentary war file Please wait...
copy /Y C:\Users\gpc_1bank\Documents\WebApplication_V01\dist\WebApplication1_V01.war E:\2012\OBIEE_Auto_Run_backup
echo Backup Complete!
@pause

For OBIEE10g archive catalog manager on a regular basis create bat like run.bat inthat batch file just include below script
@echo off

echo Backing up Repository files…

if not exist “C:\OBIEE_Backup” mkdir “C:\OBIEE_Backup”

copy /Y C:\OracleBI\server\Repository\samplesales.rpd C:\OBIEE_Backup

echo Backing up Configuration files…

copy /Y C:\OracleBI\server\Config\NQSConfig.INI C:\OBIEE_Backup

copy /Y C:\OracleBI\server\Config\DBFeatures.INI C:\OBIEE_Backup

copy /Y C:\OracleBIData\web\config\instanceconfig.xml C:\OBIEE_Backup\web_instanceconfig.xml

copy /Y C:\OracleBIData\web\config\credentialstore.xml C:\OBIEE_Backup

copy /Y C:\OracleBIData\scheduler\config\instanceconfig.xml C:\OBIEE_Backup\scheduler_instanceconfig.xml

copy /Y C:\OracleBI\xmlp\XMLP\Admin\Configuration\xmlp-server-config.xml C:\OBIEE_Backup

copy /Y C:\OracleBI\xmlp\XMLP\Admin\Security\principals.xml C:\OBIEE_Backup

copy /Y C:\OracleBI\xmlp\XMLP\Admin\Security\security.xml C:\OBIEE_Backup

copy /Y C:\OracleBI\xmlp\XMLP\Admin\DataSource\datasources.xml C:\OBIEE_Backup

copy /Y C:\OracleBI\web\msgdb\l_en\messages\logonmessages.xml C:\OBIEE_Backup

copy /Y C:\OracleBI\web\app\res\s_oracle10\portal\portallogo.gif C:\OBIEE_Backup

copy /Y C:\OracleBI\web\app\res\s_oracle10\b_mozilla_4\bg_banner.jpg C:\OBIEE_Backup

copy /Y C:\OracleBI\web\app\res\sk_oracle10\answers\answerslogo.gif C:\OBIEE_Backup

echo Backing up web catalog.Please wait….

if not exist “C:\OBIEE_Backup\samplesales” mkdir “C:\OBIEE_Backup\samplesales”

xcopy /s/Y/Q C:\OracleBIData\web\catalog\samplesales C:\OBIEE_Backup\samplesales

echo Backup Complete!

@pause

2) step

by using this run.bat schedule it via SQL/Oracle/windows method based on your frequency like daily,monthly etc

Thanks
Deva