BRARCHIVE finished with return code 3

[Former Member]

Dear All,

Currently I m facing an issue related to backup.Im taking currently backup on local disk as the tape library is yet to be configured.I had created the filesystem on the system where i take the backup.I schedule backup offline with the option of -cds option.The backup gets completed with the return code 3

The logs of backup where the error occurs :

-

---

BR0280I BRBACKUP time stamp: 2008-11-13 06.01.22

BR0053I BRBACKUP completed successfully with warnings

BR0280I BRBACKUP time stamp: 2008-11-13 06.01.22

BR0291I BRARCHIVE will be started with options '-U -jid ALGOF20081113040000 -d disk -c force -p initBCD.sap -cds'

BR0280I BRBACKUP time stamp: 2008-11-13 06.01.22

BR0292I Execution of BRARCHIVE finished with return code 3

-

---

I had also tried with the option -s but in this scenario, backup fails and database does not get started .

Kindly suggest for the same.

Thanks in advance.

Regards,

Amit

[markus_doehr2]

you just posted the last lines but the "warning" line mentioned in the logfile is not visible so it's impossible to help you.

Markus

[Former Member]

Dear Markus,

There is no warning .Before the message of error, everything is the backup logs which says that the BRBakup is completed successfully

BR0280I BRBACKUP time stamp: 2008-11-13 06.01.03

BR0063I 44 of 44 files processed - 118959.041 MB of 118959.041 MB done

BR0204I Percentage done: 100.00%, estimated end time: 6:01

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2008-11-13 06.01.05

BR0304I Starting and opening database instance BCD ...

BR0280I BRBACKUP time stamp: 2008-11-13 06.01.21

BR0305I Start and open of database instance BCD successful

BR0117I ARCHIVE LOG LIST after backup for database instance BCD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/BCD/oraarch/BCDarch

Archive format %t_%s_%r.dbf

Oldest online log sequence 3785

Next log sequence to archive 3788

Current log sequence 3788 SCN: 50263404

Database block size 8192 Thread: 1

Current system change number 50280381 ResetId: 668619897

BR0202I Saving space_log

BR0203I to /backup2/BCD ...

BR0202I Saving /oracle/BCD/sapbackup/bdzgaibc.afd

BR0203I to /backup2/BCD ...

BR0202I Saving /oracle/BCD/sapbackup/backBCD.log

BR0203I to /backup2/BCD ...

BR0115I Compression rate for all files 4.0020:1

BR0056I End of database backup: bdzgaibc.afd 2008-11-13 06.01.21

BR0280I BRBACKUP time stamp: 2008-11-13 06.01.22

BR0053I BRBACKUP completed successfully with warnings

BR0280I BRBACKUP time stamp: 2008-11-13 06.01.22

BR0291I BRARCHIVE will be started with options '-U -jid ALGOF20081113040000 -d disk -c force -p initBCD.sap -cds'

BR0280I BRBACKUP time stamp: 2008-11-13 06.01.22

BR0292I Execution of BRARCHIVE finished with return code 3

Please find the logs.Hope this could help to understand the issue better way.

Thanks in advance.

Regards,

Amit

[markus_doehr2]

> There is no warning

Well - I wonder why brbackup then tells that there is

Check the logfiles for lines starting with

BR

and containing a "W" after the number.

Markus

[former_member204746]

in your saparch directory, check for the latest *.cds file, this is where you have your warning.

[Former Member]

Dear Eric,

Thanks for the reply,

But there is no cds file has been generated in the system.I checked in all the possible directories.

Please suggest for the same.

Regards,

Amit

[former_member204746]

connect on Unix as sidadm, then try to this command from prompt:

brarchive -V

This must work. file must exist, be in the path and have proper permissions.