You can create a backup of a historical reporting database for storing your reports. This backup is required to restore the data later during troubleshooting or upgrades.
Note:
You must restart the mstr-srv pod after a successful restore of the historical metadata.
Historical reporting metadata backups are saved to the analyticsdb-node pods.
Procedure
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:
ccm release orca analytics
Select Historical Reporting by pressing the corresponding number.
To select the Backup Metadata option, enter the corresponding number.
To create a backup in the metadata node, select the Backup Metadata option by entering the corresponding number.
In the Proceed with historical reporting metadata backup option, enter y.
The CCM displays the message that the backup is successful with the details of the location of the backup folder.
Restart the mstr-srv pod after a successful restore of the historical metadata.
Return to the previous page by entering b.
Quit the current page by entering q.
Return to the main menu by entering m.
To export the backups to CCM, select the Export Backups option by entering the corresponding number.
In the Proceed with backup export option, enter y.
Entering n cancels the operation.
The CCM console displays the path to the location where the backup is exported.
Return to the previous page by entering b.
Quit the current page by entering q.
Return to the main menu by entering m.
To view the list of Historical Reporting metadata backups, select the List Backups option by entering the corresponding number.
Return to the previous page by entering b.
Quit the current page by entering q.
Return to the main menu by entering m.
To restore the historical metadata, select the Restore Metadata option by entering the corresponding number.
In the Proceed with Hstorical Reporting Metadata restore field, enter y.
Warning:
Restoring the data from the backup wipes out all the current data and replaces the content from the backup.
In the Specify the location of the backup file you want to restore field, type one of the following and press Enter.
Note:
The values are case-sensitive.
CCM: If the file is located in the CCM machine.
POD: If the file is located on the analyticsdb-node pods.
If you enter CCM, in the Enter the full path and file name of the backup file located on CCM field, type the required details and press Enter.
For example:/home/cust/historical_md_backups/full_backup_2020_01_31_15_38_01.bkp
If you enter POD, in the Enter the name of the backup file you wish to restore from field, type the name of the file and press Enter.
The back up is restored to historical reporting node.
