cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle DB Backup failing Status 6

Daniel_Be_
Level 4
Partner Accredited

Hello everyone,

 

my Oracle DB Backup is failing with the Statuscode 6. It's an oracle intelligent policy.

Oracle 11.2.0.4

SunOS 5.10

 

The detailed status is the following:

==================================================================  
2/26/2015 11:09:41 AM - Info nbjm(pid=4484) requesting MEDIA_SERVER_ONLY resources from RB for backup job (jobid=12581, request id:{6E0EFB65-5EC8-4FB3-82F1-95F5C8B7C70E})  
2/26/2015 11:09:41 AM - requesting resource DDSU_CB-MAN-006
2/26/2015 11:09:41 AM - requesting resource cb-man-201.server.wie.DOMAIN.local.NBU_POLICY.MAXJOBS.POLICY
2/26/2015 11:09:41 AM - granted resource cb-man-201.server.wie.DOMAIN.local.NBU_POLICY.MAXJOBS.POLICY
2/26/2015 11:09:41 AM - estimated 0 Kbytes needed
2/26/2015 11:09:41 AM - Info nbjm(pid=4484) started backup (backupid=CLIENT_1424945381) job for client CLIENT, policy POLICY, schedule WEEKLY_FULL on storage unit 
2/26/2015 11:09:42 AM - started process bpbrm (37444)
2/26/2015 11:09:44 AM - Info bpbrm(pid=37444) CLIENT is the host to backup data from     
2/26/2015 11:09:44 AM - Info bpbrm(pid=37444) reading file list for client        
2/26/2015 11:09:44 AM - connecting
2/26/2015 11:09:46 AM - Info bpbrm(pid=37444) starting bphdb on client         
2/26/2015 11:09:46 AM - connected; connect time: 0:00:02
2/26/2015 11:09:47 AM - Info bphdb(pid=17676) Backup started           
2/26/2015 11:09:47 AM - Info bphdb(pid=17676) Waiting for the child status        
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF - ************************************************************          
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF - Backup Information:         
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -    Client: CLIENT         
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -    ORACLE_SID: CX1         
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -    ORACLE_HOME: /oracle/CX1/11204         
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -    Offline (Cold) Stream backup requested      
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -    Objects being backed up:       
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -               Whole Database         
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -               Archive Logs         
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -               Control File         
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -    Number of channels to allocate (database): 1    
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -    Number of channels to allocate (archive logs): 1   
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -    Oracle Authentication is being used      
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -    RMAN Default Limits will be used (Database)    
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -    RMAN Default Limits will be used (Archive Logs)   
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -    Backup File Name Formats:       
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -               Database: bk_d%d_u%u_s%s_p%p_t%t         
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -               Archive Log: arch_d%d_u%u_s%s_p%p_t%t        
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF -               Control File: ctrl_d%d_u%u_s%s_p%p_t%t        
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF - End of Backup Information       
2/26/2015 11:09:49 AM - Info bphdb(pid=17676) INF - ************************************************************          
2/26/2015 11:09:50 AM - Error bpbrm(pid=37444) from client CLIENT: ERR - Script exited with status = 1 <the requested operation was partially successful>
2/26/2015 11:09:50 AM - Error bpbrm(pid=37444) from client CLIENT: ERR - bphdb exit status = 6: the backup failed to back up the requested files
2/26/2015 11:09:51 AM - Error bpbrm(pid=37444) cannot send mail to Backup@DOMAIN.com        
2/26/2015 11:09:52 AM - Info bphdb(pid=17676) done. status: 6: the backup failed to back up the requested files 
2/26/2015 11:09:52 AM - end writing
the backup failed to back up the requested files(6)

========================================================================================

Here an output from the latest bpdbsbora:

13:00:13.467 [19223] <2> main bpdbsbora: *****************************.
13:00:13.472 [19223] <2> conf_update_time: ../../libvlibs/nbconf_glue.cpp.429: errno: 2 2 0x00000002
13:00:13.472 [19223] <2> conf_update_time: ../../libvlibs/nbconf_glue.cpp.430: path: /oracle/CX1/bp.conf
13:00:13.473 [19223] <8> main bpdbsbora: Could not get locale, using the C locale
13:00:13.476 [19223] <8> load_name_value: unknown name/value pair <OS_check_password=>
13:00:13.476 [19223] <2> main bpdbsbora: Using Master server name from config: cr-man-201.server.wie.commerzreal.local
13:00:13.482 [19223] <2> vnet_pbxConnect: pbxConnectEx Succeeded
13:00:13.483 [19223] <2> logconnections: BPRD CONNECT FROM 10.1.8.167.43320 TO 10.3.20.63.1556 fd = 5
13:00:13.514 [19223] <2> send_backup_info_to_job_details: Begin progress logging to file BRMJBD6
13:00:13.514 [19223] <2> send_backup_info_to_job_details: **LOCALE ERROR** locale <en_US.ISO8859-15> not found in file </usr/openv/msg/.conf>
13:00:13.520 [19223] <2> ReadULDebugLevel: ReadCfg failed with 6
13:00:13.520 [19223] <2> ReadULDebugLevel: ReadCfg failed with 6
13:00:13.520 [19223] <2> ReadULDebugLevel: ReadCfg failed with 6
13:00:13.529 [19223] <4> ncfLogArgs: VxUL id = 11
13:00:13.530 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.530 [19223] <4> engineMainL1: VxUL id = 4
13:00:13.530 [19223] <4> engineMainL1: VxUL id = 33
13:00:13.530 [19223] <4> engineMainL1: VxUL id = 34
13:00:13.531 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.532 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.532 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.823 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.825 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.826 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.827 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.834 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.835 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.839 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.842 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.843 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.844 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:14.092 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:13.845 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:14.097 [19223] <4> RuntimeLoader::loadInterface: VxUL id = 4
13:00:14.099 [19223] <16> PluginDirector::getPlugin: VxUL id = 29
13:00:15.118 [19223] <16> CFECallback::reportStatus: VxUL id = 5
13:00:15.136 [19223] <16> check_database_state: NBBrowseEngine call failed. Status: 114
13:00:15.136 [19223] <16> main bpdbsbora: Error while checking the database state
13:00:15.142 [19223] <4> main bpdbsbora: Exited with status <1>

 

In my opinion the last three lines are interesting - do you know what the "NBBrowsEngine call failed" means?

 

Thanks in advance!

 

Best regards

3 REPLIES 3

Michael_G_Ander
Level 6
Certified

Your generated script is failing with status 1, the bphdb & dbclient(permission 777) logs might give you an indication of what the problem with the script is.

The Oracle alert log could also be worth a look as it can show issues with permissions in the database, think you need to grant some right for rman/backup in the newer Oracle databases.

 

The standard questions: Have you checked: 1) What has changed. 2) The manual 3) If there are any tech notes or VOX posts regarding the issue

Ahmed_BOUAZIZ
Level 2
Partner Accredited

have you find a solution ?

Thanks

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

This user has not been back to provide any update on this issue.

If you have a similar issue, best to start a new discussion and share all relevant details of your environment.