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
How to recover data which is dropped by mistake
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: How to recover data which is dropped by mistake
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
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.