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 number
IT29155
Reported component name
SP PLUS
Reported component ID
5737SPLUS
Reported release
A13
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-05-15
Closed date
2019-06-07
Last modified date
2019-06-07
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A13","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
30 January 2024