Example of Data Repository database restore using restore points (single node)
DX Performance Management 20.2.x
1.- Navigate to “Performance -> Operations Displays -> Interface Trends” in Dx NetOps Portal and take a screenshot for the last 7 days to verify later on whether the restore has been performed successfully:
Note there is data the 6th of September
2.- Stop the DCs services:
[[email protected] ~]# service dcmd stop
Redirecting to /bin/systemctl stop dcmd.service
[[email protected] ~]# service dcmd stop
Redirecting to /bin/systemctl stop dcmd.service
3.- Stop the DA services:
[[email protected] ~]# service dadaemon stop
Redirecting to /bin/systemctl stop dadaemon.service
4.- Log in to the DR server as the database administrator user (not as the root user) and run below command:
[[email protected] ~]# su dradmin
[[email protected] root]$
[[email protected] ~]# /opt/vertica/bin/adminTools
5.- Stop the Database (option 4 in the Menu):
6.- Exit from AdminTools:
7.- Check the available DR backups:
[[email protected] roo]$ /opt/vertica/bin/vbr.py --task listbackup --config-file /opt/vertica/config/backup_restore_full_local_TEST2.ini
backup backup_type epoch objects i_p e_p nodes(hosts) version filesystem_type
backup_snapshot_20210906_060004 full 5603494 v_drdata_node0001(10.74.161.134) v9.1.1-5 [Linux]
backup_snapshot_20210905_060004 full 5567781 v_drdata_node0001(10.74.161.134) v9.1.1-5 [Linux]
backup_snapshot_20210904_060004 full 5532452 v_drdata_node0001(10.74.161.134) v9.1.1-5 [Linux]
8.- Restore to the desired restore point by running below command (eg: 4th Sep backup):
/opt/vertica/bin/vbr.py --task restore --config-file <configuration_directory_path_filename> --archive <archive_name>
[[email protected] root]$ /opt/vertica/bin/vbr.py --task restore --config-file /opt/vertica/config/backup_restore_full_local_TEST2.ini --archive 20210904_060004
Starting full restore of database drdata.
Participating nodes: v_drdata_node0001.
Restoring from restore point: backup_snapshot_20210904_060004
Determining what data to restore from backup.
[==================================================] 100%
Approximate bytes to copy: 588956901 of 2302778891 total.
Syncing data from backup to cluster nodes.
[==================================================] 100%
Restoring catalog.
Restore complete!
9.- Restart the DR via AdminTools:
10.- Exit from AdminTools:
11.- Start the DA services:
[[email protected] ~]# service dadaemon start
Redirecting to /bin/systemctl start dadaemon.service
12.- Start the DCs services:
[[email protected] ~]# service dcmd stop
Redirecting to /bin/systemctl start dcmd.service
[[email protected] ~]# service dcmd stop
Redirecting to /bin/systemctl start dcmd.service
13.- Verify the backup has been performed successfully by navigating to “Performance -> Operations Displays -> Interface Trends” in Dx NetOps Portal and checking the data for the last 7 days.
Note there is data until the 4th of September