Warning in Database

[Former Member]

Hi All,

I have warning at database backup. We are using Oracle database. We are planning Whole database online+redo log backup.

Today it encounters warning "Log file: aehxnyrd.cds having return code 0001 success with warning". When I see the details job log it has problem in following

BR0002I BRARCHIVE 7.00 (40)

BR0006I Start of offline redo log processing: aehxnyrd.cds 2012-02-19 00.09.37

BR0484I BRARCHIVE log file: /oracle/PRD/saparch/aehxnyrd.cds

BR0101I Parameters

Name Value

oracle_sid PRD

oracle_home /oracle/PRD/102_64

oracle_profile /oracle/PRD/102_64/dbs/initPRD.ora

sapdata_home /oracle/PRD

sap_profile /oracle/PRD/102_64/dbs/initPRD.sap

backup_dev_type tape

compress no

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iuvB

dd_flags obs=64k bs=64k

dd_in_flags ibs=64k bs=64k

rewind mt -f $ rew

rewind_offline mt -f $ offl

tape_size 22766.281 MB

tape_address /dev/rmt/0mn

tape_address_rew /dev/rmt/0mb

volume_archive SCRATCH

expir_period 30

tape_use_count 100

archive_dupl_del only

system_info prdadm/oraprd prdsrv HP-UX B.11.31 U ia64

oracle_info PRD 10.2.0.4.0 8192 15565 300712697 prdsrv UTF8 UTF8

sap_info 701 SAPSR3 0002LK0003PRD0011K17920579530015Maintenance_ORA

make_info hpia64 OCI_102 Feb 21 2009

command_line /usr/sap/PRD/SYS/exe/run/brarchive +behxnyrd.ant,137189097472,SCRATCH,35:1712 -jid ALLOG20120109233500 -d t

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15516_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15517_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15518_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15519_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15520_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15521_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15522_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15523_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15524_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15525_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15526_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15527_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15528_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15529_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15530_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15531_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15532_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15533_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15534_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15535_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15536_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15537_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15538_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15539_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15540_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15541_703959990.dbf' not found

BR0017W Offline redo log file '/oracle/PRD/oraarch/PRDarch1_15542_703959990.dbf' not found

BR0280I BRARCHIVE time stamp: 2012-02-19 00.09.38

Please help me as early as possible.

Thanks in advance

Regards,

Amit.

Edited by: amit3087 on Feb 19, 2012 7:26 AM

[former_member289242]

Hello Amit,

Using the summary brarchive log arch<sid>.log, brarchive determines as

the number as of which the system is to save the redo logs. The tool

then finds the corresponding files for the offline redo logs in the

directory. This process may fail for different reasons.

1. Corruption in the arch<sid>.log file

2. Incorrect archiving mode

3. Program error in brarchive

4. Database was reset with RESET LOGS

5. Subdirectory in the saparch directory

6. Other warnings are displayed before BR013W

7. Mixing the archiving process (on the hard disk and on tape)

8. Problem with redo log numbers greater than 99999

9. No redo logs available

The warning is the same warning described in note 490976. Would you please check this note accordingly and see if this can help you?

Best Regards,

Gunjan Tomar

[Former Member]

Hi Amit,

Did you manually move the archive logs to some other destination?

If yes, brbackup omits the moved ones and backups the rest which are available in oraarch.

Br,

Venky

[Former Member]

Venky seems right here.

Thanks

[Former Member]

Hi All,

I am not moved any archive logs still this problem occurs.

Actually I have taken backup again this time it completes successfully. I cant understand what is exact problem.

I can`t understand what is exact problem. Can you tell me what is the cause behind this.

Please help me.

Thanks in advance.

Regards,

Amit

[Former Member]

Hi Amit,

The following is the excerpt from the note Note 17163 - BRARCHIVE/BRBACKUP messages and codes

BR0017W Offline redo log file %s not found.
BR0017W Offline-Redo-Log-Datei %s nicht gefunden.
Explanation: This warning informs you that there are gaps in the archiving directory. The database cannot be recovered in such cases if the recovery process is started with an offline redo log file with a smaller log sequence number. Possible causes:

Case 1: Offline redo log files were deleted using operating system utilities before they could be archived, or the ORACLE ARCHIVELOG mode was temporarily deactivated. BRARCHIVE was started with Option -s, -sd, -ss, or -ssd.
Case 2: Offline redo log files were deleted using operating system utilities after they were archived once by BRARCHIVE, but not yet deleted by BRARCHIVE. BRARCHIVE was started with Option -sc, -scd, -ds, or -dc.
Program reaction:  The offline redo log file is ignored.
User action:  Case 1: SAP recommends a full backup of the database. The warning is normally only output once. After at least one archive log with a larger log sequence number was saved, it is automatically suppressed. Therefore in this case action is not necessary.
Case 2: The warning is issued repeatedly when BRARCHIVE is started with Option -sc, -scd, -ds, or -dc. To suppress the message, you have to edit the summary BRARCHIVE log <ORACLE_HOME>/saparch/arch<DBSID>.log.
In the #COPIED and #DELETED lines, which refer to the affected offline redo log files, replace the first character, '#', with '+' or '*'.
Example:
Display before:
#ARCHIVE.. 622  /oracle/C11/saparch/C11arch1_622 1995-03-03 03.36.47
#SAVED.... acovzgvj ssd  #C11A34/13      1995-03- 03 08.05.18
#COPIED... ........ ...  ............... .......... ........
#DELETED.. ........ ...  .......... ........
Display after:
#ARCHIVE.. 622  /oracle/C11/saparch/C11arch1_622 1995-03-03 03.36.47
#SAVED.... acovzgvj ssd  #C11A34/13      1995-03- 03 08.05.18
+COPIED... ........ ...  ............... .......... ........
+DELETED.. ........ ...  .......... ........

The solution provided by SAP should fix the issue.

Please revert in case the issue is not solved. Thanks.

Br,

Venky