OBIEE Online Training

Thursday, May 10, 2012

Auto Backup OBIEE (RPD,Catalog, Config. etc)

Hi,

Create batch file (bi_auto_backup.bat) and save this file schedule it via windows scheduler/SQL etc (this script will take copy of your rpd (full root folder , catalog, all bi required config files) then save it system date wise separate folder.

@ECHO OFF
REM ****************************************************************
REM File name  : BI_Backup_Daily.bat
REM Author  : Rasavelu Devarasu
REM Created on  : 14 Mar 2013
REM Last Modified on : 14 Mar 2013
REM Description  : Autobackup Daily basis for OBIEE Application into the local computer.
REM Change History : Update autofetech date command
REM Modified By  : Devarasu Rasavelu
REM Modified on  : 14 Mar 2013
REM Change History : Amended the path as in Production.
REM ****************************************************************
@echo offecho Backing up Repository files…
set curr_date=%DATE:~10,4%-%DATE:~4,2%-%DATE:~7,2%
echo %curr_date%"
echo offecho Backing up Repository files…
if not exist "%USERPROFILE%\My Documents\backup\%curr_date%_backup\repository" mkdir "%USERPROFILE%\My Documents\backup\%curr_date%_backup\repository"
xcopy /s/Y/Q E:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository "%USERPROFILE%\My Documents\backup\%curr_date%_backup\repository"
echo Backing up web catalog.Please wait….
if not exist "%USERPROFILE%\My Documents\backup\%curr_date%_backup\GPC" mkdir "%USERPROFILE%\My Documents\backup\%curr_date%_backup\GPC"
xcopy /s/Y/Q E:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\GPC "%USERPROFILE%\My Documents\backup\%curr_date%_backup\GPC"
echo Backing up Configuration files…
copy /Y E:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\config.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
echo Backing up User Roles Configuration files…
copy /Y E:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\fmwconfig\jps-config.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\user_projects\domains\bifoundation_domain\config\fmwconfig\system-jazn-data.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
echo Backing up User Configuration files…
copy /Y E:\Oracle\Middleware\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1\NQSConfig.INI "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1\DBFeatures.INI "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\web_instanceconfig.xml
copy /Y E:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\credentialstore.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\instances\instance1\config\OracleBISchedulerComponent\coreapplication_obisch1\instanceconfig.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\scheduler_instanceconfig.xml
copy /Y E:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\Configuration\xmlp-server-config.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\Security\principals.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\Security\security.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\clients\bipublisher\repository\Admin\DataSource\datasources.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\bifoundation\web\msgdb\l_en\messages\logonmessages.xml "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\portal\portallogo.gif "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\b_mozilla_4\bg_banner.jpg "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
copy /Y E:\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\sk_blafp\answers\answerslogo.gif "%USERPROFILE%\My Documents\backup\%curr_date%_backup\
echo Backup Complete!
@pause


Similarly 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

No comments:

Post a Comment