IBM Support

IT36181: "<CTGGF0156> DATABASE REMEDY: RESTORE FAILED: FAILED TO START INSTANCES" FOR ORACLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Oracle is configured on RAC environment. Oracle backup is taken
    on production. Then execute with IBM Spectrum Protect Plus a
    restore job to DR environment with RAC. The restore is
    successful  but the Oracle instance can not be started.
    
    In the command log;
    
    [Date+Time] JOBLOG pid:4953
    Thread-17 worker_restore: remedy: Starting up instance for
    restored database
    [Date+Time] JOBLOG pid:4953 Thread-17
    writeInputFile: <CTGGF0175> remedy1: Running command: startup
    nomount pfile='/mnt/spp/vsnap/vpool1/fs13/10_16_2_244/<DB_NAME>/
    initXXXX.ora';
    Date+Time] INFO pid:4953 Thread-17
    run_shell_command: Return code 1: ps -ef | grep
    _[p]mon_XXXXX
    [Date+Time] INFO pid:4953 Thread-17
    startupInstancewithPmonCheck: The startup instance process has
    encountered some issue: ['DIA-49601: syntax error: found
    "<number>": expecting one of: "End-of-Statement" etc..',
    'DIA-49100: Failed to process event statement [level 1]',
    'ORA-01078: failure in processing system
    parameters']
    [Date+Time] INFO pid:4953 Thread-17
    startupInstancewithPmonCheck: Traceback (most recent call
    last): File
    "/opt/IBM/SPP/agents_orasppagent/oracleagent/runner.py", line
    927, in startupInstancewithPmonCheck
    
    Exception
    
    [Date+Time]
    INFO pid:4953 Thread-17 worker_restore: Traceback (most recent
    call last): File
    "/opt/IBM/SPP/agents_orasppagent/oracleagent/runner.py", line
    927, in startupInstancewithPmonCheck
    
    Exception
    
    During handling of the above exception, another exception
    occurred:
    
    Traceback (most recent call last):
    File
    "/opt/IBM/SPP/agents_orasppagent/oracleagent/restore.py", line
    492, in worker_restore
    File
    "/opt/IBM/SPP/agents_orasppagent/oracleagent/runner.py", line
    930, in startupInstancewithPmonCheck
    oracleagent.runner.SqlRunnerError: Failed to start
    instance
    
    [Date+Time] ERROR pid:4953 Thread-17 worker_restore:
    <CTGGF0156> Databas remedy: Restore failed: Failed to start
    instance
    
    Versions affected: 10.1.*
    

Local fix

  • The restored Oracle ora file has following content:
    *.event='xxxx trace name context forever', 'level 1'
    
    
    Modify the content to:
    *.event='xxxx trace name context forever, level 1'
    

Problem summary

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

Problem conclusion

  • The restore will complete successfully even when the pfile has
    commas in quoted parameter values.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT36181

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A16

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-03-11

  • Closed date

    2021-03-18

  • Last modified date

    2021-03-18

  • 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":"A16","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
31 January 2024