cancel
Showing results for 
Search instead for 
Did you mean: 

bphdb exit status = 6: the backup failed to back up the requested files

Hannible
Level 4

Hello,

we are getting error on Below RMAN Backup.. please suggest what is the issue with it and what can be done to resolve it..Thanks

Master Serve is Windows 2008,

Netbackup 7.5

client is Windows Windows 2003

Oracle 10G R1

 

below is Netbackup error..

06/08/2014 16:55:46 - connecting
06/08/2014 16:55:49 - Info bpbrm (pid=13560) starting bphdb on client
06/08/2014 16:55:49 - connected; connect time: 0:00:00
06/08/2014 16:55:52 - Info bphdb (pid=5448) Backup started
06/08/2014 16:55:54 - Error bpbrm (pid=13560) from client tmgsdhypprddb: ERR - Script <"C:\Program Files\Veritas\NetBackup\scripts\hot_database_backup_hypp.cmd"> failed with status: <1>
06/08/2014 16:55:56 - Error bpbrm (pid=13560) from client tmgsdhypprddb: ERR - Script <"C:\Program Files\Veritas\NetBackup\scripts\hot_database_backup_hypdb.cmd"> failed with status: <1>
06/08/2014 16:55:56 - Error bpbrm (pid=13560) from client tmgsdhypprddb: ERR - bphdb exit status = 6: the backup failed to back up the requested files
06/08/2014 16:55:59 - Info bphdb (pid=5448) done. status: 6: the backup failed to back up the requested files
06/08/2014 16:55:59 - end writing
the backup failed to back up the requested files  (6)

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

RMAN-04005: error from target database:

ORA-01031: insufficient privileges

Your Oracle dba needs to address this.

As per my previous post:

Have you confirmed that NBU Client Service is started as a user with Oracle db rights as well as local Admin rights?

See this topic in NBU for Oracle Admin Guide

Configuring the log on account for the NetBackup Client Service for NetBackup for Oracle on Windows

View solution in original post

8 REPLIES 8

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Assuming these scripts were built from the netbackup samples then theres should be output files created in C:\Program Files\Veritas\NetBackup\scripts\. One with err and one with out. Check them to see the error faced by RMAN.

Hannible
Level 4

Hello Riaan,

no file is Created @ C:\Program Files\Veritas\NetBackup\scripts\.

please suggest..??

 

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Then you would need to look inside the script to see where the log location is. Usually its the same folder as where the script is located. Unless someone specified some other location.

 

You can also try and run the script from CLI, see what it says.
 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Status 6 is a generic error saying that the rman script has failed.

The first log to check is the output file created by the rman script.

Please check the script on the client:
"C:\Program Files\Veritas\NetBackup\scripts\hot_database_backup_hypp.cmd"
to see where the output file is written. 
Based on the error(s) we see in rman output/log file, we may need NBU logs as well.
Please confirm that all of these log folders exist on the client:
bpcd dbclient bphdb

 

Have you confirmed that NBU Client Service is started as a user with Oracle db rights as well as local Admin rights?
 

Hannible
Level 4

Hello Marianne,

 

sorry for late rply..

 

actual error is that the Rman Backup is failing with below error..even oracle admin is not able to take Rman Backup.

 

We are getting below error

 

==== started on Mon 06/09/2014  05:10 ====

Script name: "C:\Program Files\Veritas\NetBackup\scripts\hot_database_backup_hypdb.cmd"

#                                      

  RMAN  :  c:\oracle\ora92\bin\rman.exe                      

  NLS_LANG  :  american              

  ORACLE_HOME  :  c:\oracle\ora92        

  ORACLE_SID  :  HYPDB          

  NLS_DATE_FORMAT  :  YYYY-MM-DD:hh24:mi:ss

  RMAN_LOG_FILE  :  "C:\Program Files\Veritas\NetBackup\scripts\hot_database_backup_hypdb.out"     

  NB_ORA_SERV  :  wdcbkupmstr                    

  NB_ORA_FULL  :  1                    

  NB_ORA_INCR  :  0                    

  NB_ORA_CINC  :  0                    

 

Recovery Manager: Release 9.2.0.5.0 - Production

 

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

 

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: initialization of internal recovery manager package failed

RMAN-04005: error from target database:

ORA-01031: insufficient privileges

 

 

Hannible
Level 4

Hello Marianne,

sorry for late rply actully the Oracle admin is unable to take Rman Backup.. and the script is failing with below error..

We are getting below error

 

==== started on Mon 06/09/2014  05:10 ====

Script name: "C:\Program Files\Veritas\NetBackup\scripts\hot_database_backup_hypdb.cmd"

#                                      

  RMAN  :  c:\oracle\ora92\bin\rman.exe                      

  NLS_LANG  :  american              

  ORACLE_HOME  :  c:\oracle\ora92        

  ORACLE_SID  :  HYPDB          

  NLS_DATE_FORMAT  :  YYYY-MM-DD:hh24:mi:ss

  RMAN_LOG_FILE  :  "C:\Program Files\Veritas\NetBackup\scripts\hot_database_backup_hypdb.out"     

  NB_ORA_SERV  :  wdcbkupmstr                    

  NB_ORA_FULL  :  1                    

  NB_ORA_INCR  :  0                    

  NB_ORA_CINC  :  0                    

 

Recovery Manager: Release 9.2.0.5.0 - Production

 

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

 

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: initialization of internal recovery manager package failed

RMAN-04005: error from target database:

ORA-01031: insufficient privileges

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

RMAN-04005: error from target database:

ORA-01031: insufficient privileges

Your Oracle dba needs to address this.

As per my previous post:

Have you confirmed that NBU Client Service is started as a user with Oracle db rights as well as local Admin rights?

See this topic in NBU for Oracle Admin Guide

Configuring the log on account for the NetBackup Client Service for NetBackup for Oracle on Windows

Will_Restore
Level 6

This technote agrees with Marianne:

http://www.symantec.com/business/support/index?page=content&id=TECH136157

If the backup shows an ORA-01031: insufficient privileges error message, check the account being used for backups for sysdba rights.