XMLWordPrintable

    Details

    • Type: Explanation
    • Status: Published
    • Affects Version/s: EXASolution 4.2.10
    • Fix Version/s: None
    • Component/s: EXAStorage
    • Labels:
      None
    • Explanation:
      Hide

      Backup stages

      The process of backup creation consists of several steps

      1. Protect
        During backup creation all the required reference backups will be protected against removal, e.g. during creation of a level 1 backup, the corresponding level 0 backup cannot be removed.
      2. Write
        The actual creation of a new backup.
      3. Validate
        Once the backup is fully written, it will be validated.
      4. Unprotect
        After that, the protection of the current backup and of all the corresponding reference backups will be released.
      5. Clean-up
        Expired backups will be removed, even the newly created backup if the expire time applies.
        This is a new step introduced with EXASolution 4.2.10 (see also EXASOL-1340).
        Please note, that this operation can take a considerable time, especially if there is a large number of expired backups in the system. Unfortunately, there is no way to predict the duration.

      After the successful clean up, the backup cycle will be reported as finished.
      Please note that during the whole backup procedure (including the clean up step), the database cannot be shut down. If another backup is scheduled and due while the backup run is in progress, it will be queued and executed directly thereafter.

      Status information

      EXAoperation

      Progress is reported appropriate EXAoperation log services.

      Timestamp Priority Service Message
      2014-06-16 09:30:01.650358 NOTICE exa_db1 Backup started.
      2014-06-16 09:31:10.218319 NOTICE exa_db1 Remove of expired backups started.
      2014-06-16 09:54:59.587537 NOTICE exa_db1 Remove of expired backups finished.
      2014-06-16 09:55:00.204568 NOTICE exa_db1 Backup finished.
      EXASolution

      The system table SYS.EXA_SYSTEM_EVENTS records the start and stop events but it does not present the single backup steps.

      MEASURE_TIME EVENT_TYPE DBMS_VERSION NODES
      2014-06-16 22:30:01.650358 BACKUP_START 4.2.10 4
      2014-06-16 22:55:00.204568 BACKUP_END 4.2.10 4
      Show
      Backup stages The process of backup creation consists of several steps Protect During backup creation all the required reference backups will be protected against removal, e.g. during creation of a level 1 backup, the corresponding level 0 backup cannot be removed. Write The actual creation of a new backup. Validate Once the backup is fully written, it will be validated. Unprotect After that, the protection of the current backup and of all the corresponding reference backups will be released. Clean-up Expired backups will be removed, even the newly created backup if the expire time applies. This is a new step introduced with EXASolution 4.2.10 (see also EXASOL-1340 ). Please note, that this operation can take a considerable time, especially if there is a large number of expired backups in the system. Unfortunately, there is no way to predict the duration. After the successful clean up, the backup cycle will be reported as finished. Please note that during the whole backup procedure (including the clean up step), the database cannot be shut down. If another backup is scheduled and due while the backup run is in progress, it will be queued and executed directly thereafter. Status information EXAoperation Progress is reported appropriate EXAoperation log services. Timestamp Priority Service Message 2014-06-16 09:30:01.650358 NOTICE exa_db1 Backup started. 2014-06-16 09:31:10.218319 NOTICE exa_db1 Remove of expired backups started. 2014-06-16 09:54:59.587537 NOTICE exa_db1 Remove of expired backups finished. 2014-06-16 09:55:00.204568 NOTICE exa_db1 Backup finished. EXASolution The system table SYS.EXA_SYSTEM_EVENTS records the start and stop events but it does not present the single backup steps. MEASURE_TIME EVENT_TYPE DBMS_VERSION NODES 2014-06-16 22:30:01.650358 BACKUP_START 4.2.10 4 2014-06-16 22:55:00.204568 BACKUP_END 4.2.10 4
    • Category 1:
      Cluster Administration - Backup

      Attachments

        Issue Links

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: