Restore Vertica Server

Moderator: NorbertKrupa

nafdb
Newbie
Newbie
Posts: 3
Joined: Thu Jan 30, 2014 6:52 pm

Restore Vertica Server

Post by nafdb » Mon Feb 24, 2014 2:10 pm

Dear Members of List,

My Server Vertica are Die and i need to restore my backup in new machine but this message are display "Topology changed after backup; cannot restore."

Can Anybody help me?

Thanks

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Restore Vertica Server

Post by NorbertKrupa » Mon Feb 24, 2014 2:17 pm

Please try reading the documentation
Checkout vertica.tips for more Vertica resources.

nafdb
Newbie
Newbie
Posts: 3
Joined: Thu Jan 30, 2014 6:52 pm

Re: Restore Vertica Server

Post by nafdb » Mon Feb 24, 2014 2:20 pm

I do but nothing help me.

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Restore Vertica Server

Post by NorbertKrupa » Mon Feb 24, 2014 2:22 pm

You cannot restore an object-level backup after removing nodes, altering node names, or changing IP addresses.
Checkout vertica.tips for more Vertica resources.

nafdb
Newbie
Newbie
Posts: 3
Joined: Thu Jan 30, 2014 6:52 pm

Re: Restore Vertica Server

Post by nafdb » Mon Feb 24, 2014 2:37 pm

It's impossivel to recovery my data?

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

Re: Restore Vertica Server

Post by id10t » Mon Feb 24, 2014 2:56 pm

Hi!

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

Bopanna
Newbie
Newbie
Posts: 1
Joined: Fri Apr 17, 2015 10:57 am
Location: Bangalore

Re: Restore Vertica Server

Post by Bopanna » Fri Apr 17, 2015 11:15 am

Is there a way to update the system tables in Vertica 6.1.3?
ex: Select * from nodes;
gives an IP address that needs to be changed to a different one.
May I know the file in "/vertica/data/Vertica_DB/V_Catalog" which is read by the system table "v_catalog.nodes" while I issue the above command.

To give a quick background of what succeeded in doing so far:

It's our development DB (x.x.x.x) IP into which I have restored a Production backup from server (y.y.y.y) IP successfully without any issues.
The development DB is UP and running but on querying " v_catalog.nodes" system table it returns (y.y.y.y) instead of (x.x.x.x).
I guess we need to update the IP address in some file in V_Catalog folder.
####################################################################
dbadmin=> select * from nodes;
node_name | node_id | node_state | node_address | export_address | catalog_path | is_ephemeral
------------------+-------------------+------------+---------------+----------------+-------------------------------------------------------------------------------+--------------
v_samdb_node0001 | 45035996273704980 | UP | y.y.y.y | y.y.y.y. | /vertica/data/Vertica_DB/V_Catalog/DB/v_db_node0001_catalog/Catalog | f
(1 row)


[dbadmin@DEV-VERT01 config]$ /opt/vertica/bin/admintools -t view_cluster
DB | Host | State
-------+------+-------
DEVDB | ALL | UP


[dbadmin@DEV-VERT01 config]$ /opt/vertica/bin/admintools -t node_map
DATABASE | NODENAME | HOSTNAME
--------------------------------------------------------
DEVDB | v_db_node0001 | x.x.x.x

########################################################################################
Though restoring a Vertica DB between two different IPs is not supported. I Would like to know if anybody in this forum
have tried to do what I've done and managed to change the IP address in the " v_catalog.nodes" system table ....

Thanks,

Post Reply

Return to “Vertica Backup & Recovery”