This is the continuation of my previous blog ‘Business Objects Administration- Backup and Recovery’ and this blog is all about BI content recovery and failover recovery.
Content recovery
Consider a situation where you accidentally deleted a folder with business critical reports inside it. Some of the approaches to recover the reports and the folder.
Let us discuss each method one by one
1. Recover the contents from a BIAR backup
Recovering contents from BIAR file is straight forward and you should have a appropriate .biar file in hand before restore. We will be using Import wizard to restore the contents.
2. Recover the contents from another system
We can do the report migration from another environment. If you are in Production environment and you have deleted some reports, we can still recover the reports from QA server. Again we will be using Import wizard to restore the contents.
We need to ensure that the reports in both environments are in sync and no change is made to reports in Production environment alone (Proper SDLC cycle).
3. Restore CMS and FRS backup in a temporary server
Sometimes we may need to restore our Business Objects environment back to a given point in time but still keep the original system up and running.This will enable us to investigate and export selected BI content back to the original environment to avoid complete restore. We need to have temporary Business Objects environment setup, FRS and CMS database backups as prerequisites. The recovery sequence would be
·
Delete from CMS_INFOOBJECTS6 where ParentID=16
(to delete any reference to original Business Objects environment )
Disaster recovery
For disaster recovery we need to follow the approach which is similar to Approach-3 with some addition steps.
Delete from CMS_INFOOBJECTS6 where ObjectID= 4 (to delete cluster entries)
Delete from CMS_INFOOBJECTS6 where ParentID=59 (to delete SIA entries)
Delete from CMS_INFOOBJECTS6 where TypeID= 16 (to delete server entries)
Delete from CMS_INFOOBJECTS6 where TypeID= 17 (to delete server group entries)
Delete from CMS_INFOOBJECTS6 where ParentID=16 (to delete any BO service if remaining)
The old SIA is completely removed and your Business Objects DR Server is ready to use now.
Hope the blog is Interesting. Keep reading!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
10 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |