Scheduling a full database backup on remote server

Last Updated : Apr 26, 2021 |
Prolog information
You can schedule a full database backup on a remote server based on your choice of time, such as daily, weekly, monthly, and yearly. You can also choose the hour for the backup.
Before you begin
You must configure the remote server. See the Managing Remote Server connection settings section in this document.
  1. Log in to the Cluster Control Manager (CCM) console as the customer user.
  2. Switch to being the root user by entering the command su.
  3. To run the Analytics Administration script, use the following command:
    ADDITIONAL INFORMATION:
    ccm release orca analytics
  4. Select Database by pressing the corresponding number.
  5. To select the Database backup option, enter the corresponding number.
  6. To run a remote backup, enter the corresponding number to select the Remote Backups option.
  7. If the remote server is not configured, then enter the corresponding number and configure the remote server to select Update Remote Server connection settings.
  8. To select the Update/Create a schedule for Remote Backups option, enter the corresponding number.
  9. In the Proceed with remote scheduled backup update field, type y.
    ADDITIONAL INFORMATION:
    Entering n cancels the operation.
  10. In the How often should the backup be executed [daily/weekly/monthly/yearly] field, type the required duration.
    ADDITIONAL INFORMATION:
    Depending on your selection, follow the next steps:
  11. For daily backups:
  12. In the How often should the backup be executed [daily/weekly/monthly/yearly] field, type daily and press Enter.
    ADDITIONAL INFORMATION:
    The value is case-sensitive.
  13. To select the time in hour for the backup, in the What hour of the day [0–23] field, type the time and press Enter.
    ADDITIONAL INFORMATION:
    The time selection is in 24–hour format. For example, if you type 2, then the backup happens at 2 am.
  14. To select the time in minute for the backup, in the What minute of the hour [0–59] field, type the time and press Enter.
    ADDITIONAL INFORMATION:
    For example, if you type 2, then the backup happens at 2 minutes past 2 am.
  15. Return to the previous page by entering b.
  16. Quit the current page by entering q.
  17. Return to the main menu by entering m.
  18. For weekly backups:
  19. In the How often should the backup be executed [daily/weekly/monthly/yearly] field, type weekly and press Enter.
    ADDITIONAL INFORMATION:
    The value is case-sensitive.
  20. To select the day of the week for the backup, in the What day of the week (Sunday to Saturday) [0–6] field, type the number of the day and press Enter.
    ADDITIONAL INFORMATION:
    For example, to select Monday, type 1.
  21. To select the time in hour for the backup, in the What hour of the day [0–23] field, type the time and press Enter.
    ADDITIONAL INFORMATION:
    The time selection is in 24-hour format. For example, if you type 2, then the backup happens at 2 am.
  22. To select the time in minute for the backup, in the What minute of the hour field, type the time and press Enter.
    ADDITIONAL INFORMATION:
    For example, if you type 2, then the backup happens at 2 minutes past 2 am.
  23. Return to the previous page by entering b.
  24. Quit the current page by entering q.
  25. Return to the main menu by entering m.
  26. For monthly backups:
  27. In the How often should the backup be executed [daily/weekly/monthly/yearly] field, type monthly and press Enter.
    ADDITIONAL INFORMATION:
    The value is case-sensitive.
  28. To select the day for the backup, in the What day of the month [1–31] field, type the number of the day and press Enter.
    ADDITIONAL INFORMATION:
    For example, to select 2nd day of every month, type 2
  29. To select the time in hour for the backup, in the What hour of the day field, type the time and press Enter.
    ADDITIONAL INFORMATION:
    The time selection is in 24-hour format. For example, if you type 2, then the backup happens at 2 am.
  30. To select the time in minute for the backup, in the What minute of the hour field, type the time and press Enter.
    ADDITIONAL INFORMATION:
    For example, if you type 2, then the backup happens at 2 minutes past 2 am.
  31. Return to the previous page by entering b.
  32. Quit the current page by entering q.
  33. Return to the main menu by entering m.
  34. For yearly backups:
  35. In the How often should the backup be executed [daily/weekly/monthly/yearly] field, type yearly and press Enter.
    ADDITIONAL INFORMATION:
    The value is case-sensitive.
  36. To select the month for the backup, in the What month of the year (January to December) [1–12] field, type the number corresponding to the month and press Enter.
    ADDITIONAL INFORMATION:
    For example, for selecting October, type 10.
  37. To select the day for the backup, in the What day of the month [1–31] field, type the number of the day and press Enter.
    ADDITIONAL INFORMATION:
    For example, to select 2nd day of every month, type 2
  38. To select the time in hour for the backup, in the What hour of the day field, type the time and press Enter.
    ADDITIONAL INFORMATION:
    The time selection is in 24-hour format. For example, if you type 2, then the backup happens at 2 am.
  39. To select the time in minute for the backup, in the What minute of the hour field, type the time and press Enter.
    ADDITIONAL INFORMATION:
    For example, if you type 2, then the backup happens at 2 minutes past 2 am.
  40. Return to the previous page by entering b.
  41. Quit the current page by entering q.
  42. Return to the main menu by entering m.