How to recover data which is dropped by mistake
Posted: Tue Jan 02, 2018 11:48 am
Hi,
I am new to Vertica.
As a DBA, I have incorporated script to enable retention of partitions using Unix script. It worked fine till end of 2017. In the NewYear, it went wrong. Unfortunately, it picked up wrong date and dropped all partitions prior to that date.
Its been a day now, not able to find option to recover the dropped data.
Could some one let me know how to proceed in recovering the dropped data.
Regards
Prasad
I am new to Vertica.
As a DBA, I have incorporated script to enable retention of partitions using Unix script. It worked fine till end of 2017. In the NewYear, it went wrong. Unfortunately, it picked up wrong date and dropped all partitions prior to that date.
Its been a day now, not able to find option to recover the dropped data.
Could some one let me know how to proceed in recovering the dropped data.
Regards
Prasad