Table of contents Restore Backups for Aternity 12.2 If Aternity is unavailable, the speed of recovery depends on the type of high availability deployment: Deployment Type of recovery Single site (cold recovery) If you backup and deploy high availability servers on a single site, you can restore Aternity within several hours. Standby site (hot recovery) If you deployed a standby site for hot recovery, you can expect to recover from a disaster within a few minutes. Tip There is a separate article on high availability and backing up. Before you begin You must already have a cloned database, as detailed in the Aternity backup strategy. If you also need to restore the Aternity Management Server, you must first recover the disk image which you backed up after the last upgrade, as detailed in the Aternity backup strategy. ProcedureStep 1 Use your live backup tool for the Oracle Database Server to convert the cloned server into the primary server. Clone the Aternity Oracle Database Server Step 2 To perform a hot recovery from to a standby site to start working in minutes: Deploy a standby site for hot recovery a Reroute the monitored devices to the load balancer of the Aggregation Servers on the standby site. b Update the DNS of the URL for accessing Aternity to the Aternity Management Server on the standby site. Step 3 To perform a cold (offline) recovery from a single-site deployment: Deploy high availability on a single site for offline recovery a On the computer which runs the Aternity Management Server, launch the Configuration Tool from the Start menu, by right-clicking it and selecting Run as administrator to start. When you create any Aternity server it adds the Configuration Tool. b Select Database Configuration to change the address of the Oracle Database Server. Configure the database address c Configure the Management Server to use the address of the clone server as the newOracle Database Server. d Restart the Management Server. Step 4 If you backed up the dashboards which users saved, you can restore them. a Access the Aternity Dashboard Server. b In a command prompt, navigate to the setup destination directory of the Dashboard Gateway. c Enter the following command: TableauUtility.cmd restoreSaved -inputFile pathname_of_backup_zip -site Tableau_site Restore a backed up package of saved dashboards Field Description -inputFile Enter the full pathname and file to the package containing the dashboards you backed up earlier. -site Enter the name of the Tableau site. You can find this in Aternity settings, by selecting the Gear Icon > Settings > Advanced Settings > tableau > site. Step 5 After you backup Vertica database, you can restore it. Important Remember to create pwdfile each time you run backup or restore commands and to DELETE it after that. Restore data from the latest backup file of Aternity Vertica Database Server or return to a specific point in time (to any of the two saved backups). Run this command as DBADMIN user. a Get the list of all backup files by running the following command: $ /opt/vertica/bin/vbr.py -t listbackup --config-file /home/dbadmin/backup_restore_full_local.ini For example, you get two backup snapshots: backup_snapshot_20190328_125703 backup_snapshot_20190328_125404 b Stop Vertica database using admintools. admintools -t stop_db -F -d <DB_NAME> -p '<DBA_USER_PSWD>' c Execute the following task to restore the latest backup snapshot. $ /opt/vertica/bin/vbr.py -t restore --config-file /home/dbadmin/backup_restore_full_local.ini d Alternatively, execute the following task to restore a specific backup snapshot (use its name in the command): $ /opt/vertica/bin/vbr.py -t restore --archive 20190328_125703 --config-file /home/dbadmin/backup_restore_full_local.ini Parent topic Choose your Backup Strategy for Aternity 12.2Related tasksPerform a Backup of Data Stored in Vertica Database ServerImplement a Standby Site for Disaster RecoveryPerform a Failover for Aternity 12.2 (Disaster Recovery)Changing Vertica IP AddressStop Aternity Vertica Database Server for MaintenanceRelated referenceImplement Redundancy and High Availability for Aternity 12.2 SavePDF Selected topic Selected topic and subtopics All content Related Links
Restore Backups for Aternity 12.2 If Aternity is unavailable, the speed of recovery depends on the type of high availability deployment: Deployment Type of recovery Single site (cold recovery) If you backup and deploy high availability servers on a single site, you can restore Aternity within several hours. Standby site (hot recovery) If you deployed a standby site for hot recovery, you can expect to recover from a disaster within a few minutes. Tip There is a separate article on high availability and backing up. Before you begin You must already have a cloned database, as detailed in the Aternity backup strategy. If you also need to restore the Aternity Management Server, you must first recover the disk image which you backed up after the last upgrade, as detailed in the Aternity backup strategy. ProcedureStep 1 Use your live backup tool for the Oracle Database Server to convert the cloned server into the primary server. Clone the Aternity Oracle Database Server Step 2 To perform a hot recovery from to a standby site to start working in minutes: Deploy a standby site for hot recovery a Reroute the monitored devices to the load balancer of the Aggregation Servers on the standby site. b Update the DNS of the URL for accessing Aternity to the Aternity Management Server on the standby site. Step 3 To perform a cold (offline) recovery from a single-site deployment: Deploy high availability on a single site for offline recovery a On the computer which runs the Aternity Management Server, launch the Configuration Tool from the Start menu, by right-clicking it and selecting Run as administrator to start. When you create any Aternity server it adds the Configuration Tool. b Select Database Configuration to change the address of the Oracle Database Server. Configure the database address c Configure the Management Server to use the address of the clone server as the newOracle Database Server. d Restart the Management Server. Step 4 If you backed up the dashboards which users saved, you can restore them. a Access the Aternity Dashboard Server. b In a command prompt, navigate to the setup destination directory of the Dashboard Gateway. c Enter the following command: TableauUtility.cmd restoreSaved -inputFile pathname_of_backup_zip -site Tableau_site Restore a backed up package of saved dashboards Field Description -inputFile Enter the full pathname and file to the package containing the dashboards you backed up earlier. -site Enter the name of the Tableau site. You can find this in Aternity settings, by selecting the Gear Icon > Settings > Advanced Settings > tableau > site. Step 5 After you backup Vertica database, you can restore it. Important Remember to create pwdfile each time you run backup or restore commands and to DELETE it after that. Restore data from the latest backup file of Aternity Vertica Database Server or return to a specific point in time (to any of the two saved backups). Run this command as DBADMIN user. a Get the list of all backup files by running the following command: $ /opt/vertica/bin/vbr.py -t listbackup --config-file /home/dbadmin/backup_restore_full_local.ini For example, you get two backup snapshots: backup_snapshot_20190328_125703 backup_snapshot_20190328_125404 b Stop Vertica database using admintools. admintools -t stop_db -F -d <DB_NAME> -p '<DBA_USER_PSWD>' c Execute the following task to restore the latest backup snapshot. $ /opt/vertica/bin/vbr.py -t restore --config-file /home/dbadmin/backup_restore_full_local.ini d Alternatively, execute the following task to restore a specific backup snapshot (use its name in the command): $ /opt/vertica/bin/vbr.py -t restore --archive 20190328_125703 --config-file /home/dbadmin/backup_restore_full_local.ini Parent topic Choose your Backup Strategy for Aternity 12.2Related tasksPerform a Backup of Data Stored in Vertica Database ServerImplement a Standby Site for Disaster RecoveryPerform a Failover for Aternity 12.2 (Disaster Recovery)Changing Vertica IP AddressStop Aternity Vertica Database Server for MaintenanceRelated referenceImplement Redundancy and High Availability for Aternity 12.2
Restore Backups for Aternity 12.2 If Aternity is unavailable, the speed of recovery depends on the type of high availability deployment: Deployment Type of recovery Single site (cold recovery) If you backup and deploy high availability servers on a single site, you can restore Aternity within several hours. Standby site (hot recovery) If you deployed a standby site for hot recovery, you can expect to recover from a disaster within a few minutes. Tip There is a separate article on high availability and backing up. Before you begin You must already have a cloned database, as detailed in the Aternity backup strategy. If you also need to restore the Aternity Management Server, you must first recover the disk image which you backed up after the last upgrade, as detailed in the Aternity backup strategy. ProcedureStep 1 Use your live backup tool for the Oracle Database Server to convert the cloned server into the primary server. Clone the Aternity Oracle Database Server Step 2 To perform a hot recovery from to a standby site to start working in minutes: Deploy a standby site for hot recovery a Reroute the monitored devices to the load balancer of the Aggregation Servers on the standby site. b Update the DNS of the URL for accessing Aternity to the Aternity Management Server on the standby site. Step 3 To perform a cold (offline) recovery from a single-site deployment: Deploy high availability on a single site for offline recovery a On the computer which runs the Aternity Management Server, launch the Configuration Tool from the Start menu, by right-clicking it and selecting Run as administrator to start. When you create any Aternity server it adds the Configuration Tool. b Select Database Configuration to change the address of the Oracle Database Server. Configure the database address c Configure the Management Server to use the address of the clone server as the newOracle Database Server. d Restart the Management Server. Step 4 If you backed up the dashboards which users saved, you can restore them. a Access the Aternity Dashboard Server. b In a command prompt, navigate to the setup destination directory of the Dashboard Gateway. c Enter the following command: TableauUtility.cmd restoreSaved -inputFile pathname_of_backup_zip -site Tableau_site Restore a backed up package of saved dashboards Field Description -inputFile Enter the full pathname and file to the package containing the dashboards you backed up earlier. -site Enter the name of the Tableau site. You can find this in Aternity settings, by selecting the Gear Icon > Settings > Advanced Settings > tableau > site. Step 5 After you backup Vertica database, you can restore it. Important Remember to create pwdfile each time you run backup or restore commands and to DELETE it after that. Restore data from the latest backup file of Aternity Vertica Database Server or return to a specific point in time (to any of the two saved backups). Run this command as DBADMIN user. a Get the list of all backup files by running the following command: $ /opt/vertica/bin/vbr.py -t listbackup --config-file /home/dbadmin/backup_restore_full_local.ini For example, you get two backup snapshots: backup_snapshot_20190328_125703 backup_snapshot_20190328_125404 b Stop Vertica database using admintools. admintools -t stop_db -F -d <DB_NAME> -p '<DBA_USER_PSWD>' c Execute the following task to restore the latest backup snapshot. $ /opt/vertica/bin/vbr.py -t restore --config-file /home/dbadmin/backup_restore_full_local.ini d Alternatively, execute the following task to restore a specific backup snapshot (use its name in the command): $ /opt/vertica/bin/vbr.py -t restore --archive 20190328_125703 --config-file /home/dbadmin/backup_restore_full_local.ini Parent topic Choose your Backup Strategy for Aternity 12.2Related tasksPerform a Backup of Data Stored in Vertica Database ServerImplement a Standby Site for Disaster RecoveryPerform a Failover for Aternity 12.2 (Disaster Recovery)Changing Vertica IP AddressStop Aternity Vertica Database Server for MaintenanceRelated referenceImplement Redundancy and High Availability for Aternity 12.2