cancel
Showing results for 
Search instead for 
Did you mean: 

Read/Scan through HANA archive logs

reuscpe
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (0)