SnapProtect - Troubleshooting - SAP Oracle

Table of Contents

SAPOR0001: Restore operation fails on selecting the copy precedence as 1 if the logs were backed up traditionally

If you back up the data after selecting the Use Traditional Backup for Logs check box and then try to restore it by selecting the copy precedence as 1, the restore job will fail.

Symptom

When you run a backup after selecting the Use Traditional Backup for Logs checkbox,

  • Snap backup is run on the data and the copy precedence of the data is set to 1
  • Logs are backed up traditionally and the copy precedence of the logs is set to 2

Because of this difference in the copy precedence, if you run a restore by selecting the copy precedence as 1, the restore operation fails.

Resolution

Run a restore without selecting any copy precedence.

Alternatively, you can perform a backup copy operation to copy snapshot of the backed up data to any media and then run a restore by selecting the copy precedence as 2. For step-by-step instructions to run a backup copy, see Backup Copy Operations.

SAPOR0002: Data and log restore operation fails when trying to restore from data only jobs

The restore operation fails with the following error message while using the Restore by Job feature to restore data and log. For more information, see Restore by Jobs.

Failing restore as the log summary file information could not be found.

Symptom

For restoring both data and log, if you try to restore from the data only job, the restore operation will fail.

Resolution

Run a restore by selecting the job type as Log Incremental.

Completed with one or more errors

Backup jobs from SAP for Oracle iDataAgent will be displayed as "Completed w/ one or more errors" in the Job History in the following cases:
  • After backup, if the job gets killed after running the archive index phase.

  • If the brbackup or brarchive returns with warnings, the job will be marked "Completed with warnings".

Restore jobs from SAP for Oracle iDataAgent will be displayed as "Completed with Warnings" in the Job History in the following cases:
  • When the database restore succeeds but it fails when recovering the database or opening the database.