Backing Up and Restoring Database Audit Logs

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.