Forum Discussion

robertoaxity's avatar
robertoaxity
Moderator
5 years ago

Job Oracle Failed error (6)

Hello,

I have the error (6)  the backup failed to back up the requested files, in policy with backup the full instance and archive log.

08-10-2020 11:45:49 - Info bpbrm (pid=260502) pos.resp.derco.cl is the host to backup data from
08-10-2020 11:45:49 - Info bpbrm (pid=260502) reading file list for client
08-10-2020 11:45:50 - Info bpbrm (pid=260502) starting bphdb on client
08-10-2020 11:45:50 - Info bphdb (pid=9140) Backup started
08-10-2020 11:45:50 - Info bphdb (pid=9140) Waiting for the child status
08-10-2020 11:45:53 - Error bpbrm (pid=260502) from client pos.resp.derco.cl: ERR - Script exited with status = 1 <the requested operation was partially successful>
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF - ************************************************************
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF - Backup Information:
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF -  Client: pos.resp.derco.cl
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF -  ORACLE_SID: pos
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF -  ORACLE_HOME: /u01/app/oracle/product/12.1.0/dbhome_1
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF -  Objects being backed up:
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF -  Archive Logs
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF -  Control File
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF -  Number of channels to allocate (archive logs): 1
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF -  Oracle Authentication is being used
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF -  RMAN Default Limits will be used (Archive Logs)
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF -  Backup File Name Formats:
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF -  Archive Log: arch_d%d_u%u_s%s_p%p_t%t
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF -  Control File: ctrl_d%d_u%u_s%s_p%p_t%t
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF - End of Backup Information
08-10-2020 11:45:53 - Info bphdb (pid=9140) INF - ************************************************************
08-10-2020 11:45:53 - Error bpbrm (pid=260502) from client pos.resp.derco.cl: ERR - bphdb exit status = 6: the backup failed to back up the requested files
08-10-2020 11:45:53 - Info bphdb (pid=9140) done. status: 6: the backup failed to back up the requested files
08-10-2020 12:45:08 - Info nbjm (pid=16350) starting backup job (jobid=22906451) for client pos.resp.derco.cl, policy PRD-ORA-POS_ARC, schedule Archivelog
08-10-2020 12:45:08 - Info nbjm (pid=16350) requesting MEDIA_SERVER_ONLY resources from RB for backup job (jobid=22906451, request id:{3E09AB26-097D-11EB-91A7-277D895A1036})
08-10-2020 12:45:08 - requesting resource  stu_disk_lprpaplnetbk
08-10-2020 12:45:08 - requesting resource  lprvnetbkp01.resp.derco.cl.NBU_POLICY.MAXJOBS.PRD-ORA-POS_ARC
08-10-2020 12:45:09 - granted resource  lprvnetbkp01.resp.derco.cl.NBU_POLICY.MAXJOBS.PRD-ORA-POS_ARC
08-10-2020 12:45:10 - estimated 0 kbytes needed
08-10-2020 12:45:10 - Info nbjm (pid=16350) started backup (backupid=pos.resp.derco.cl_1602171910) job for client pos.resp.derco.cl, policy PRD-ORA-POS_ARC, schedule Archivelog on storage unit 
08-10-2020 12:45:11 - started process bpbrm (pid=260502)
08-10-2020 12:45:12 - connecting
08-10-2020 12:45:13 - connected; connect time: 0:00:00
08-10-2020 12:45:16 - end writing
the backup failed to back up the requested files  (6)

I see the dbclient in the oracle server, master server and media server, i dont see any register, so i dont know where are the log for this.

Regards.

 

8
Linux
  • Marianne's avatar
    Marianne
    Level 6
    5 years ago

    robertoaxity 

    ERR - Script exited with status = 1 <the requested operation was partially successful>

    1st thing to check is the script output file. Work with you Oracle dba to troubleshoot.

      • Marianne's avatar
        Marianne
        Level 6
        5 years ago
        robertoaxity wrote:

        Marianne 

        The DBA tell me the script is correct and no modifications have been made.

        Regards

        I never said there is anything wrong with the script. The rman script is failing with status 1 for some or other reason. NBU is only reporting that the script has failed.
        Maybe something is wrong with the archive logs. We need Oracle to tell us what is wrong.

        Ask the dba to check the rman output.
        You can also try to see if there is anything useful in this log: usr/openv/netbackup/logs/user_ops/dbext/logs/input.697.0.1602258353
        Also check for any other logs during this period over here : /usr/openv/netbackup/logs/user_ops/dbext/logs/

        According to the policy name, this might be an OIP. In that case, ensure that this log folder exist:
        /usr/openv/netbackup/logs/bpdbsbora

  • EthanH's avatar
    EthanH
    Level 4
    5 years ago

    You need to look at the bphdb logs on the Oracle client to see what caused it to fail, as well as the RMAN logs from your Oracle DBA. These two logs will give you a clearer picture on what to troubleshoot.

    I would also recommend looking through the NetBackup Troubleshooting Guide: https://www.veritas.com/content/support/en_US/doc/15179611-140217782-0/v15093591-140217782

    It has a lot of helpful information on where to start troubleshooting. Once you've developed a good technique for troubleshooting NetBackup problems, you can start utilizing the application-specific guides for more detailed troubleshooting steps. Here's the troubleshooting guide from the NBU for Oracle Admin guide: https://www.veritas.com/content/support/en_US/doc/16226115-130539065-0/v23552379-130539065

     

    • robertoaxity's avatar
      robertoaxity
      Moderator
      5 years ago

      EthanH 

      Logs.

      12:45:50.405 [696.696] <2> logparams: -sb -rdbms oracle -S lprvnetbkp01.resp.derco.cl -to 600 -c PRD-ORA-POS_ARC -s Archivelog -clnt pos.resp.derco.cl -intelligent_db_opts -TLOG -auto -kl 1 -b pos.resp.derco.cl_1602258318 -jobid 22924203
      12:45:50.406 [696.696] <2> ParseConfigExA: Option (CLIENT_NAME) redefined on line 8, discarding definition on line 7.
      12:45:50.406 [696.696] <2> ParseConfigExA: Option (CLIENT_NAME) redefined on line 8, discarding definition on line 7.
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - setenv NB_ORA_POLICY=PRD-ORA-POS_ARC
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - setenv NB_ORA_CLIENT=pos.resp.derco.cl
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - setenv NB_ORA_MODE=B
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - NB_ORA_POLICY=PRD-ORA-POS_ARC
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - NB_ORA_SCHED=Archivelog
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - NB_ORA_PC_SCHED=Archivelog
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - NB_ORA_SERV=lprvnetbkp01.resp.derco.cl
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - NB_ORA_PC_BTYPE not set
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - setenv NB_ORA_FULL=0
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - setenv NB_ORA_INCR=0
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - setenv NB_ORA_CINC=0
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - setenv NB_ORA_SCHEDULED=1
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - setenv NB_ORA_PARENT_JOBID=22924203
      12:45:50.406 [696.696] <2> debuglog: <4> bphdb: INF - BACKUP START 696
      12:45:50.407 [696.696] <2> debuglog: <4> bphdb: INF - CONTINUE BACKUP message received
      12:45:50.408 [696.696] <2> debuglog: <4> bphdb: INF - Waiting for the child status
      12:45:53.141 [697.697] <2> debuglog: <4> bphdb: impersonation successfull
      12:45:53.142 [697.697] <2> debuglog: <4> bphdb: INF - Child executing /usr/openv/netbackup/bin/bpdbsbora -enhbackup -L BRMJBD5 -rw -i /usr/openv/netbackup/logs/user_ops/dbext/logs/input.697.0.1602258353 -jobid 22924203
      12:45:54.429 [696.696] <2> debuglog: <16> bphdb: ERR - Script exited with status = 1 <the requested operation was partially successful>
      12:45:54.429 [696.696] <2> debuglog: <16> bphdb: ERR - bphdb exit status = 6: the backup failed to back up the requested files
      12:45:54.429 [696.696] <2> debuglog: <4> bphdb: INF - EXIT STATUS 6: the backup failed to back up the requested files

       

      Regards