08-07-2016 07:09 PM
I need some help to understand systemDB, dataDB recovery procedures for the discussion with our operatons team (Oracle DBA).
Use case:
- MEGA users dispatched some bulk updates in a repository which shouldn´t have been done and want to rollback to dataDB content from 2 days ago
Required action:
- restore dataDB only?
- restore dataDB + systemDB?
Can you help or point me to the correct document
--------------------
HOPEX V1R3CP11
Solved! Go to Solution.
11-07-2016 08:42 AM
Hello Jerrome,
many thanks for the clear instruction and the document. That was exactly what I was looking for.
Best regards
Kai
08-07-2016 07:41 PM
Hello KElsner
It is recommended to restore both systemdb and data repositories
Otherwise there can be mismatches.
If data is backed up in Oracle, you should be able to restore the corresponding schemas in Oracle
Then you can create a new environment with the option 'Restore'
Pay attention to keep the same name for environment (this inf
ormation is saved in a table and checked).
The reference document is RDBMS Repository Installation Guide HOPEX V1R2-V1R3 EN
http://community.mega.com/t5/HOPEX-V1R2-V1R3/HOPEX-V1R2-V1R3-Deployment-amp-Upgrade/ta-p/8059
See section 'Restoring a Mega environment from formatted data'