brarchive not backing up offline redo log on RAC

[Former Member]

Hi all Oracle and SAP experts,

After running brarchive on my newly setup RAC system, the program reports that there are 'No offline redo log files found for processing'. Hence, non of the archive log files are being backup.

Tons of archive log files are generated in the archive log directory. I do not understand why brarchive is unable to locate these files.

There are 2 Windows RAC nodes. I used the command 'brarchive -u / -c force -p initTST.sap -sd' to trigger brarchive. It is using rman to backup to a windows shared folder. And the brbackup runs successfully.

The output from brarchive is below:

-

---

BR0002I BRARCHIVE 7.00 (16)

BR0006I Start of offline redo log processing: aebbxosu.svd 2009-07-24 14.07.36

BR0477I Oracle pfile F:\oracle\TST\102\database\initTST1.ora created from spfile F:\oracle\TST\102\database\spfile.ora

BR0101I Parameters

Name Value

oracle_sid TST1

oracle_home F:\oracle\TST\102

oracle_profile F:\oracle\TST\102\database\initTST1.ora

sapdata_home F:\oracle\TST

sap_profile F:\oracle\TST\102\database\initTST.sap

backup_dev_type disk

archive_copy_dir
10.11.0.101\backup\RAC_test

compress no

disk_copy_cmd rman

cpio_disk_flags -pdcu

rman_compress no

archive_dupl_del only

parallel_instances TST2:F:\oracle\TST\102@TST2

system_info tstadm RACNODE1 Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info TST 10.2.0.4.0 8192 1492 10504542 RACNODE1 UTF8 UTF8

sap_info 620 SAPTST TST D1583565402 R3_ORA 0020087949

make_info NTAMD64 OCI_10201_SHARE Aug 22 2006

command_line brarchive -u / -c force -p initTST.sap -sd

BR0013W No offline redo log files found for processing

BR0007I End of offline redo log processing: aebbxosu.svd 2009-07-24 14.07.54

BR0280I BRARCHIVE time stamp: 2009-07-24 14.07.55

BR0004I BRARCHIVE completed successfully with warnings

[Former Member · Accepted solution]

Hi, I have renamed the log and read the rest of the pointers. But still facing the same problem.

Very good note though. Thanks!

Anyway I can have a more detailed log for brarchive or some way I can debug the problem?

[Former Member · Accepted solution]

I had the same problem, but sadly i don't remember how i fixed it. It may well be that the parallel_instances had something to do with it.

You can set the trace level for brarchive. There was a thread lately here, but the only one i found was:

You need to either set the environment variable BR_TRACE=<level>, or specify -TRC <level> at the command line. Check sap note [29321 - Creating traces for BR Tools|https://service.sap.com/sap/support/notes/29321]

Regards, Michael

Edit: found the other thread:

[Former Member]

I had set BR_TRACE to 15 and receive the following in my trace file:

BR0249I BR_TRACE: level 3, function BrCurrRedoGet exit with 0

BR0249I BR_TRACE: level 2, function BrInstCheck exit with -10

BR0248I BR_TRACE: level 2, function BrDiskStatGet entry with '
10.11.0.101\backup\RAC_test'

BR0250I BR_TRACE: level 2, function BrDiskStatGet exit with '19999863332864 9780518486016 9780518486016 9770967198432'

BR0248I BR_TRACE: level 2, function arch_last_get entry with 'F:\oracle\TST\saparch\archTST1.log'

BR0249I BR_TRACE: level 2, function arch_last_get exit with 0

BR0248I BR_TRACE: level 2, function BrArchNameGet entry with '0 TST1'

BR0250I BR_TRACE: level 2, function BrArchNameGet exit with 'G:\oracle\TST\oraarch\681026106_1_0.dbf'

BR0248I BR_TRACE: level 2, function BrNameBuild entry with '41 G:\oracle\TST\oraarch\681026106_1_0.dbf NULL'

BR0250I BR_TRACE: level 2, function BrNameBuild exit with 'G:\oracle\TST\oraarch'

BR0248I BR_TRACE: level 2, function BrFileStatGet entry with 'G:\oracle\TST\oraarch'

BR0250I BR_TRACE: level 2, function BrFileStatGet exit with '39171616256 0'

BR0248I BR_TRACE: level 2, function BrArchExist entry with 'TST1'

BR0248I BR_TRACE: level 3, function BrArchNameGet entry with '987656789 TST1'

BR0250I BR_TRACE: level 3, function BrArchNameGet exit with 'G:\oracle\TST\oraarch\1_1_987656789.dbf'

BR0249I BR_TRACE: level 2, function BrArchExist exit with -3

BR0248I BR_TRACE: level 2, function BrDiskStatGet entry with '
10.11.0.101\backup\RAC_test'

...

BR0248I BR_TRACE: level 2, function BrDbDisconnect entry with 'void'

BR0280I BRARCHIVE time stamp: 2009-07-27 09.41.42

BR0644I BR_TRACE: location BrDbDisconnect-1, SQL statement:

'COMMIT RELEASE'

BR0300I BR_TRACE: SQL code: 0, number of processed rows: 0

BR0248I BR_TRACE: level 3, function BrZombieKill entry with 'void'

BR0250I BR_TRACE: level 3, function BrZombieKill exit with 'void'

BR0249I BR_TRACE: level 2, function BrDbDisconnect exit with 0

BR0013W No offline redo log files found for processing

My current database incarnation is 681026106 but brarchive is searching for archivelog from incarnation 987656789 (1_1_987656789.dbf). As a workaround, I created dummy files (eg. 1_1_987656789.dbf') for each node and managed to trick brarchive into believing these are the real files. Subsequent backup works fine. Thanks Michael!

[Former Member]

I have initially set the parameter as:

parallel_instances = (TST1:F:\oracle\TST\102@TST1, TST2:F:\oracle\TST\102@TST2)

But I have removed TST1 upon reading the below lines from the SAP brtools library:

parallel_instances
This parameter defines the instances running in parallel to the DDB instance.
Caution
The local dedicated database (DDB) instance must not appear in the list of instance descriptions.

I have put the TST1 back and it does not solve the problem.

Thanks for the help Fidel. Pls keep the suggestions coming!

Tzyy Ming

[Former Member]

Did you read SAP Note 490976 - BR013W No offline redo log files found for processing´?

Renaming arch.log might be worth a try.

[Former Member]

---

The following parameters are included in the Oracle init.ora files

-

---

########################################################################

1. This init.ora profile is a transparent copy of Oracle spfile. #

2. It was created by BRARCHIVE at 2009-07-24 14.56.48. #

3. Please do not change this file! Maintain only the spfile. #

4. You can use BRSPACE for the altering of database parameters: #

5. brspace -f dbparam #

########################################################################

*.cluster_database=TRUE

*.db_name='TST'

TST1.instance_name='TST1'

TST2.instance_name='TST2'

TST1.instance_number=1

TST2.instance_number=2

TST1.local_listener='LISTENER_TST_RACNODE1.WORLD'

TST2.local_listener='LISTENER_TST_RACNODE2.WORLD'

*.log_archive_dest='G:\oracle\TST\oraarch'

*.log_archive_format='%r_%t_%s.dbf'

TST1.remote_listener='REMOTE_LISTENER_TST_RACNODE1.WORLD'

TST2.remote_listener='REMOTE_LISTENER_TST_RACNODE2.WORLD'

TST1.service_names='TST1'

TST2.service_names='TST2'

TST1.thread=1

TST2.thread=2

*.undo_management='AUTO'

*.undo_retention=900

TST1.undo_tablespace='PSAPUNDO1'

TST2.undo_tablespace='PSAPUNDO2'

*.undo_tablespace='PSAPUNDO'

*.user_dump_dest='G:\ORACLE\TST\SAPTRACE\USERTRACE'

*.workarea_size_policy='AUTO'

-

---

Thanks in advance for any advice!

[fidel_vales]

hi,

not sure but I'd start with SAP Note Number: 905359 "Using BR* tools for Oracle RAC databases"

you do not fullfill the first point:

> 1. All Oracle instances (including the local instance) is specified in the init<DBSID>.sap profile parameter "parallel_instances".

in your case you only have one instance:

> parallel_instances = (TST2:F:\oracle\TST\102@TST2)

[Former Member]

Hi,

in your parameter log_archive_dest you miss the prefix TSTarch log_archive_dest = <directory>/<file prefix>. in your environment log_archive_dest should be look like G:\oracle\TST\orarch\TSTarch

regards

Abdel

Edited by: Abdelrhani Boukachabine on Aug 14, 2009 2:46 PM

[Former Member]

---

The folllowing is set for initTST.sap

-

---

backup_mode = all

restore_mode = all

backup_type = online

backup_dev_type = disk

backup_root_dir =
10.11.0.101\backup\RAC_test

stage_root_dir =
10.11.0.101\backup\RAC_test

compress = no

compress_cmd = "
rac-ci\sapmnt\TST\SYS\exe\run\mkszip -c $ > $"

uncompress_cmd = "
rac-ci\sapmnt\TST\SYS\exe\run\uncompress -c $ > $"

compress_dir = F:\oracle\TST\sapreorg

archive_function = save_delete

archive_copy_dir =
10.11.0.101\backup\RAC_test

archive_stage_dir =
10.11.0.101\backup\RAC_test

tape_copy_cmd = cpio

disk_copy_cmd = rman

stage_copy_cmd = rcp

pipe_copy_cmd = rsh

cpio_flags = -ovB

cpio_in_flags = -iuvB

cpio_disk_flags = -pdcu

dd_flags = "bs=64k"

dd_in_flags = "bs=64k"

saveset_members = 1

copy_out_cmd = "dd ibs=8k obs=64k of=$"

copy_in_cmd = "dd ibs=64k obs=8k if=$"

rewind = "mt -f $ rewind"

rewind_offline = "mt -f $ offline"

tape_pos_cmd = "mt -f $ fsf $"

tape_size = 100G

exec_parallel = 0

tape_address = /dev/nmt0

tape_address_rew = /dev/mt0

volume_archive = (TSTA01, TSTA02, TSTA03, TSTA04, TSTA05,

TSTA06, TSTA07, TSTA08, TSTA09, TSTA10,

TSTA11, TSTA12, TSTA13, TSTA14, TSTA15,

TSTA16, TSTA17, TSTA18, TSTA19, TSTA20,

TSTA21, TSTA22, TSTA23, TSTA24, TSTA25,

TSTA26, TSTA27, TSTA28, TSTA29, TSTA30)

volume_backup = (TSTB01, TSTB02, TSTB03, TSTB04, TSTB05,

TSTB06, TSTB07, TSTB08, TSTB09, TSTB10,

TSTB11, TSTB12, TSTB13, TSTB14, TSTB15,

TSTB16, TSTB17, TSTB18, TSTB19, TSTB20,

TSTB21, TSTB22, TSTB23, TSTB24, TSTB25,

TSTB26, TSTB27, TSTB28, TSTB29, TSTB30)

expir_period = 30

tape_use_count = 100

parallel_instances = (TST2:F:\oracle\TST\102@TST2)