BI Platform 4.2 Disaster Recovery setup

[Former Member]

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?

[DellSC · Accepted solution]

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

[Former Member · Accepted solution]

Hi Dell,

thanks for the quick reply. Would you please elaborate this line in you response?

"If you  had their properties all configured prior to the backup, those will now be configured without having to do it manually."

Which properties need to be configured prior to backup?

Thanks,

Charly

[DellSC · Accepted solution]

You would have to configure the ports, APS's etc. once on the DR machine to make sure that they're set up with the correct information before you do the backup.

-Dell

[Former Member · Accepted solution]

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

[former_member187093]

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...

[Former Member]

Thanks Shiv. Do you have any document on how you do active - active setup for DR?

Thanks,

Charly.

[CdnConnection]

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

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

Regards,

Ajay