IT29155: IBM SPECTRUM PROTECT PLUS ORACLE DB RESTORES FAILS WITH "KEYERROR:<DB NAME>"AND FAILED TO RUN DISCOVERY FOR ORACLE AGENT

APAR status

• Closed as program error.

Error description

• Attempting to restore an Oracle databases results in the
  following errors in the restore job log.
  Restore Job Log:
  [oracle-server-name] ORA-01219: database or pluggable database
  not open: queries allowed on fixed tables or views only
  [oracle-server-name] IndexError: list index out of range
  [oracle-server-name] Could not collect details for DB instance
  ORADB
  [oracle-server-name] Collecting list of ASM diskgroups
  [oracle-server-name] KeyError: 'ORADB'
  [oracle-server-name] Failed to run discovery for oracle agent
  [oracle-server-name] Discovered 0 application instances and 3
  mounted volume(s) on 2 disk(s) in 3s
  (oracle-server-name) using FC initiators () iSCSI initiators
  (iqn.1994-05.com.redhat:1934c4c1517a) and IP addresses (1.2.3.4
  5.6.7.8).
  There are no hosts available for destination instance
  (oracle-server-name / OraDB-instance).
  No selected item is recoverable.
  Virgo log:
  [oracle-server-name] ORA-01219: database or pluggable database
  not open: queries allowed on fixed tables or views only
  [oracle-server-name] IndexError: list index out of range
  Could not collect details for DB instance ORADB
  Collecting list of ASM diskgroups
  [oracle-server-name] KeyError: 'ORADB'
  Failed to run discovery for oracle agent
  Discovered 0 application instances and 3 mounted volume(s) on 2
  disk(s) in 3s
  File download failed on host(oracle-server-name). Error({})
  com.jcraft.jsch.SftpException: No such file
     at
  com.jcraft.jsch.ChannelSftp.throwStatusError(ChannelSftp.java:28
  46)
     at com.jcraft.jsch.ChannelSftp._get(ChannelSftp.java:1037)
     at com.jcraft.jsch.ChannelSftp.get(ChannelSftp.java:1006)
     at com.jcraft.jsch.ChannelSftp.get(ChannelSftp.java:984)
     at
  com.catalogic.ecx.ftp.SshFtpImpl.downloadFile(SshFtpImpl.java:45
  8)
     at
  com.catalogic.ecx.deploy.GenericDeployer.retrieve(GenericDeploye
  r.java:144)
     at
  com.catalogic.ecx.remoteexecutor.impl.RemoteExecutorImplSsh.retr
  ieveFileForLogCollect(RemoteExecutorImplSsh.java:519)
     at
  com.catalogic.ecx.remoteexecutor.impl.RemoteExecutorImplSsh.exec
  uteCommand(RemoteExecutorImplSsh.java:513)
     at
  com.catalogic.ecx.remoteexecutor.impl.RemoteExecutorImplSsh.exec
  (RemoteExecutorImplSsh.java:139)
  Versions affected: 10.1.2,10.1.3
  Keywords: TS002189326
  

Local fix

• On the Oracle host machine, open an sqlplus session to
  the database named in the "KeyError" message. Shut it down
  using "shutdown immediate". Depending on the state of the
  database, "shutdown abort"  might be needed to shut
  down the database. Once it is down, retry the restore.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus version 10.1.3                     *
  ****************************************************************
  * 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.4. Note that this is subject to change at the           *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• During an Oracle inventory, backup, or restore, if the Oracle
  server contains a database instance that is started but is in
  NOMOUNT mode, then the details of the database cannot be
  queried, resulting in the job failing entirely. The problem has
  been resolved by skipping over databases running in NOMOUNT mode
  so that the job continues running and attempts to discover the
  details of other databases.
  

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:

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels