cancel
Showing results for 
Search instead for 
Did you mean: 

Netbackup error 6 for sap online backup

ELKHOMRI
Level 3
Partner Accredited

Bonjour ,

j ai besoin de votre aide , j'ai un probleme de sauvegarde d'un serveur media SAP ,

03/11/2013 06:21:16 - Info nbjm(pid=6952) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=32140, request id:{7C4850D7-7176-47FF-B2DD-D3F06CF55BD4}) 

03/11/2013 06:21:16 - requesting resource sapbwprod-hcart2-robot-tld-1

03/11/2013 06:21:16 - requesting resource bkp-srv1.NBU_CLIENT.MAXJOBS.sapbwprod

03/11/2013 06:21:16 - requesting resource bkp-srv1.NBU_POLICY.MAXJOBS.sapbwprod_online_backup

03/11/2013 06:21:16 - granted resource bkp-srv1.NBU_CLIENT.MAXJOBS.sapbwprod

03/11/2013 06:21:16 - granted resource bkp-srv1.NBU_POLICY.MAXJOBS.sapbwprod_online_backup

03/11/2013 06:21:16 - granted resource sapbwprod-hcart2-robot-tld-1

03/11/2013 06:21:16 - estimated 0 Kbytes needed

03/11/2013 06:21:16 - Info nbjm(pid=6952) started backup job for client sapbwprod, policy sapbwprod_online_backup, schedule Full on storage unit sapbwprod-hcart2-robot-tld-1

03/11/2013 06:21:18 - Info bpbrm(pid=7672) sapbwprod is the host to backup data from    

03/11/2013 06:21:18 - Info bpbrm(pid=7672) reading file list from client       

03/11/2013 06:21:18 - started process bpbrm (7672)

03/11/2013 06:21:18 - connecting

03/11/2013 06:21:19 - Info bpbrm(pid=7672) starting bphdb on client        

03/11/2013 06:21:19 - Info bphdb(pid=8048) Backup started           

03/11/2013 06:21:19 - connected; connect time: 00:00:01

03/11/2013 06:21:26 - Error bpbrm(pid=7672) from client sapbwprod: ERR - Script <"C:\Scripts\sap-online-backup.cmd"> failed with status: <1> 

03/11/2013 06:21:26 - Error bpbrm(pid=7672) from client sapbwprod: ERR - bphdb exit status = 6: the backup failed to back up the requested files    

03/11/2013 06:21:27 - end writing

the backup failed to back up the requested files(6)

 

 

 

Merci

1 ACCEPTED SOLUTION

Accepted Solutions

sri_vani
Level 6
Partner

Its already in backup mode.

looks it got locked in backup mode...ask ur dba to release the table space which gt locked and try the backup.


BR0328E Database file F:\ORACLE\J12\SAPDATA3\SR3700_1\SR3700.DATA1 of tablespace PSAPSR3700 is already in backup status
BR0328E Database file F:\ORACLE\J12\SAPDATA3\SR3700_2\SR3700.DATA2 of tablespace PSAPSR3700 is already in backup status
BR0328E Database file F:\ORACLE\J12\SAPDATA3\SR3700_3\SR3700.DATA3 of tablespace PSAPSR3700 is already in backup status
 

Please ask ur DBA to verify this link: http://scn.sap.com/thread/1682898

To remove the lock:,

Login to your database.--->go to command prompt(windows) or shell(Unix/linux) using sidadm.

sqlplus /nolog

SQL> Connect /as sysdba

SQL> ALTER DATABASE END BACKUP;

 

View solution in original post

11 REPLIES 11

sri_vani
Level 6
Partner

Google translation---I need your help, I have a problem with a backup

sri_vani
Level 6
Partner

se trata de una nueva configuración?
tenía que completar cualquier momento?
puede usted por favor envíenos bphdb log desde el cliente

¿Cuáles son las versiones de servidor de NetBackup, cliente, servidor y Oracle

 

is it a new configuration
did it complete any time
can you please send us bphdb log from client
what are the netbackup server,client,server,and oracle versions

 

ELKHOMRI
Level 3
Partner Accredited

not this is a former confuguration she worked without problem already

version: - client netbackup 7.1 windows 2003 server

             -server netbackup 7.1 windows 2088 server

-bphdb log from client:

11:59:05.611 [7136.5224] <2> logparams: -sb -rdbms sap -S bkp-srv1 -to 300 -c sapbwprod_online_backup -s Full -clnt sapbwprod -FULL -kl 15 -b sapbwprod_1385380739 -jobid 34172 -shm
11:59:05.892 [7136.5224] <4> bphdb: Module: libncf, Release: 7.1 , Build: 02/03/2011 12:50:00 CST (20110203)
11:59:05.908 [7136.5224] <4> bphdb: Windows version: 5.2.3790, Platform: 2 (Service Pack 2), Service pack: 2.0, Suite: 274, Product type: 3
11:59:05.908 [7136.5224] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 16, Process level: 8664, Processor revision: 6
11:59:05.923 [7136.5224] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
11:59:05.923 [7136.5224] <4> bphdb: INF - setenv SAP_POLICY=sapbwprod_online_backup
11:59:05.923 [7136.5224] <4> bphdb: INF - setenv SAP_SNC_SCHED=Full
11:59:05.923 [7136.5224] <4> bphdb: INF - setenv SAP_SERVER=bkp-srv1
11:59:05.923 [7136.5224] <4> bphdb: INF - setenv SAP_CLIENT=sapbwprod
11:59:05.923 [7136.5224] <4> bphdb: INF - setenv SAP_FULL=1
11:59:05.923 [7136.5224] <4> bphdb: INF - setenv SAP_INCR=0
11:59:05.923 [7136.5224] <4> bphdb: INF - setenv SAP_CINC=0
11:59:05.923 [7136.5224] <4> bphdb: INF - setenv SAP_USER_INITIATED=0
11:59:05.923 [7136.5224] <4> bphdb: INF - setenv SAP_SCHEDULED=1
11:59:05.923 [7136.5224] <4> bphdb: INF - BACKUP START 7136
11:59:05.939 [7136.5224] <4> bphdb: INF - CONTINUE BACKUP message received

11:59:06.001 [7136.5224] <4> bphdb: INF - Processing "C:\Scripts\sap-online-backup.cmd"
11:59:06.033 [7136.7384] <4> bphdb: Process 4044, command '"C:\Scripts\sap-online-backup.cmd"', started
11:59:14.048 [7136.7384] <4> bphdb: Process 4044 command '"C:\Scripts\sap-online-backup.cmd"', completed with status 0
11:59:15.001 [7136.5224] <4> bphdb: INF - command successfully initiated
11:59:15.001 [7136.5224] <16> bphdb: ERR - Script <"C:\Scripts\sap-online-backup.cmd"> failed with status: <1>
11:59:15.001 [7136.5224] <16> bphdb: ERR - for detail output information check file  <C:\Program Files\Veritas\NetBackup\Logs\bphdb\sap_stdout.1125113.115905.txt>
11:59:15.001 [7136.5224] <16> bphdb: ERR - for detail error information check file  <C:\Program Files\Veritas\NetBackup\Logs\bphdb\sap_stderr.1125113.115905.txt>
11:59:15.001 [7136.5224] <16> bphdb: ERR - bphdb exit status = 6: the backup failed to back up the requested files

11:59:15.001 [7136.5224] <4> bphdb: INF - EXIT STATUS 6: the backup failed to back up the requested files

 

Thanks,

 

 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Script <"C:\Scripts\sap-online-backup.cmd"> failed with status: <1>

This log merely says that the script exited with status 1.
You need to check the script output file.

 

Have you seen this?

bphdb: ERR - for detail error information check file 
<C:\Program Files\Veritas\NetBackup\Logs\bphdb\sap_stderr.1125113.115905.txt>

 

Have you checked this txt file?

Have you asked the dba to check the script? 

 

sri_vani
Level 6
Partner

sap_stderr.1125113.115905.txt will give us more details ..

ELKHOMRI
Level 3
Partner Accredited

 

sap_stderr.1125113.115905.txt file is empty

below the detailed file sap_stdout.1125113.115905.txt :

SAP_SCHEDULED = 1
SAP_USER_INITIATED = 0
SAP_SERVER = bkp-srv1
SAP_POLICY = sapbwprod_online_backup
SAP_SCHED =
SAP_SNC_SCHED = Full
BR0051I BRBACKUP 7.00 (32)
BR0055I Start of database backup: bempqhuw.anf 2013-11-25 11.59.06
BR0484I BRBACKUP log file: F:\oracle\J12\sapbackup\bempqhuw.anf
BR0477I Oracle pfile D:\oracle\J12\102\database\initJ12.ora created from spfile D:\oracle\J12\102\database\spfileJ12.ora

BR0280I BRBACKUP time stamp: 2013-11-25 11.59.11
BR0319I Control file copy created: F:\oracle\J12\sapbackup\CNTRLJ12.DBF 23904256
BR0328E Database file F:\ORACLE\J12\SAPDATA3\SR3700_1\SR3700.DATA1 of tablespace PSAPSR3700 is already in backup status
BR0328E Database file F:\ORACLE\J12\SAPDATA3\SR3700_2\SR3700.DATA2 of tablespace PSAPSR3700 is already in backup status
BR0328E Database file F:\ORACLE\J12\SAPDATA3\SR3700_3\SR3700.DATA3 of tablespace PSAPSR3700 is already in backup status

BR0056I End of database backup: bempqhuw.anf 2013-11-25 11.59.11
BR0280I BRBACKUP time stamp: 2013-11-25 11.59.11
BR0054I BRBACKUP terminated with errors
Execution of BRBACKUP command failed - exiting

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Speak to dba to find out if they are also doing local dumps to disk.

The problem is clear in the log:

BR0328E Database file F:\ORACLE\J12\SAPDATA3\SR3700_1\SR3700.DATA1 of tablespace PSAPSR3700 is already in backup status
BR0328E Database file F:\ORACLE\J12\SAPDATA3\SR3700_2\SR3700.DATA2 of tablespace PSAPSR3700 is already in backup status
BR0328E Database file F:\ORACLE\J12\SAPDATA3\SR3700_3\SR3700.DATA3 of tablespace PSAPSR3700 is already in backup status

sri_vani
Level 6
Partner

Its already in backup mode.

looks it got locked in backup mode...ask ur dba to release the table space which gt locked and try the backup.


BR0328E Database file F:\ORACLE\J12\SAPDATA3\SR3700_1\SR3700.DATA1 of tablespace PSAPSR3700 is already in backup status
BR0328E Database file F:\ORACLE\J12\SAPDATA3\SR3700_2\SR3700.DATA2 of tablespace PSAPSR3700 is already in backup status
BR0328E Database file F:\ORACLE\J12\SAPDATA3\SR3700_3\SR3700.DATA3 of tablespace PSAPSR3700 is already in backup status
 

Please ask ur DBA to verify this link: http://scn.sap.com/thread/1682898

To remove the lock:,

Login to your database.--->go to command prompt(windows) or shell(Unix/linux) using sidadm.

sqlplus /nolog

SQL> Connect /as sysdba

SQL> ALTER DATABASE END BACKUP;

 

sri_vani
Level 6
Partner

Hello Elkhomri,

Any luck is it resolved..Pls keep us posted

ELKHOMRI
Level 3
Partner Accredited

Thankyou Sri vani it solved my problem

Thanks so much

 

Regards,

ELKHOMRI
Level 3
Partner Accredited

Thankyou Marianne van den Berg