You can restore an incremental database backup using the database restore option.
Note:
Do not restore a database backup of previous Avaya Analytics™ release version.
Before you begin
Restore needs to be done within a maintenance window.
Other:
Restore deletes all the current data in the database and restores the contents of the backup.
Stop all events coming to the Avaya Analytics™ database from Avaya Oceana®. For steps to stop the events, see the relevant section in this document.
Check your backup file permissions.
Log in to the Cluster Control Manager (CCM) console as the customer user.
Switch to being the root user by entering the command su.
To run the Analytics Administration script, use the following command:
ADDITIONAL INFORMATION:
ccm release orca analytics
Select Database by pressing the corresponding number.
To select the Database Restore option, enter the corresponding number.
To select the Restore from an Incremental Backup option, enter the corresponding number.
In the Proceed to backup restore field, type y.
ADDITIONAL INFORMATION:
Entering n cancels the operation. On entering y, the following warning message is displayed:
Restoring Analytics Database from backup. Note that this will wipe all data currently on the database and replace with the contents of the backup.
In the Confirm you want to continue field, type y.
STEP RESULT:
The list of full and incremental backups is displayed. For example,
Backup # 1 - Full backup at 2022-06-02 11:08:38
Backup # 2 - Incremental backup at 2022-06-02 14:42:18
Enter the backup number that you want to restore in From the backup you want to restore, please enter the Backup # (e.g. 1): field.
STEP RESULT:
The script restores the latest database backup to the desired location.
Note:
If you see the following warning message in the logs, you can ignore it:
WARNING: archiving write-ahead log file "0000000x.history" failed too many times, will try again later
After a successful restore, run a full base backup.
ADDITIONAL INFORMATION:
Note:
This step is mandatory after a successful restore.
The first full backup after a restore shows the following error in the logs, you can ignore it:
[WARN: a timeline switch has occurred since the 20220615-124126F_20220616-144614I backup, enabling delta checksum\n HINT: this is normal after restoring from backup or promoting a standby.
