brarchive error Access is denied

[Former Member]

Hi,

I am trying to schedule the backup for the archive logs in DB13 and I am getting the error "Access is denied 0 file(s) copied"

I am using NW2004S, Oracle 10.2 on windows. Note that thedatabase backup works fine using DB13, but not the backup for the archive logs. If I run the brtools -> brarchive directly in the server, the backup works fine.

I checked the permissions for sidadm and serviceSID users, and the initSID.SAP file and I can't find the root cause.

Details of the brarchive log:

BR0002I BRARCHIVE 7.00 (24)

BR0006I Start of offline redo log processing: adwofawq.sve 2007-11-09 10.55.32

BR0484I BRARCHIVE log file: E:\oracle\PI7\saparch\adwofawq.sve

BR0477I Oracle pfile C:\oracle\PI7\102\database\initPI7.ora created from spfile C:\oracle\PI7\102\database\spfilePI7.ora

BR0101I Parameters

Name Value

oracle_sid PI7

oracle_home C:\oracle\PI7\102

oracle_profile C:\oracle\PI7\102\database\initPI7.ora

sapdata_home E:\oracle\PI7

sap_profile C:\oracle\PI7\102\database\initPI7.sap

backup_dev_type disk

archive_copy_dir E:\PI7-ARCHIVE-BACKUP

compress no

disk_copy_cmd copy

cpio_disk_flags -pdcu

system_info SAPServicePI7 TWATSPI71001 Windows 5.2 Build 3790 Service Pack 1 Intel

oracle_info PI7 10.2.0.2.0 8192 766 18036311 TWATSPI71001 UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003PI70011E01401198800013NetWeaver_ORA

make_info NTintel OCI_10201_SHARE Mar 20 2007

command_line brarchive -u / -jid LOG__20071109105512 -c force -p initPI7.sap -s -v DISK

BR0280I BRARCHIVE time stamp: 2007-11-09 10.55.34

BR0008I Offline redo log processing for database instance: PI7

BR0009I BRARCHIVE action ID: adwofawq

BR0010I BRARCHIVE function ID: sve

BR0048I Archive function: save

BR0011I 3 offline redo log files found for processing, total size 144.001 MB

BR0112I Files will not be compressed

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory: E:\PI7-ARCHIVE-BACKUP

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

BR0202I Saving init_ora

BR0203I to E:\PI7-ARCHIVE-BACKUP\PI7 ...

BR0278E Command output of 'C: && cd C:\oracle\PI7\102\database && C:\usr\sap\PI7\SYS\exe\uc\NTI386\brtools.exe -f copyfile E:\PI7-ARCHIVE-BACKUP\PI7 initPI7.ora spfilePI7.ora':

Access is denied.

0 file(s) copied.

BR0280I BRARCHIVE time stamp: 2007-11-09 10.55.34

BR0279E Return code from 'C: && cd C:\oracle\PI7\102\database && C:\usr\sap\PI7\SYS\exe\uc\NTI386\brtools.exe -f copyfile E:\PI7-ARCHIVE-BACKUP\PI7 initPI7.ora spfilePI7.ora': 5

BR0222E Copying init_ora to/from E:\PI7-ARCHIVE-BACKUP\PI7 failed due to previous errors

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

BR0007I End of offline redo log processing: adwofawq.sve 2007-11-09 10.55.34

BR0280I BRARCHIVE time stamp: 2007-11-09 10.55.34

BR0005I BRARCHIVE terminated with errors

Please help.

Thanks

Erika B.

[former_member193294 · Accepted solution]

Hi Erika,

DB13 runs under SAPService<SID>, you need configure the file access permissions for this account. Either you run the brtools with wrong account or this account does not have access writes to files/folders.

Check if you can manually copy the files under user account you run brtools to destination folder.

Award if helpful.

Rgds,

Loukas

[Former Member]

Edit the security settings of %ORACLE_HOME%\database and grant Full Control to the local groups ORA_DBA, ORA_OPER, ORA_<SID>_DBA, ORA_<SID>_OPER

peter

[Former Member]

Thank you for your very useful answers.

Loukas, I solved the problem giving the correct permissions to the SAPservice user.

[Former Member]

Hello,

Among so many causes one is due to the patch level of BRTOOLS 7.00;

Pl check the BRTOOLS patch no.

Note 994136 - Backup to hard disk fails with error BR0278E suggests to upgrade the patch level to apply patch 19 for BRTOOLS.

Pl award suitably if resolved

Regards