This content has been marked as final. Show 5 replies
Oleksandr, I had encountered similar issue a while back. But the Oracle DBA was able to restore the DB (Shared Services) from the nightly network backup, the configuration, and metadata are all still intact from the backup, so we lost a day of activities in EPM11. The result worked well, we had the system restored.1 person found this helpful
Subsequently, we were exploring a DR (Disaster Recovery) environment to run mirror with production, but we got side-track with other priorities.
In addition, we also were exploring another idea to use the EPM 11 migration utility to ZIP up the production metadata weekly and archive for similiar issue. We did not get far on that either. Maybe someone else can share their best practices.
Years ago, Answer1, the consulting firm, came up with a tool that is slick using GUI to backup the Brio system, which now evolved into EPM11. I believe that Hyperion Splution never considered that tool, because it was TOO EASY to use and it was directly competiting with their consulting arms. I lost track of Answer1. But it was a great tool.
You can use LCM (life cycle management) which comes with hyperion foundation to export and import your user & group provisioning information, other artifacts like forms, grids, reports etc..
Sunil, he pointed it out that Shared Services DB sequence and index are messed up, if that is the case, LCM would not work.
Plus, the LCM can take a long time to extract the whole system, even in pieces.
thanks for replies. The best way were to restore db, of course.
@AlexLiu What was this GUI? What do you mean it has evoloved to EPM11.
Oleksandr, I do not remember the name of the software from 6-year ago right now. I have to look for the notes somewhere. The firm Answer1 is not around anymore.
How is your restore process going?