Backing Up and Restoring Database Audit Logs

Updated on 2023-01-10 GMT+08:00

View PDF

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

Log in to the management console.
Select a region, click , and choose Security > Database Security Service. The Dashboard page is displayed.
In the navigation tree on the left, choose Settings.
In the Instance drop-down list, select the required instance and click the Backup and Restoration tab.

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

Click OK.

NOTE:

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.

NOTICE:

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

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