> Software > Protect > Databases > Technical Reference for Databases > Serverless Log Backups

Monitoring log backup history

Applies to: SQL, PostgreSQL, Oracle, Oracle RAC

You can monitor serverless transaction log dump operations and log backup history for an instance. The Log backup history view enables you to audit individual log dumps (separate from scheduled backup jobs), verify that logs are being dumped at the configured frequency, and quickly identify failures or errors.

Note

This feature does not support PostgreSQL cluster.

Prerequisites

  • Serverless log backup must be configured on the plan associated with the instance.

  • The Transaction log for databases schedule must be enabled.

Procedure

  1. From the Command Center navigation pane, go to Protect > Databases.

    The database Overview page appears.

  2. On the Instances tab, select an instance for which you want to monitor log backup history.

    The instance Overview page appears.

  3. Go to Log backup history tab.

  4. Select the time range you want to view (Last 24 hours or Last 7 days).

  5. View and monitor the serverless transaction log dump operations and log backup history.

Log backup history data columns for databases

The Log backup history tab can display different data and columns for each database.

PostgreSQL

  • Start time: The time when the log dump operation started.

  • End time: The time when the log dump operation finished.

  • Name: The name of the WAL archive file dumped to backup storage.

  • Status: Displays the status of the operation (for example, Completed or Failed).

  • Error description: The reason for failure, if the operation failed.

Oracle/Oracle RAC

  • Start time: The time when the log dump operation started.

  • End time: The time when the log dump operation finished.

  • Status: Displays the status of the operation (for example, Completed or Failed).

  • RMAN recovery time: The estimated time RMAN reports as required to recover the database to this log dump point.

  • Recovery SCN: Identifies the recovery point captured by this log dump.

  • Control file backup piece: Locate control-file level backups related to the operation.

  • Error description: The reason for failure, if the operation failed.

SQL

  • Start time: The time when the log dump operation started.

  • End time: The time when the log dump operation finished.

  • Database name: Displays the name of the database.

  • First LSN: The starting log sequence number of the backup.

  • Last LSN: The ending log sequence number of the backup.

  • Status: Displays the status of the operation (for example, Completed or Failed).

  • Error description: The reason for failure, if the operation failed.

×

Loading...