Object Level backup on 6.1

Moderator: NorbertKrupa

Post Reply
DGh
Newbie
Newbie
Posts: 14
Joined: Tue Oct 08, 2013 10:10 pm

Object Level backup on 6.1

Post by DGh » Wed Feb 12, 2014 6:10 am

Hi All,
I am trying to backup(and restore to test) a bunch of tables in vertica 6.1
It works for one set where i can successfully backup and recover(after dropping from same schema)the tables. I am running a three node cluster.
In this other case, however, it is throwing an error during restore. The strange thing is that the restore was working when i tested it before, so then i dropped the tables, created backup/restore for another set of tables(mutually exclusive list).
Now, when i try to restore the first set it throws an error:

All child processes terminated successfully.
select load_snapshot_prep('old_tables_02112014', true);
SQL command select load_snapshot_prep('old_tables_02112014', true); failed:
ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
HINT: Try restoring a cluster wide backup together

anyone seen this before? please help

thanks
DGh

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Object Level backup on 6.1

Post by id10t » Wed Feb 12, 2014 11:43 am

Hi!

[DELETED]
Last edited by id10t on Fri May 08, 2015 4:44 pm, edited 1 time in total.

DGh
Newbie
Newbie
Posts: 14
Joined: Tue Oct 08, 2013 10:10 pm

Re: Object Level backup on 6.1

Post by DGh » Wed Feb 12, 2014 11:36 pm

thanks !
that is some really good insight into the actual workings of vertica. I happened to have a backup of the table in another db and recreating the backup seemed to work(able to restore it successfully a few times)
is all the internal knowledge about vertica's workings documented somewhere or is it from your working and exploring with the tool that you figured it out?
thanks again for your help!

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Object Level backup on 6.1

Post by id10t » Thu Feb 13, 2014 6:49 am

Hi!

[DELETED]
Last edited by id10t on Fri May 08, 2015 4:43 pm, edited 1 time in total.

DGh
Newbie
Newbie
Posts: 14
Joined: Tue Oct 08, 2013 10:10 pm

Re: Object Level backup on 6.1

Post by DGh » Mon Feb 17, 2014 7:00 am

Thanks sKwa, that helps!

unnikpr123
Newbie
Newbie
Posts: 1
Joined: Thu Jul 21, 2016 11:48 am

Re: Object Level backup on 6.1

Post by unnikpr123 » Thu Jul 21, 2016 12:30 pm

HI Team,

I am facing some problem with my backup operation. I a,m getting Wollongong message while restore.

[dbadmin@c23 ~]$ /opt/vertica/bin/vbr.py --task restore --config schema.ini --archive=20160720_101752
Preparing...
Found Database port: 5433
Copying...
[==================================================] 100%
All child processes terminated successfully.
SQL command select load_snapshot_prep('schema', true); failed:
ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
HINT: Try restoring a cluster wide backup together
ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
HINT: Try restoring a cluster wide backup together
ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
HINT: Try restoring a cluster wide backup together
ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
HINT: Try restoring a cluster wide backup together

restore failed!
Retrying... #1



My procedure as follows,

1. Create a hardlink backup
2. move this to remote storage
3. Created another backup
4. restore the remote backup and try to restore.

I am using Vertica 7.0.1-4. please help me to resolve thtis.

Post Reply

Return to “Vertica Backup & Recovery”