on 03-05-2019 7:02 AM
Dear Community,
Issue:
we had a major issue with data loss some days ago which we were able to fix but till now were not able to find the root cause.
For the analysis i want to search through different timeframes within the sap hana to find a point where the data within MARC was deleted.
Currently i do serveral PiT recoverys after each other to skip through the timeframe - this really takes ages (around 1-2h / restore)
Question:
a) is there any possiblity within hana to apply the redo logs and open the hana read-only - do a query and then continue rollforwarding the hana (another 5 mins)
b) is there a possiblity to scan through the archive logs for all sql queries that did delete / updates to a specific Table (MARC)
c) do you have any other idea to speed up my (database side) analysis
I went through most of the documentation and posts but havn´t found a good solution yet.
thanks in advance & beste regards
Peter
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.