Help Center/ Database Security Service/ User Guide (Kuala Lumpur Region)/ Backing Up and Restoring Database Audit Logs
Updated on 2023-01-10 GMT+08:00

Backing Up and Restoring Database Audit Logs

Database audit logs can be backed up to OBS buckets to achieve high availability for disaster recovery. You can back up or restore database audit logs as required.

Prerequisites

  • You have applied for a database audit instance and the Status is Running.
  • Database audit has been enabled.

Precautions

  • Audit logs are backed up to OBS. Buckets are automatically created for you and billed per use.

Automatically Backing Up Database Audit Logs

  1. Log in to the management console.
  2. Select a region, click , and choose Security > Database Security Service. The Dashboard page is displayed.
  3. In the navigation tree on the left, choose Settings.
  4. In the Instance drop-down list, select the required instance and click the Backup and Restoration tab.
  5. Click Configure. In the displayed dialog box, set the parameters. For details about related parameters, see Table 1.

    Table 1 Parameters

    Parameter

    Description

    Example Value

    Automatic Backup

    Status of automatic backup

    • : enabled
    • : disabled

    Backup Period

    Automatic backup period. Its options are as follows:

    • Daily
    • Hourly

    Daily

    Started

    Start time of the backup. Click to configure.

    2020/01/14 20:27:08

  6. Click OK.

    After the automatic backup function is configured, new data in the database will be backed up one hour later. Then you can view the backup information.

Restoring Database Audit Logs

After backing up database audit logs, you can restore the audit logs as required.

Restoring logs is risky. Therefore before restoring logs, ensure that the backup log data is correct or complete.

  1. Log in to the management console.
  2. Select a region, click , and choose Security > Database Security Service. The Dashboard page is displayed.
  3. In the navigation tree on the left, choose Settings.
  4. In the Instance drop-down list, select the required instance and click the Backup and Restoration tab.
  5. In the Operation column of the backup log to be restored, click Restore Log.
  6. In the displayed dialog box, click OK.