Database Backup and Restore Alerts 

You might see the alerts described here when monitoring your Oracle database.

"[BRCONNECT]" below means that the alert is raised by the BRCONNECT database system check.

"[OPTIONAL]" below means that the alert can be turned off here and shown only in the Health monitoring tree. Such alerts always have corresponding Health alerts, as described in Database Health Alerts.

For more information, see Information on Oracle Database Alerts.

Archiving

Last successful archive log backup

Cause: The threshold for the number of days since the last successful backup of the offline redo log files, which includes BRARCHIVE return codes of 0 (successful) or 1 (successful but with warnings), has been exceeded.

Action: Run BRARCHIVE to back up the offline redo log files. For more information, see Command Options for BRARCHIVE.

 

Last brarchive run

Cause: The last BRARCHIVE run has an invalid status. This includes all BRARCHIVE runs, regardless of whether the offline redo log files were actually backed up or not. For example, this might include a run to only delete offline redo log files.

For more information, see LAST_ARCHIVE_FAILED in BRCONNECT Default Conditions for Database Operations.

Action: Correct the problem and repeat the BRARCHIVE run. For more information, see Command Options for BRARCHIVE.

 

Archiver destination full

Cause: The number of archive logs that will still fit into the archiver destination is below the preconfigured threshold.

Action: Either back up and delete offline redo log files with BRARCHIVE or add more space to the archiver destination to accommodate more archive logs.

 

Archiving off

Cause: Your database is running, but online redo logs are not being archived.

Action: Using BRSPACE, restart the database and change to archivelog mode.

 

Backup status

Last successful complete database backup

Cause: The threshold for the number of days since the last successful complete database backup, which includes BRBACKUP return codes of 0 (successful) or 1 (successful but with warnings), has been exceeded.

Action: Run BRBACKUP to perform a complete database backup. For more information, see Command Options for BRBACKUP.

 

Last brbackup run

Cause: The last BRBACKUP run has an invalid status. This includes all BRBACKUP runs, regardless of whether a complete database backup was performed. For example, this might include a run to perform an incremental backup.

For more information, see LAST_BACKUP_FAILED in BRCONNECT Default Conditions for Database Operations.

Action: Correct the problem and repeat the BRBACKUP run. For more information, see Command Options for BRBACKUP.

 

Tablespace in backup mode [BRCONNECT] [OPTIONAL]

Cause: The tablespaces named in the alert message are currently in backup mode, which reduces the performance of the SAP System.

Action: Confirm that no database backup is running, either with BRBACKUP or an external tool. Then reset the backup status to cancel the backup mode.

The non-standard equivalent to this optional alert is Tablespace in backup mode in Database Health Alerts.