SAP R/3 on Oracle 9i : check online backup

[Former Member]

Hi there,

I would like to integrate a check on the status of the online database backup (which runs on a daily basis) into a central monitoring system.

On way to do it is to check on OS level for the latest backup log file and read the status at the end of this file.

I wonder if it's also possible to check the backup status by doing a select on database table(s) and if so which table(s) should I query ?

Any help would be appreciated.

Kind regards,

Erik

[former_member204746 · Accepted solution]

you can have a look at table SDBAH. also, more details can be found in SDBAD.

[Former Member]

Hi,

You can implement CCMS alert configuration in your system to check the status of daily backup. For that use tcode RZ20->Monitoring>Oracle>Backup/restore>Backup status>Last succ. complete database backup or Last brbackup run

YOu also need to create a monitoring method in RZ21.

Please refer SAP Note 0176492 for details

Hope this helps you.

Thanks

Sushil