IBM Storage Defender

IBM Storage Defender

Early threat detection and secure data recovery

 View Only

  • 1.  SAP backup failing

    Posted 01/22/19 07:23 AM
    Hi All,

    I need your help to settle down one SAP issue it is throwing below error all of sudden last backup completed on 27th Dec 2018, after that it is started throwing below error although archive backup is completing and clearing the logs as well.

    Recovery Manager complete.
    BR0280I BRBACKUP time stamp: 2019-01-22 12.32.09
    BR0279E Return code from 'SHELL=/bin/sh /oracle/PB1/112_64/bin/rman nocatalog': 1
    BR0522I 178 of 178 files / save sets processed by RMAN
    BR0536E RMAN call for database instance PB1 failed
    BR0200I BR_TRACE: location BrRmanCall-56, commands for RMAN in: /oracle/PB1/sapbackup/.bfahsjqi.cmd
    @/oracle/PB1/sapbackup/..bfahsjqi..cmd
    host '/usr/sap/PB1/SYS/exe/run/brtools -f delete /oracle/PB1/sapbackup/..bfahsjqi..cmd';
    run { allocate channel sbt_1 device type 'SBT_TAPE'
    parms 'SBT_LIBRARY=/oracle/PB1/112_64/lib/libobk.sl,ENV=(XINT_PROFILE=/oracle/PB1/112_64/dbs/initPB1.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=bfahsjqi.fnr)';
    allocate channel sbt_2 device type 'SBT_TAPE'
    parms 'SBT_LIBRARY=/oracle/PB1/112_64/lib/libobk.sl,ENV=(XINT_PROFILE=/oracle/PB1/112_64/dbs/initPB1.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=bfahsjqi.fnr)';
    backup incremental level 0 tag bfahsjqi format 'PB1_bfahsjqi.%s_%p' filesperset 1 check logical
    database;

    Thanks
    Prem


  • 2.  RE: SAP backup failing

    Posted 01/28/19 09:20 AM
    Hi All,

    Please advise still my SAP backup is failing with below error.

    BR0280I BRBACKUP time stamp: 2019-01-26 15.44.52
    BR0279E Return code from 'SHELL=/bin/sh /oracle/test/112_64/bin/rman nocatalog': 1
    BR0522E 24 of 139 files / save sets processed by RMAN
    BR0536E RMAN call for database instance test failed
    BR0200I BR_TRACE: location BrRmanCall-56, commands for RMAN in: /oracle/test/sapbackup/.bfaipjsc.cmd
    @/oracle/test/sapbackup/..bfaipjsc..cmd
    host '/usr/sap/test/SYS/exe/run/brtools -f delete /oracle/test/sapbackup/..bfaipjsc..cmd';
    run { allocate channel sbt_1 device type 'SBT_TAPE'
    parms 'SBT_LIBRARY=/oracle/test/112_64/lib/libobk.so,ENV=(XINT_PROFILE=/oracle/test/112_64/dbs/initHebdotest.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=bfaipjsc.fnr)';
    allocate channel sbt_2 device type 'SBT_TAPE'
    parms 'SBT_LIBRARY=/oracle/test/112_64/lib/libobk.so,ENV=(XINT_PROFILE=/oracle/test/112_64/dbs/initHebdotest.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=bfaipjsc.fnr)';
    allocate channel sbt_3 device type 'SBT_TAPE'
    parms 'SBT_LIBRARY=/oracle/test/112_64/lib/libobk.so,ENV=(XINT_PROFILE=/oracle/test/112_64/dbs/initHebdotest.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=bfaipjsc.fnr)';
    backup incremental level 0 tag bfaipjsc format 'test_bfaipjsc.%s_%p' filesperset 1 check logical
    database;
    release channel sbt_1;
    release channel sbt_2;
    release channel sbt_3; }
    list backup of database tag bfaipjsc;
    exit;

    BR0280I BRBACKUP time stamp: 2019-01-26 15.44.52
    BR0506E Full database backup (level 0) using RMAN failed

    BR0056I End of database backup: bfaipjsc.fnr 2019-01-26 15.44.52
    BR0280I BRBACKUP time stamp: 2019-01-26 15.44.54
    BR0054I BRBACKUP terminated with errors

    When i am using below option backup is getting successful.

    backup_dev_type util_file- Working with this settings on .SAP file.
    but when I am attempting through RMAN it is failing a very small setting I am missing please advise.
    backup_dev_type rman_util- Not Working with this settings on .SAP file







    ------------------------------
    Prem Singh

    ------------------------------



  • 3.  RE: SAP backup failing

    Posted 01/27/19 11:30 PM
    Hi All,

    I am waiting for your valuable suggestion please advise.

    Thanks 
    Prem 


    ------Original Message------

    Hi All,

    Please advise still my SAP backup is failing with below error.

    BR0280I BRBACKUP time stamp: 2019-01-26 15.44.52
    BR0279E Return code from 'SHELL=/bin/sh /oracle/test/112_64/bin/rman nocatalog': 1
    BR0522E 24 of 139 files / save sets processed by RMAN
    BR0536E RMAN call for database instance test failed
    BR0200I BR_TRACE: location BrRmanCall-56, commands for RMAN in: /oracle/test/sapbackup/.bfaipjsc.cmd
    @/oracle/test/sapbackup/..bfaipjsc..cmd
    host '/usr/sap/test/SYS/exe/run/brtools -f delete /oracle/test/sapbackup/..bfaipjsc..cmd';
    run { allocate channel sbt_1 device type 'SBT_TAPE'
    parms 'SBT_LIBRARY=/oracle/test/112_64/lib/libobk.so,ENV=(XINT_PROFILE=/oracle/test/112_64/dbs/initHebdotest.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=bfaipjsc.fnr)';
    allocate channel sbt_2 device type 'SBT_TAPE'
    parms 'SBT_LIBRARY=/oracle/test/112_64/lib/libobk.so,ENV=(XINT_PROFILE=/oracle/test/112_64/dbs/initHebdotest.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=bfaipjsc.fnr)';
    allocate channel sbt_3 device type 'SBT_TAPE'
    parms 'SBT_LIBRARY=/oracle/test/112_64/lib/libobk.so,ENV=(XINT_PROFILE=/oracle/test/112_64/dbs/initHebdotest.utl,PROLE_PORT=57323,BR_CALLER=BRBACKUP,BR_BACKUP=FULL,BR_REQUEST=NEW,BR_RUN=bfaipjsc.fnr)';
    backup incremental level 0 tag bfaipjsc format 'test_bfaipjsc.%s_%p' filesperset 1 check logical
    database;
    release channel sbt_1;
    release channel sbt_2;
    release channel sbt_3; }
    list backup of database tag bfaipjsc;
    exit;

    BR0280I BRBACKUP time stamp: 2019-01-26 15.44.52
    BR0506E Full database backup (level 0) using RMAN failed

    BR0056I End of database backup: bfaipjsc.fnr 2019-01-26 15.44.52
    BR0280I BRBACKUP time stamp: 2019-01-26 15.44.54
    BR0054I BRBACKUP terminated with errors

    When i am using below option backup is getting successful.

    backup_dev_type util_file- Working with this settings on .SAP file.
    but when I am attempting through RMAN it is failing a very small setting I am missing please advise.
    backup_dev_type rman_util- Not Working with this settings on .SAP file







    ------------------------------
    Prem Singh

    ------------------------------


  • 4.  RE: SAP backup failing

    Posted 01/28/19 09:07 AM
    Guys,

    Any suggestions any thoughts pls.

    Thanks 
    Prem 


    ------Original Message------

    Hi All,

    I am waiting for your valuable suggestion please advise.

    Thanks 
    Prem 




  • 5.  RE: SAP backup failing

    Posted 02/01/19 05:49 AM
    any suggestion any advise, Pls

    ------------------------------
    Prem Singh

    ------------------------------

    Original Message


  • 6.  RE: SAP backup failing

    Posted 02/08/19 07:07 AM
    Any idea any suggestions pls

    Thanks & regards
    Prem Singh Bathyal
    Mobile - 8527337214


    ------Original Message------

    any suggestion any advise, Pls

    ------------------------------
    Prem Singh

    ------------------------------


  • 7.  RE: SAP backup failing

    Posted 02/11/19 07:08 AM
    Hi All,

    I am waiting for the suggestion please advise.

    From util_file parameter on sid.sap it is working perfectly but why it's not working through RMAN.

    Thanks & regards
    Prem Singh Bathyal
    Mobile - 8527337214


    ------Original Message------

    Any idea any suggestions pls

    Thanks & regards
    Prem Singh Bathyal
    Mobile - 8527337214




  • 8.  RE: SAP backup failing

    Posted 02/12/19 12:56 AM
    Hi,
    Since this is a complex issue between SAP, Oracle and Spectrum  Protect, you may want to open a ticket to them to get a solution. It is very difficult to debug any thing when we do not have any access to logs and applications.

    My humble advice is:
    1. If dsmc backup of files/directoried orks, then Spectrum Protect server is probably ok.  Check logs on client and host to verify.
    2. If normal backup/restore of Oracle db using destination to file, then Oracle is OK. Again verify that no errors are recorded neither server nor client side
    3. If normal backup/restore of Oracle db using rman/tsm, then Oracle is OK. Check logs ...
    4. If backup from SAP is not working when calling Oracle, then SAP should be contacted.
    Best of luck in finding the error

    ------------------------------
    Håkon Phillip Tønder-Keul
    ------------------------------

    Original Message


  • 9.  RE: SAP backup failing

    Posted 02/13/19 08:39 AM
    Start at the top:

    1.  dsmc q b *, if this works it proves base connectivity it working.
    2. Perform a log backup using util_file, if this works, it means prole is ok and TDP SAP is installed and at least partially configured.  A restart of prole can also solve many issues.
    3. From a command prompt, type which backint (where backint.exe on windows), make sure only one backint comes up and that it's a symlink if a UNIX system.
    3. Start rman, then use "allocate channel for maintenance type sbt_tape "PARMS=......" to setup load up the shared library (if on UNIX).  This should show the banner of the TDP before it returns to a prompt.  You can then use crosscheck backup all to validate communications.
    **If you are on windows, you must make sure that the ORASBT.dll under the tdp_r3 directory is the only one that shows up when you type where orasbt.dll from a command prompt.  For Windows, the Oracle services must be restarted before you can use rman_util, or just a good reboot will make sure.

    If all of these work independently, then the issue is with SAP.  The process flow is backint is the one calling rman, so you will need to engage SAP as to why.  Also, realize that the RMAN support must be installed with the initial install of the client (it's just a check box, the default is no)


    ------Original Message------

    Hi,
    Since this is a complex issue between SAP, Oracle and Spectrum  Protect, you may want to open a ticket to them to get a solution. It is very difficult to debug any thing when we do not have any access to logs and applications.

    My humble advice is:
    1. If dsmc backup of files/directoried orks, then Spectrum Protect server is probably ok.  Check logs on client and host to verify.
    2. If normal backup/restore of Oracle db using destination to file, then Oracle is OK. Again verify that no errors are recorded neither server nor client side
    3. If normal backup/restore of Oracle db using rman/tsm, then Oracle is OK. Check logs ...
    4. If backup from SAP is not working when calling Oracle, then SAP should be contacted.
    Best of luck in finding the error

    ------------------------------
    Håkon Phillip Tønder-Keul
    ------------------------------


  • 10.  RE: SAP backup failing

    Posted 02/13/19 01:25 PM
    Hi Kenneth,

    Thank you for the detail information, all looks good to me when I use util file backup and archive job is functioning properly.

    I have no option now to check below.

    If all of these work independently, then the issue is with SAP.  The process flow is backint is the one calling rman, so you will need to engage SAP as to why.  Also, realize that the RMAN support must be installed with the initial install of the client (it's just a check box, the default is no)

    --
    Regards
    Prem Singh Bathyal
    Contact- 8527337214


    ------Original Message------

    Start at the top:

    1.  dsmc q b *, if this works it proves base connectivity it working.
    2. Perform a log backup using util_file, if this works, it means prole is ok and TDP SAP is installed and at least partially configured.  A restart of prole can also solve many issues.
    3. From a command prompt, type which backint (where backint.exe on windows), make sure only one backint comes up and that it's a symlink if a UNIX system.
    3. Start rman, then use "allocate channel for maintenance type sbt_tape "PARMS=......" to setup load up the shared library (if on UNIX).  This should show the banner of the TDP before it returns to a prompt.  You can then use crosscheck backup all to validate communications.
    **If you are on windows, you must make sure that the ORASBT.dll under the tdp_r3 directory is the only one that shows up when you type where orasbt.dll from a command prompt.  For Windows, the Oracle services must be restarted before you can use rman_util, or just a good reboot will make sure.

    If all of these work independently, then the issue is with SAP.  The process flow is backint is the one calling rman, so you will need to engage SAP as to why.  Also, realize that the RMAN support must be installed with the initial install of the client (it's just a check box, the default is no)




  • 11.  RE: SAP backup failing

    Posted 02/25/19 07:13 AM
    Hi All,

    We have moved the cluster into primary node and I have attempted the backup now failing with different error.

    BR0278E Command output of '/usr/sbin/cmviewcl':

    Permission denied to 127.0.0.1

    cmviewcl: Cannot view the cluster configuration: Permission denied.

    This user doesn't have access to view the cluster configuration.

    BR0280I BRBACKUP time stamp: 2019-02-23 02.37.06

    BR0279E Return code from '/usr/sbin/cmviewcl': 1

    BR0299E Split/resynchronization of mirror disks failed


    Thanks 
    Prem 


    ------Original Message------

    Hi Kenneth,

    Thank you for the detail information, all looks good to me when I use util file backup and archive job is functioning properly.

    I have no option now to check below.

    If all of these work independently, then the issue is with SAP.  The process flow is backint is the one calling rman, so you will need to engage SAP as to why.  Also, realize that the RMAN support must be installed with the initial install of the client (it's just a check box, the default is no)

    --
    Regards
    Prem Singh Bathyal
    Contact- 8527337214




Related Content