Question Re: BR0279E Return code 5 in Technology Q&A

BR0279E Return code 5

Former Member — Mon, 19 Oct 2020 14:43:39 GMT

Dear All,

sometime ( not always ) backup oracle online_cons goes in error (red alert - return code 5 in dbacockpit ); analyzing the error i found this issue in the related brbackup log file :

BR0202I Saving init_ora BR0203I to B:\oracle\***\sapbackup\*** ... BR0278E Command output of 'K: && cd K:\oracle\***\sapprof && K:\usr\sap\***\SYS\exe\uc\NTAMD64\brtools.exe -f copyfile B:\oracle\***\sapbackup\*** init***.ora spfile***.ora': 1 file(s) copied. The system cannot find the file specified. BR0280I BRBACKUP time stamp: 2020-10-18 21.00.08 BR0279E Return code from 'K: && cd K:\oracle\***\sapprof && K:\usr\sap\***\SYS\exe\uc\NTAMD64\brtools.exe -f copyfile B:\oracle\***\sapbackup\*** init***.ora spfile***.ora': 5 BR0222E Copying init_ora to/from B:\oracle\***\sapbackup\*** failed due to previous errors BR0056I End of database backup: bfexyqfc.and 2020-10-18 21.00.08

*** = <sid del sistema> I have subtituted the SID with ***

Platform oracle/windows

Any Idea to solve this issue ?

Best regards.

Re: BR0279E Return code 5

janos_mucsi-besze — Tue, 20 Oct 2020 08:41:13 GMT

Which Patch Level and Version do you use? There was a Bug in older Patch Levels which failed with this. But now this is already addressed in the latest Patch Level.

In any case, is the permission okay for the spfile? Whoc is starting up the Database Instance and the Windows Service?

Re: BR0279E Return code 5

Former Member — Wed, 21 Oct 2020 12:12:17 GMT

brbackup is version 7220.5.24.10333

Permission are ok . The stranger thing is that some times backup go fine, some times not...

Re: BR0279E Return code 5

janos_mucsi-besze — Mon, 26 Oct 2020 07:19:20 GMT

Hi Tony,

I meant the output of "brtools -V". You should use at least 7.40 Patch Level 40.

example output:

...
release note 1838850
kernel release 740
patch date 2020-06-18
patch level 42
make platform linuxx86_64
make codeline 749_REL
make mode OCI_112
make date Jun 19 2020

Furthermore, do you use BACKINT maybe? Or is there a chance that the file gets locked and moved by any other software?