on 07-05-2008 7:11 PM
Hi everybody, I'm trying to backup my systems database, and this error keeps poping up, in diferent systems, please help. Thanks.
BR0202I Saving /oracle/SMP/sapdata4/sr3db_2/sr3db.data2
BR0203I to /respbd/respaldos/respsmp010708/bdyhkgor/sr3db.data2 ...
BR0278E Command output of 'LANG=C cp /oracle/SMP/sapdata4/sr3db_2/sr3db.data2 /respbd/respaldos/respsmp010708/bdyhkgor/sr3db.data2':
cp: cannot close /respbd/respaldos/respsmp010708/bdyhkgor/sr3db.data2: Operation would block
BR0280I BRBACKUP time stamp: 2008-07-05 12.02.43
BR0279E Return code from 'LANG=C cp /oracle/SMP/sapdata4/sr3db_2/sr3db.data2 /respbd/respaldos/respsmp010708/bdyhkgor/sr3db.data2': 1
BR0222E Copying /oracle/SMP/sapdata4/sr3db_2/sr3db.data2 to/from /respbd/respaldos/respsmp010708/bdyhkgor/sr3db.data2 failed due to pre
vious errors
BR0280I BRBACKUP time stamp: 2008-07-05 12.02.46
BR0304I Starting and opening database instance SMP ...
BR0280I BRBACKUP time stamp: 2008-07-05 12.02.59
BR0305I Start and open of database instance SMP successful
BR0056I End of database backup: bdyhkgor.afd 2008-07-05 12.02.43
BR0280I BRBACKUP time stamp: 2008-07-05 12.02.59
BR0054I BRBACKUP terminated with errors
###############################################################################
BR0292I Execution of BRBACKUP finished with return code 5
Buenos Día,
Actualmente, cuando realizamos el backup me presenta un error diciendo que solo copió 116 de 115 ficheros de datos, pero en realidad solo tenemos 115 datafiles en la base de datos y no 116.
Nuestro sistema SAP corre en Solaris 10, plataforma SPARC servidor M4000.
Me gustaría saber de donde saca ese valor (116). También, le pido que me ayuden a solucionar el caso.
Anexo log:
BR0280I BRBACKUP time stamp: 2010-02-22 18.43.59
BR0057I Backup of database: ESP
BR0058I BRBACKUP action ID: becqiavi
BR0059I BRBACKUP function ID: anf
BR0110I Backup mode: ALL
BR0077I Database file for backup: /oracle/ESP/sapbackup/cntrlESP.dbf
BR0061I 116 files found for backup, total size 799083.133 MB
BR0143I Backup type: online
BR0130I Backup device type: util_file
BR0109I Files will be saved by backup utility
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRBACKUP time stamp: 2010-02-22 18.44.04
BR0315I 'Alter database begin backup' successful
BR0280I BRBACKUP time stamp: 2010-02-22 18.44.04
BR0229I Calling backup utility with function 'backup'...
BR0280I BRBACKUP time stamp: 2010-02-22 18.44.08
BR0281W BRBACKUP interrupted by signal 2
BR0269W Wait situation interrupted - probably cannot continue
BR0280I BRBACKUP time stamp: 2010-02-22 18.44.08
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:
BR0280I BRBACKUP time stamp: 2010-02-22 18.44.13
BR0257I Your reply: 's'
BR0260E BRBACKUP cancelled by user
BR0280I BRBACKUP time stamp: 2010-02-22 18.44.16
BR0317I 'Alter database end backup' successful
BR0056I End of database backup: becqiavi.anf 2010-02-22 18.44.14
BR0280I BRBACKUP time stamp: 2010-02-22 18.44.16
BR0054I BRBACKUP terminated with errors
al final muestra:
BR0232E 115 of 116 files saved by backup utility
BR0280I BRBACKUP time stamp: 2010-02-10 14.36.49
BR0231E Backup utility call failed
BR0280I BRBACKUP time stamp: 2010-02-10 14.36.52
BR0317I 'Alter database end backup' successful
BR0056I End of database backup: becnwdvl.anf 2010-02-10 14.36.49
BR0280I BRBACKUP time stamp: 2010-02-10 14.36.53
BR0054I BRBACKUP terminated with errors
Un Saludo,
Rolando.
Edited by: Ava Consulting on Feb 23, 2010 3:34 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes I mounted a NFS filesystem from another server, in both of them I have hp ux 11.31, the share type is Current and Permanent, allow asynchronous writes, with all read-write access. How do I have to configure it?
Thanks alot for your help, I think thats the problem because I tried to do the backup on a local file system in one of my systems and it worked with no problems, thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
/respbd/respaldos/respsmp010708/bdyhkgor/sr3db.data2':
> cp: cannot close /respbd/respaldos/respsmp010708/bdyhkgor/sr3db.data2: Operation would block
Is that maybe an NFS mounted directory? If yes, what OS are you using and what are the mount options you mount that directory?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Markus
Yes I mounted a NFS filesystem from another server, in both of them I have hp ux 11.31, the share type is Current and Permanent, allow asynchronous writes, with all read-write access. How do I have to configure it?
Thanks alot for your help, I think thats the problem because I tried to do the backup on a local file system in one of my systems and it worked with no problems, thanks.
I would switch off the asynchronous write for that NFS mount. It may be slower then but I think that this is the reason for this error. The VFS receives an "OK" (file written) although the actual write is not done thus the access to the move is blocked and brbackup fails.
You can switch that off using sam.
Markus
Hi Markus, that didn't solve my problem, I got the same error, you think that its because the NFS protocol is relatively insecure? Should I try with FTP? What's your suggestion?
What NFS version do you use? NFS is not insecure by nature (well, that´s true for NFSv3 and v4) - ftp is MUCH more insecure because it sends clear text passwords of the network!
Markus
A quick search on HP turned out, that the solution would be to install the new version of ONCPlus (from may 20th!) which can be received for free:
http://software.hp.com/portal/swdepot/displayProductInfo.do?productNumber=ONCplus
The B.11.31.03 version of ONCplus delivers the following new features and defect fixes:
<...>
An NFS close() returns the error message "close: operation would block".
<...>
That seems to be very much your problem.
What version do you have installed?
Markus
Hello. Can you say BRTOOLS(patch level) version, SAP version, Oracle version, and how you want create backup (on hards disk? ) Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.