Skip to Content
0
Former Member
Jan 14, 2010 at 12:23 PM

Redolog dbf file created in wrong permission

206 Views

Hi Experts

We have installed a new SAP system with oracle in AIX platform. When we checked for the redolog file direcotry it shows as below

-rw------- 1 ora<sid> dba 135168 Jan 13 18:39 <sid>arch1_1441_856886348.dbf

-rw-r----- 1 ora<sid> dba 12865024 Jan 13 21:24 <sid>arch1_1442_856886348.dbf

-rw------- 1 ora<sid> dba 6878720 Jan 13 23:04 <sid>arch1_1443_856886348.dbf

-rw-r----- 1 ora<sid> dba 45330944 Jan 14 07:00 <sid>arch1_1444_856886348.dbf

here u can see one file is written in 600 permission and alternate in 640 permission. when i trigger the archival from orasid user the archival backup is successful. but when i trigger from DB13 it triggered error. I have TDP for taking backup.

I have got the follwoing error

BKI2017I: Blocksize is set to 131072 bytes

BKI0032E: Error opening file /oracle/<SID>/oraarch/<SID>arch1_1432_856886348.dbf: The file access permissions do not allow the specified action.

BKI1200E: Cannot read/write file: /oracle/<SID>/oraarch/<SID>arch1_1432_856886348.dbf.

BR0233E Backup utility has reported an error while saving file /oracle/<SID>/oraarch/<SID>arch1_1432_856886348.dbf

BKI1200E: Cannot read/write file: /oracle/<SID>/oraarch/<SID>arch1_1433_856886348.dbf.

BR0233E Backup utility has reported an error while saving file /oracle/<SID>/oraarch/<SID>arch1_1433_856886348.dbf

BKI1200E: Cannot read/write file: /oracle/<SID>/oraarch/<SID>arch1_1434_856886348.dbf.

BR0233E Backup utility has reported an error while saving file /oracle/<SID>/oraarch/<SID>arch1_1434_856886348.dbf

BKI1200E: Cannot read/write file: /oracle/<SID>/oraarch/<SID>arch1_1435_856886348.dbf.

Because of the dbf file permission the backup is failing in sidadm

Regards

bala