BR017W Offline redo log file %s not found with tape backup

[Former Member]

Hi people,

I am encountering some problems with brarchive, each time it is run it returns the error :BR017W Offline redo log file %s not found . It used to work fine when we used backup to disk medium, and still works. But ever since we moved to a third-party tape backup (symantec), brarchive has always failed. (brbackup works ok).

I have considered the SAP notes 490976 and 17163 and tried some of the possible solutions but problem persists. One of the mentioned scenarios in the notes occurred in the past (e.g, offline redo logs have been deleted in the past).

How can i resolve this problem, please?

Regards,

A.S

[former_member204746]

please supply the first 50 lines of your brarchive log.

[Former Member]

BR0002I BRARCHIVE 7.00 (36)

BR0169I Value 'util_file_online' of parameter/option 'backup_dev_type/-d' ignored for 'brarchive' - 'util_file' assumed

BR0006I Start of offline redo log processing: aeadsybk.sve 2009-03-18 09.57.40

BR0484I BRARCHIVE log file: D:\oracle\DEV\saparch\aeadsybk.sve

BR0477I Oracle pfile D:\oracle\product\10.2.0\db_1\database\initDEV.ora created from spfile D:\oracle\product\10.2.0\db_1\database\spfileDEV.ora

BR0101I Parameters

Name Value

oracle_sid DEV

oracle_home D:\oracle\product\10.2.0\db_1

oracle_profile D:\oracle\product\10.2.0\db_1\database\initDEV.ora

sapdata_home D:\oracle\DEV

sap_profile D:\oracle\product\10.2.0\db_1\database\initDEV.utl

backup_dev_type util_file

util_par_file D:\oracle\product\10.2.0\db_1\database\biparam.ini

system_info SAPServiceDEV DEV Windows 5.2 Build 3790 Service Pack 2, v.4354 Intel

oracle_info DEV 10.2.0.2.0 8192 3405 33085171 DEV UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003DEV0011M10950294020013NetWeaver_ORA

make_info NTintel OCI_10201_SHARE Aug 25 2008

command_line brarchive -u / -jid LOG__20090318095737 -c force -p initDEV.utl -s

BR0017W Offline redo log file 'D:\oracle\DEV\oraarch\DEVARCHARC02635_0666442089.001' not found

BR0017W Offline redo log file 'D:\oracle\DEV\oraarch\DEVARCHARC02636_0666442089.001' not found

BR0017W Offline redo log file 'D:\oracle\DEV\oraarch\DEVARCHARC02637_0666442089.001' not found

"

"

"

BR0017W Offline redo log file 'D:\oracle\DEV\oraarch\DEVARCHARC03385_0666442089.001' not found

BR0017W Offline redo log file 'D:\oracle\DEV\oraarch\DEVARCHARC03386_0666442089.001' not found

BR0017W Offline redo log file 'D:\oracle\DEV\oraarch\DEVARCHARC03387_0666442089.001' not found

BR0280I BRARCHIVE time stamp: 2009-03-18 09.57.47

BR0008I Offline redo log processing for database instance: DEV

BR0009I BRARCHIVE action ID: aeadsybk

BR0010I BRARCHIVE function ID: sve

BR0048I Archive function: save

BR0011I 676 offline redo log files found for processing, total size 31489.646 MB

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0280I BRARCHIVE time stamp: 2009-03-18 09.57.47

BR0229I Calling backup utility with function 'backup'...

BR0278I Command output of 'D:\usr\sap\DEV\SYS\exe\uc\NTI386\backint.exe -u DEV -f backup -i D:\oracle\DEV\saparch\.aeadsybk.lst -t file -p D:\oracle\product\10.2.0\db_1\database\biparam.ini -c':

beerrors_EN.dll - The specified module could not be found.

Please set PATH environment variable with valid beerrors_EN.dll path and rerun the job.

http://entsupport.symantec.com/umi/V-79-57344-57345.

BR0280I BRARCHIVE time stamp: 2009-03-18 09.57.50

BR0279E Return code from 'D:\usr\sap\DEV\SYS\exe\uc\NTI386\backint.exe -u DEV -f backup -i D:\oracle\DEV\saparch\.aeadsybk.lst -t file -p D:\oracle\product\10.2.0\db_1\database\biparam.ini -c': 2

BR0232E 0 of 676 files saved by backup utility

BR0280I BRARCHIVE time stamp: 2009-03-18 09.57.50

BR0231E Backup utility call failed

BR0016I 0 offline redo log files processed, total size 0.000 MB

BR0007I End of offline redo log processing: aeadsybk.sve 2009-03-18 09.57.50

BR0280I BRARCHIVE time stamp: 2009-03-18 09.57.50

BR0005I BRARCHIVE terminated with errors

[former_member204746]

1. you have not installed Oracle with SAPSERVER.CMD, you use SETUP.EXE and you are not using SAP standards. This is probably not causing your issue, though.

2. does directory D:\oracle\DEV\oraarch exist?

3. can you find file DEVARCHARC02635_0666442089.001 elsewhere on your hard disks?

4. read your errors and act accordingly:

beerrors_EN.dll - The specified module could not be found.
Please set PATH environment variable with valid beerrors_EN.dll path and rerun the job.
http://entsupport.symantec.com/umi/V-79-57344-57345.

[Former Member]

Thanks for the feedback.

Directory D:\oracle\DEV\oraarch does exist;

File DEVARCHARC02635_0666442089.001, DEVARCHARC02636_0666442089.001 and DEVARCHARC02637_0666442089.001 were somewhere else on the harddisks. i have returned them to directory D:\oracle\DEV\oraarch.

I'm addressing all the errors, and will act accordingly.

Regards,

[former_member204746]

check your initSID.ora file for log_archive_dest parameter

[Former Member]

log_archive_dest is 'D:\oracle\DEV\oraaarch\DEVarch'.

Regards.

[former_member204746]

where were located the files?

I have a feeling that a DB or Basis admin moved those files on another disk because you were in an archive stuck situation.

[Former Member]

Eric, thanks so far.

If this happened, any other way out?

Regards,