Skip to Content
author's profile photo Former Member
Former Member

BI Platform 4.2 Disaster Recovery setup

I am currently trying to setup our BusinessObjects BI Platform 4.2 Disaster Recovery environment. I could successfully:


- restored the Repository SQL Server database to a DR server

- copied the FileStore folder from PD to DR

- completed the steps provided in the SAP note: 1275068 and reset SIA.


The method in the above sap note involves resetting the services that run on the report server (request port changes, creating additional AdaptiveJobServer, Creation of server groups, other miscellaneous setting, etc.). Is there a way to restore the repository database and filestore to a DR server without wiping out all these settings?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Aug 22, 2016 at 04:11 PM

    Yes. Once you have everything set up on the DR server the first time do the following:

    1. Run the Central Configuration Manager (CCM).

    2. In the CCM there is an option to backup the servers. Use this to backup the server configuration to a .biar file. Put the .biar file where it will be available if you need to use the DR server.

    3. The next time you have to use the DR server, restore the database and filestore. Then use the CCM to restore the server configuration from the .biar file. This will overwrite all of the servers that were set up in the original system with the ones from the .biar file. If you had their properties all configured prior to the backup, those will now be configured without having to do it manually.

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Dell Stinnett-Christy

      Thanks Dell,

      I tried restoring the biar file, but I am concerned about how much it “imports” (Imported 463 infoobjects). Then the restore operation fails and the server configuration is not updated.

      I have a some questions about what it stores in the repository database. Is the server configuration (request port settings, etc.) held in cms_infoobjects7 where parentid=16 or parentid=59? Could I just extract that data and re-insert those rows when I failover to the DR server?

      Thanks,

      Charly

  • Posted on Aug 22, 2016 at 04:35 PM

    Charly,

    Depending on what options you have installed you should keep back up of several directories:

    • If AD Auth integrated - D:\SAP BusinessObjects\tomcat\webapps\BOE\WEB-INF\config\
      • D:\SAP BusinessObjects\tomcat\conf
    • D:\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\FileStore
    • D:\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Data\Polestar
    • D:\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Data\TrendingDB


    See detail step-by-step on how to do restore from restore


    How to Restore BI4 from FRS & CMS Backup

    Also keep in-mind also to back-up you server configuration from CCM, see below screenshot.

    Regards,

    Ajay


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2016 at 10:26 AM

    Hi There,

    we use active - active setup so DR is just to restore the backup of DB and FRS.

    active - active setup use all servers so we haven't kept any server in sleep mode.

    Our BCP is based on scenario like what will happen if app server down, if BO server down, if load balance down, if DB is down, if File server is down, if network is down, if primary data centre is down...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.