Monday, July 1, 2013

SAP BO Disaster Recovery in clustered enviroment

Issue
  • Take a backup of the Production System's database and then create a new ODBC connection pointing to this database.
  • On a new server that has SAP BusinessObjects XI 3.1 installed, take the existing Server Intelligence Agent (SIA) and then point the database to the prod backup.
  • Start up the SIA. 
  • In the Central Management Console (CMC) for your DR system, you will now see SIA nodes for the Production System. 
  • In the CMC, you will now see the new SIA that you added. 
Cause
  • The backup of the Central Management Server (CMS) repository contains remote node information for the existing database. 
  • Even though the CMS is using a separate physical database, the remote nodes contained within the metadata will connect to each other and show up in the CMC. 
  • They will link each other when the SIA is started on the DR system. 

Solution

  • The goal of these steps is to prevent the DR system from connecting to the Prod system. As an added precaution, you can create loop backs in your local hosts file that will return 127.0.0.1 when Production SIA nodes are referenced. 
  • Take a backup of the Production System's database and then create a new ODBC connection pointing to this database. 
  • On a new server that has SAP BusinessObjects XI 3.1 installed, create a new SIA and point it to the prod backup. 
  • Open the Central Configuration Manager (CCM), go to the properties of the newly created SIA. 
  • Click on Startup and you should see remote CMS nodes from your production environment. Remove these remote nodes. 
  • Start up the SIA. 
  • In the Central Management Console (CMC) for your DR system, you will now see SIA nodes for the Production System, you will now have to remove these. 
  • In the CCM, create a new SIA with exactly the same SIA name for each of the SIA nodes from your production environment. 
  • Once the SIA is created, click delete and then delete it from this DR system. 
  • Repeat this until all the production nodes are cleaned up. You will be left with a system that only has DR servers on it now. 
Hope you find this useful.Cheers,
Umang Patel
+919979084870
SAP BO BI Solution Architect/Consultant

1 comment:

  1. Hi Manisha,

    Thanks for your feedback.

    Still Lot more thing to come up. Stay connected.

    Regards,
    Umang Patel.
    SAP BO BI Solution Architect/Consultant

    ReplyDelete