IT37372: ORACLE RESTORE FAILS WITH ERROR ORA-01194 WHEN LOG BACKUP IS CONFIGURED TO TRUNCATE LOGS IMMEDIATELY

APAR status

• Closed as program error.

Error description

• Restoring an Oracle database with IBM Spectrum Protect Plus
  fails with the following error indicating the database cannot be
  opened because one or more files are inconsistent.
  
  DBNAME: alter database open resetlogs;
  DBNAME: ORA-01194: file <n> needs more recovery to be consistent
  
  CTGGF0156, Database DBNAME: Restore failed: Failed to open
  database
  
  The failure occurs due to missing logs in the data volume
  because they were truncated after being copied to the log
  volume. It occurs when all the following conditions are met:
  
  - Log backup was enabled for the database and the option to
  truncate logs immediately after backup was selected
  - The schedules were configured in a way that a log backup
  operation occurred while the regular SLA backup was running.
  - The restore is a non-PIT restore that is, it is configured to
  restore a specific backup, not an intermediate point in time.
  
  For example, if the SLA backup runs for 30 minutes and a log
  backup also runs during this time, the log backup can truncate
  some logs immediately. When the SLA backup completes, it tries
  to create another backup copy of the archived logs generated
  during the 30-minute window. Some of the logs, which were
  already truncated are not captured again. During non-PIT
  restore, SPP uses only the logs stored in the backup volume that
  is missing some of the necessary logs. The missing logs are
  available in the separate log backup volume but SPP does not
  make use of it.
  
  | MDVREGR - IT36091 |
  
  Affected versions:
  IBM Spectrum Protect Plus 10.1.7.2 and later.
  
  Keywords: TS005812092
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus levels 10.1.7 ifix2 and 10.1.8     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see ERROR Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed IBM Spectrum Protect Plus levels       *
  * 10.1.8 ifix2 and 10.1.9. Note that this is subject to change *
  * at the discretion of IBM.                                    *
  ****************************************************************
  

Problem conclusion

• The issue was caused by log backup task purging source logs
  while database backup in progress. Changes where made to skip
  source log truncation if databases backup is in progress.
  Restore job from backups created after applying the fix can be
  restored without ORA-01194 error.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• App      Oracle
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels