IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    IT40009

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A18

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-02-18

  • Closed date

    2022-03-03

  • Last modified date

    2022-03-03

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A18","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
01 February 2024