Whole Database Online + redo log backup error

[Former Member]

Dear all ,

Whole databse online backup has been successfully completed . BRARCHIVE has been failed and I got below error .

BR0252E Function fopen() failed for '/oracle/IRQ/saparch/archIRQ.log' at location arch_copy_delete-6

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/IRQ/saparch/archIRQ.log failed

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

BR0252W Function fopen() failed for '/oracle/IRQ/saparch/archIRQ.log' at location BrCleanup-8

BR0253W errno 13: Permission denied

BR0121W Processing of log file /oracle/IRQ/saparch/archIRQ.log failed

BR0007I End of offline redo log processing: aedhjsia.cds 2010-05-24 11.04.46

BR0280I BRARCHIVE time stamp: 2010-05-24 11.04.46

BR0005I BRARCHIVE terminated with errors

Kindly suggest ,

[Former Member]

Issue has been resolved afte given permission for Oracle/SID/saparch/archIRQ.log (0775)

[Former Member]

hi

what Nike S mentioned abt initializing the tape ,it should work ,also check the parameter expir_period

regards

[former_member204746]

chmod 775 /oracle/IRQ/saparch

good luck.

[Former Member]

Hi Eric ,

The exciting authorizationfor Oracl/IRQ/Saparch is 0777 , Group is dba and owner is Orairq .

Kindly suggest

[Former Member]

Hi ,

Change it to ::

chown orairq:dba saparch

chmod 775 saparch

Thanks..

Mohit

[Former Member]

Hi ,

Change it to ::

chown orairq:dba saparch

chmod 775 saparch

Thanks..

Mohit

[Former Member]

Try changing permissions to the log file:

chmod 775 /oracle/IRQ/saparch/archIRQ.log

chown orairq:sapsys /oracle/IRQ/saparch/archIRQ.log

Best regards

[Former Member]

Dear all ,

I have changed permission for Oracle/IRQ/Saparch = chmod 775 .

Still i got error (BRARCHIVE terminated with errors) and Kindly check the logs

BR0252E Function fopen() failed for '/oracle/IRQ/saparch/archIRQ.log' at location arch_copy_delete-6

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/IRQ/saparch/archIRQ.log failed

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

BR0252W Function fopen() failed for '/oracle/IRQ/saparch/archIRQ.log' at location BrCleanup-8

BR0253W errno 13: Permission denied

BR0121W Processing of log file /oracle/IRQ/saparch/archIRQ.log failed

BR0007I End of offline redo log processing: aedhuetk.cds 2010-05-26 14.21.53

BR0280I BRARCHIVE time stamp: 2010-05-26 14.21.53

BR0005I BRARCHIVE terminated with errors

Regards

[Former Member]

Hello,

Please, try changing permissions to the log file:

chmod 775 /oracle/IRQ/saparch/archIRQ.log

chown orairq:sapsys /oracle/IRQ/saparch/archIRQ.log

Best regards

[Former Member]

Hi Satheesh,

From the error log it is purely a permission issue. Check the below permissions.

chown orairq:dba /oracle/IRQ

chmod 775 /oracle/IRQ

chown -R orairq:dba /oracle/IRQ/saparch

chmod -R 775 /oracle/IRQ/saparch.

Check the umask of the user orairq. it shoud be 022. Check the below command.

orairq> umaks

022.

If it is not set to 022 you can set it in the file /etc/security/user.

Please check the brtools permissions.

Try to run oraroot.sh and saproot.sh. They are present in the in /sapmnt/IRQ/exe directory. Check the below link.

http://help.sap.com/saphelp_nw70/helpdata/en/43/3753c4b87b6025e10000000a422035/content.htm

Thanks,

Nick S

[Former Member]

Dear all ,

I have changed permission for /oracle/IRQ/saparch/archIRQ.log = chmod 775

after I have tried only relog backup , i got the below error .

note : Actual tape for QA server are IRQB02 , IRQB01 . now It show expected tape : IRQA01

BR0130I Backup device type: tape

BR0102I Following backup device will be used: /dev/rmt0.1

BR0103I Following backup volume will be used: IRQA01

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

BR0208I Volume with name IRQA01 required in device /dev/rmt0.1

BR0280I BRARCHIVE time stamp: 2010-05-26 14.58.27

BR0226I Rewinding tape volume in device /dev/rmt0 ...

BR0351I Restoring /oracle/IRQ/sapreorg/.tape.hdr0

BR0355I from /dev/rmt0.1 ...

BR0241I Checking label on volume in device /dev/rmt0.1

BR0216E Wrong volume IRQB02 found in device /dev/rmt0.1, expected: IRQA01

BR0218E Checking label on volume in device /dev/rmt0.1 failed

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

BR0007I End of offline redo log processing: aedhumpv.cds 2010-05-26 14.58.30

BR0280I BRARCHIVE time stamp: 2010-05-26 14.58.30

BR0005I BRARCHIVE terminated with errors

Kindly suggest

[Former Member]

Hi Satheesh,

The tape required for the ARCHIEVE back up is IRQA01.

It is finding the wrong tape IRQB02. Insert the right tape and try to initialise the tape and start the Archieve backup again.

Thanks,

Nick S

[Former Member]

Hi Satheesh,

Try doing an ' Full Database Online + redo log backup' instead of an ' Whole Database Online + redo log backup'.

Let us now if it works. If it doesn't work, please attach all the backup log.

Best regards,

Martina

[Former Member]

Hi ,

The actual tape for QA server for whole Online backup+redulog backp (IRQB02 & IRQB01) .

I dont thing why Its looking for IRQA01.

where can i check the backup with tape config details

Regards

[Former Member]

Hi Satheesh,

after I have tried only relog backup , i got the below error.

note : Actual tape for QA server are IRQB02 , IRQB01 . now It show expected tape : IRQA01.

For the

B ackup the tapes are IRQB02 , IRQB01

A rchieve redo log backup the tape is IRQA01.

Could you please make sure what exactly you are trying to do. Redolog backup or Database backup.

Accordingly, insert the tape and initialise them and start again.

Thanks,

Nick S

[Former Member]

*BR0252E Function fopen() failed for '/oracle/IRQ/saparch/archIRQ.log' at location arch_copy_delete-6

BR0253E errno 13: Permission denied*

It means you dont have write permission on saparch directory. It seems you are on UNIX and just check the write persmission and follow the SAP note given below:

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