Troubleshooting in the DBA Planning Calendar (Oracle) 

Use

An action planned using the DBA Planning Calendar might not execute correctly for some reason. Therefore, we recommend you to perform daily checks of at least the critical actions, such as database backups, using the alert monitor. This section describes how to troubleshoot when you find an error.

For more information on Oracle database administration with the SAP System, see SAP Database Guide: Oracle.

Procedure

...

       1.      Determine whether the background job was executed correctly by looking at the job log.

If no job log exists, the background job was probably not started. You can get more details using the job overview in transaction SM37 (note that the names of all jobs scheduled in the Calendar start with "DBA...") The job log also tells you whether an external program was started.

       2.      If you are sure that the background job ran successfully, look at the action log (if one is available).

       3.      If available, also display the detail log. This log contains details of the external program, and any errors that occurred during execution.

Common errors with tape drives include:

·         No tape inserted in the tape drive

·         The tape in the tape drive is write-protected.

·         The tape in the tape drive has not been initialized.

·         The tape drive contains the wrong tape.

·         An error has occurred in the tape drive

       4.      After you have fixed the error, choose Start immediately to restart the action manually. Make sure the action does not conflict with other planned actions.

For more information, see:

·         Checking the Results of Actions in the DBA Planning Calendar

·         Display of Backup Logs and Status: Oracle

Backup on a Standalone Windows Database Server

As an alternative to a remote shell service, you can activate the SAP Gateway, before starting a backup on a standalone Windows database server using BRBACKUP. Do the following:

...

       1.      Choose Tools ® System administration ® Administration ® Network ® RFC destinations. Alternatively, call transaction SM59.

       2.      Click + to open the TCP/IP connections node.

       3.      Double-click SAPXPG_DBDEST_<dbhostname>

       4.      Choose Destination ® Gateway options

       5.      Specify a Gateway host and a Gateway service

       6.      Choose O.K. and save the transaction.

For more information, see SAP Note 108777.