You can schedule an incremental database backup based on your choice of time. The default schedule of incremental backups is the following:
Base backup (full backup): Every Sunday at 04:00 am UTC
Incremental backup: Daily at 00:00 am UTC
Note:
The full backup and incremental backup cannot be scheduled at the same time. There must be adequate time in between them, as both backups cannot run at the same time.
It is recommended not to have more than 7 incremental backups before running a full backup. The recommended schedule is to have 1 full back up per week and 1 incremental backup daily.
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 Database by pressing the corresponding number.
To select the Database backup option, enter the corresponding number.
To select the Incremental Backups option, enter the corresponding number.
To select the Update schedule for Incremental Backups option, enter the corresponding number.
In the Proceed with incremental scheduled backup update field, type y.
Entering n cancels the operation.
The default schedules of incremental backup and base backup are listed.
In the Which Backup Schedule do you want to update [full/incremental]: field, type incremental or full, whichever backup you want to update.
Depending on your selection, follow the next steps:
For daily incremental backups, do the following:
To select the time in hour for the backup, type the time in the What hour of the day [0–23] field and press Enter.
The time selection is in 24–hour format. For example, if you type 2, the backup occurs at 2 a.m.
To select the time in minutes for the backup, type the time in the What minute of the hour [0–59] field and press Enter.
For example, if you type 2, the backup occurs at 2 minutes past 2 a.m.
Return to the previous page by entering b.
Quit the current page by entering q.
Return to the main menu by entering m.
For weekly full backups, do the following:
To select the day of the week for the backup, type the number of the day in the What day of the week (Sunday to Saturday) [0–6] field and press Enter.
For example, to select Monday, type 1.
To select the time in hour for the backup, type the time in the What hour of the day [0–23] field and press Enter.
The time selection is in 24–hour format. For example, if you type 2, the backup occurs at 2 a.m.
To select the time in minutes for the backup, type the time in the What minute of the hour [0–59] field and press Enter.
For example, if you type 2, the backup occurs at 2 minutes past 2 a.m.
Note:
You can create one weekly full backup schedule and one daily incremental backup schedule. The schedule can be updated but not deleted.
