06-08-2014 04:40 AM
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)
Solved! Go to Solution.
06-11-2014 03:33 AM
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
06-08-2014 05:41 AM
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.
06-08-2014 06:48 AM
Hello Riaan,
no file is Created @ C:\Program Files\Veritas\NetBackup\scripts\.
please suggest..??
06-08-2014 09:03 AM
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.
06-08-2014 09:29 AM
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?
06-10-2014 11:07 PM
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
06-11-2014 02:53 AM
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
06-11-2014 03:33 AM
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
06-11-2014 07:53 AM
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.