IT38208: ORACLE DATABASE RESTORE FAILS WITH ERROR: ORA-01109: DATABASE NOT OPEN

APAR status

• Closed as program error.

Error description

• Using IBM Spectrum Protect Plus, an Oracle database restore can
  fail with the following errors seen in the job log:
  ERROR,<timestamp>,<system.host.name> <DB name>: ORA-01109:
  database not open
  ERROR,<timestamp>,<system.host.name> <DB name>: ALTER TABLESPACE
  TEMP ADD TEMPFILE '+DATA/<DB name>/TEMPFILE_3.DBF' SIZE 68157440
  REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M
  WARN,<timestamp>,CTGGF0152,<system.host.name> <DB name>: Failed
  to add tempfile(s) to TEMP tablespace.
  
  The failure is caused when the "log_archive_format" parameter is
  set in the original DB configuration and during a restore the
  IBM Spectrum Protect Plus agent attempts to update that
  parameter, while the restored DB is already active.
  
  
  IBM Spectrum Protect Versions Affected:
  IBM Spectrum Protect Plus 10.1.x
  

Local fix

Problem summary

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

Problem conclusion

• Fixed an issue with parsing quoted '#' character in pfiles. With
  the fix restore of databases with quoted '#' character in pfiles
  will complete successfully.
  

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