11-25-2013 09:17 AM
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
Solved! Go to Solution.
11-26-2013 03:08 AM
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;
11-25-2013 11:22 AM
Google translation---I need your help, I have a problem with a backup
11-25-2013 11:36 AM
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
11-25-2013 03:28 PM
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,
11-25-2013 09:42 PM
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?
11-26-2013 12:03 AM
sap_stderr.1125113.115905.txt will give us more details ..
11-26-2013 02:37 AM
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
11-26-2013 02:50 AM
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
11-26-2013 03:08 AM
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;
11-29-2013 11:42 AM
Hello Elkhomri,
Any luck is it resolved..Pls keep us posted
12-02-2013 10:55 AM
Thankyou Sri vani it solved my problem
Thanks so much
Regards,
12-02-2013 10:57 AM