How to recover data which is dropped by mistake

Moderator: NorbertKrupa

Post Reply
prasad7
Newbie
Newbie
Posts: 1
Joined: Tue Jan 02, 2018 11:11 am

How to recover data which is dropped by mistake

Post by prasad7 » 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

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1797
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: How to recover data which is dropped by mistake

Post by JimKnicely » Tue Jan 02, 2018 3:14 pm

Hi,

Dropping a partition is permanent action and there is no way to roll it back. Do you have a recent backup? You can restore the table from it.

See:
https://my.vertica.com/docs/9.0.x/HTML/ ... Backup.htm

In the future, maybe look into archiving partitions as opposed to dropping them? Archived partitioned can be restored.

See:
https://my.vertica.com/docs/9.0.x/HTML/ ... itions.htm
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica Database Administration”