IT40009: ORACLE BACKUP ON AIX CAN FAIL WITH ERROR MESSAGE CTGGA4119 COULD NOT UNMOUNT

APAR status

• Closed as program error.

Error description

• After 10.1.8.2 (ifix2)is applied, during Oracle backup on AIX,
  
  the job can fail with  error message CTGGA4119.
  After this,  it will be required to  manually dismount
  
  the Filesystem (FS) and  to re-trigger the backup
  
  joblog:
  
  {{DETAIL,1634976469016,time
  ...CEST,2,CTGGF0022,[lnx002566.mpl.name.com AS2MGBL0: Completed
  datafile backups; total output bytes = 160022528 (152.61MB)
  DETAIL,1634976469018,time ....
  CEST,2,CTGGF0023,[lnx002566.mpl.name.com AS2MGBL0: Backing up
  archived logs to
  /mnt/spp/vsnap/vpool1/fs402/10_217_14_123/AS2MGBL0/arch for SCN
  range 7832063191082 to 7832063191082.
  ERROR,1634976498247,time.....
  CEST,2,CTGGA4119,[MPLAIX0054.mpl.name.com Could not unmount the
  mount point /mnt/spp/vsnap/vpool1/fs338/10_217_14_123.
  WARN,1634976498249,time .....
  CEST,2,CTGGA4029,[MPLAIX0054.mpl.name.com Cannot mount volume
  /mnt/spp/vsnap/vpool1/fs338/10_217_14_123. There were errors
  while trying to unmount the existing volume.
  DETAIL,1634976498251,time ....
  CEST,2,CTGGA4034,[MPLAIX0054.mpl.name.com Completed mount
  operation in 1m 16s. 0 volumes/shares mounted successfully and 1
  volumes/shares failed
  ERROR,1634976498780,time .....
  CEST,2,CTGGA2073,[MPLAIX0242.mpl.name.com Failed to perform
  backup of db instance mplaix0242 / ORA12ITRW on application
  server server.name.com : Failed to mount backup destination
  DETAIL,1634976498791,time .....
  CEST,2,CTGGF0025,[MIAIBV231.MIA.name.COM ICT2GBL1: Completed
  archived log backups; total output bytes = 743936 (726.50KB)}}
  
  You can find key symptoms  in the command.log of the
  enablelogbackup task:
  ['Usage: mount -V                 : print version', 'mount -h
               : print this help', 'mount                    :
  list mounted filesystems', 'mount -l                 : idem,
  including volume labels', 'So far the informational part.
  
  Next the mounting.', "The command is `mount [-t fstype]
  something somewhere'.", 'Details found in /etc/fstab may be
  omitted.', 'mount -a [-t|-O] ...     : mount all stuff from
  /etc/fstab', 'mount device             : mount device at the
  known place',
  
  'mount directory          : mount known device here', 'mount -t
  type dev dir    : ordinary mount command', 'Note that one does
  not really mount a device, one mounts', 'a filesystem (of the
  given type) found on the device.',
  
  'One can also mount an already visible directory tree
  elsewhere:', 'mount --bind olddir newdir', 'or move a subtree:',
  'mount --move olddir newdir', 'One can change the type of mount
  containing the directory dir:', 'mount --make-shared dir',
  'mount --make-slave dir', 'mount --make-private dir',
  
  'mount --make-unbindable dir', 'One can change the type of all
  the mounts in a mount subtree', 'containing the directory dir:',
  'mount --make-rshared dir', 'mount --make-rslave dir', 'mount
  --make-rprivate dir', 'mount --make-runbindable dir', 'A device
  can be given by name, say /dev/hda1 or /dev/cdrom,', 'or by
  label, using  -L label  or by uuid, using  -U uuid .', 'Other
  options: [-nfFrsvw] [-o options] [-p passwdfd].', 'For many more
  details, say  man 8 mount .']
  
  | MDVREGR 10.1.8.1  5737SPLUS |
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.8.2 and later
  
  
  
  Additional Keywords:
  
  SPP, SPPlus, TS007309228, oracle, aix
  

Local fix

• Manually dismount the FS and re-trigger backup
  

Problem summary

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

Problem conclusion

• A mount command parameter was changed that was causing mount
  failure on AIX. After applying the fix, the Oracle backups on
  AIX will complete successfully without mount errors.
  

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

• Apps     Oracle
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels