Error in executing redologs back-up

[Former Member]

Hi experts,

We are currently experiencing problem on our redologs backup including check database update stat(DB13). Below is the error message found in DB12 rergarding redologs backup, please help.

BR0002I BRARCHIVE 6.40 (41)

BR0006I Start of offline redo log processing: aecipuui.svd 2010-01-13 13.09.12

BR0484I BRARCHIVE log file: /oracle/PRD/saparch/aecipuui.svd

BR0252E Function fopen() failed for '/oracle/PRD/saparch/.lock.bra' at location bra_run_check-7

BR0253E errno 28: No space left on device

BR0022E Setting of BRARCHIVE lock failed

BR0007I End of offline redo log processing: aecipuui.svd 2010-01-13 13.09.12

BR0280I BRARCHIVE time stamp: 2010-01-13 13.09.13

BR0005I BRARCHIVE terminated with errors

Thanks,

[Former Member]

BR0253E errno 28: No space left on device

check space on saparch mount point....and free-up the space by deleting old redologs or log files.....and re-run the backup.

Regards

Nick Loy

[Former Member]

Hi,

Please check if

/oracle/<SID>saparch directory has write permission to orasid:dba user

and delete the file '/oracle/PRD/saparch/.lock.bra' if it is exists there....

then retry...

I assumed, there is no space issue in "/oracle/PRD/saparch/"

Hope, it will work...

Regards.

Rajesh Narkhede

[Former Member]

Hi Sir Rajesh,

Thanks for your response. I've check permission for /oracle/PRD/saparch and it is ok, while checking with existing .lock.bra on /oracle/PRD/saparch, file does not exist.

Regards,

[Former Member]

Hi,

It is nothing but a permissions issue...

Please check if owner of the BRTOOLs is orasid:dba

brarchive, brbackup, and brconnect have permission 4775:

-rwsrwxr-x ora<sid> sapsys ...

These can be started by the ora<sid> or the <sid>adm OS user.

brrestore, brrecover, brspace, brtools, and sapdba have permission 755:

-rwxr-xr-x <sid>adm sapsys ...

These should only be started by the ora<sid> OS user.

Please refer Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA

Regards.

Rajesh Narkhede

[Former Member]

Hi Sir,

This is to clarify the issue, previously we are running our redologs back-up without any problem until such error on the tape (DAT72) occurs last Monday (see error below).

BR0002I BRARCHIVE 6.40 (41)

BR0006I Start of offline redo log processing: aecikszr.svd 2010-01-12 12.24.19

BR0484I BRARCHIVE log file: /oracle/PRD/saparch/aecikszr.svd

BR0477I Oracle pfile /oracle/PRD/920_64/dbs/initPRD.ora created from spfile /oracle/PRD/920_64/dbs/spfilePRD.ora

BR0101I Parameters

Name Value

oracle_sid PRD

oracle_home /oracle/PRD/920_64

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

sapdata_home /oracle/PRD

sap_profile /oracle/PRD/920_64/dbs/brarchive.sap

backup_dev_type tape

compress hardware

tape_copy_cmd cpio

cpio_flags -ovB

cpio_in_flags -iuvB

rewind tctl -f $ rewind

rewind_offline tctl -f $ offline

tape_size 36864.000 MB

tape_address /dev/rmt1.1

tape_address_rew /dev/rmt1

volume_archive PRDA22

expir_period 30

tape_use_count 100

archive_dupl_del only

system_info oraprd/prdadm PCSSAPPRD AIX 3 5 00C0EADA4C00

oracle_info PRD 9.2.0.7.0 8192 127567 4812197382

sap_info 640 SAPPRD PRD O0508637026 R3_ORA 0020223403

make_info rs6000_64 OCI_920 Jan 6 2007

command_line brarchive -u / -c force -p brarchive.sap -sd -v prda22

BR0105E 0 free backup volumes found, 1 required

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

BR0007I End of offline redo log processing: aecikszr.svd 2010-01-12 12.24.26

BR0280I BRARCHIVE time stamp: 2010-01-12 12.24.26

BR0005I BRARCHIVE terminated with errors

Then we changed tape with a new one and initialized, then run again but we got the same error.. Even running running CheckDB in DB13, we got this error.

Job started

Step 001 started (program RSDBAJOB, variant &0000000001648, user ID PCTIGLAOA)

Execute logical command BRCONNECT On host PCSSAPPRD

Parameters: -u / -c -f check

BR0801I BRCONNECT 6.40 (41)

BR0477I Oracle pfile /oracle/PRD/920_64/dbs/initPRD.ora created from spfile /oracle/PRD/920_64/dbs/spfilePRD.ora

BR0252E Function fopen() failed for '/oracle/PRD/sapcheck/ceciupbb.chk' at location main-9

BR0253E errno 28: No space left on device

BR0121E Processing of log file /oracle/PRD/sapcheck/ceciupbb.chk failed

BR0806I End of BRCONNECT processing: ceciupbb.chk2010-01-14 12.29.33

BR0280I BRCONNECT time stamp: 2010-01-14 12.29.33

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

[Former Member]

can you please paste the output of

1. df -g /

Regards..

Rajesh Narkhede

[Former Member]

Hi Sir,

I can't paste the result here.. would you mind giving me your e-mail address so I can send it there?

Thanks..

[Former Member]

Hi Sir,

I can't paste the result here.. would you mind giving me your e-mail address so I can send it there?

Thanks..

[Former Member]

Hi Sir,

I can't paste the result here.. would you mind giving me your e-mail address so I can send it there?

Thanks..

[Former Member]

Hi,

You can see it in my profile...

Regards.

Rajesh Narkhede

[peter_dzurov]

I would say your saparch directory mount) is full.

Check free space in /oracle/PRD/saparch/