Offline backup failed with BR0253E errno 13: Permission denied

[Former Member]

Hi All,

Greetings.

We are taking offline backup to disk and backup failing with below error. We are taking backup on our production server. OS is on windows and database is oracle.

R0201I Compressing O:\ORACLE\RRV\SAPDATA1\SR3_1\SR3.DATA1

BR0203I to O:\oracle\RRV\backups\bdyqmger\SR3.DATA1.Z ...

BR0252E Function spawnlp() failed for '( c:\winnt\sapcluster\sapgw30\mkszip -c O:\ORACLE\RRV\SAPDATA1\SR31\SR3.DATA1 > O:\oracle\RRV\backups\bdyqmger\SR3.DATA1.Z ) > O:\oracle\RRV\sapbackup\.bdyqmger.000 2>&1' at location BrProgStart-4

BR0253E errno 13: Permission denied

BR0267E Asynchronous execution of program failed

BR0224E Compressing O:\ORACLE\RRV\SAPDATA1\SR3_1\SR3.DATA1 to O:\oracle\RRV\backups\bdyqmger\SR3.DATA1.Z failed due to previous errors

Full Log:

BR0051I BRBACKUP 7.00 (24)

BR0055I Start of database backup: bdyqmger.afd 2008-08-22 18.44.17

BR0484I BRBACKUP log file: O:\oracle\RRV\sapbackup\bdyqmger.afd

BR0477I Oracle pfile E:\oracle\RRV\102\database\initRRV.ora created from spfile E:\oracle\RRV\102\database\spfileRRV.ora

BR0613I Database instance RRV is shut down

BR0329I Database instance RRV will be opened now

BR0280I BRBACKUP time stamp: 2008-08-22 18.44.21

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

BR0280I BRBACKUP time stamp: 2008-08-22 18.44.23

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRBACKUP time stamp: 2008-08-22 18.44.23

BR0304I Starting and opening database instance RRV ...

BR0280I BRBACKUP time stamp: 2008-08-22 18.44.37

BR0305I Start and open of database instance RRV successful

BR0101I Parameters

Name Value

oracle_sid RRV

oracle_home E:\oracle\RRV\102

oracle_profile E:\oracle\RRV\102\database\initRRV.ora

sapdata_home O:\oracle\RRV

sap_profile E:\oracle\RRV\102\database\initRRV_file.sap

backup_mode ALL

backup_type offline

backup_dev_type disk

backup_root_dir O:\oracle\RRV\backups

compress yes

compress_cmd c:\winnt\sapcluster\sapgw30\mkszip -c $ > $

exec_parallel 8

system_info rrvadm BP1XEUIS341 Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info RRV 10.2.0.2.0 8192 3807 90260895 BP1XEUIS341 UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003RRV0011X13377684030013NetWeaver_ORA

make_info NTAMD64 OCI_10201_SHARE Mar 19 2007

command_line brbackup -p initRRV_file.sap -d disk -t offline -m all -k yes -e 8 -l E -U

BR0116I ARCHIVE LOG LIST before backup for database instance RRV

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination K:\oracle\RRV\oraarch\RRVarch

Archive format ARC%S_%R.%T

Oldest online log sequence 3800

Next log sequence to archive 3807

Current log sequence 3807 SCN: 90260895

Database block size 8192 Thread: 1

Current system change number 90269883 ResetId: 649429988

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize

PSAPSR3 ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3_1\SR3.DATA1 6710894592 4 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3 ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3_2\SR3.DATA2 6920609792 5 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3 ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3_3\SR3.DATA3 7759470592 6 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3 ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3_4\SR3.DATA4 6291464192 7 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3 ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3_5\SR3.DATA5 6501179392 8 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3 ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3_6\SR3.DATA6 6920609792 9 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3700 ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3700_1\SR3700.DATA1 5452603392 10 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3700 ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3700_2\SR3700.DATA2 5452603392 11 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3700 ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3700_3\SR3700.DATA3 5452603392 12 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3700 ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3700_4\SR3700.DATA4 5662318592 13 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3DB ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3DB_1\SR3DB.DATA1 2097160192 15 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3DB ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3DB_2\SR3DB.DATA2 2097160192 16 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3DB ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3DB_3\SR3DB.DATA3 1048584192 17 14 NOLINK FILE 10485760000 209715200 8192

PSAPSR3USR ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA1\SR3USR_1\SR3USR.DATA1 104865792 14 14 NOLINK FILE 10485760000 209715200 8192

PSAPTEMP ONLINE# ONLINE+ N:\ORACLE\RRV\SAPDATA2\TEMP_1\TEMP.DATA1 6291464192 -1 13 NOLINK FILE 10485760000 209715200 8192

PSAPUNDO ONLINE- ONLINE+ N:\ORACLE\RRV\SAPDATA3\UNDO_1\UNDO.DATA1 6291464192 2 13 NOLINK FILE 10485760000 209715200 8192

SYSAUX ONLINE* ONLINE+ O:\ORACLE\RRV\SAPDATA4\SYSAUX_1\SYSAUX.DATA1 524296192 3 14 NOLINK FILE 10485760000 209715200 8192

SYSTEM ONLINE* SYSTEM+ O:\ORACLE\RRV\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 1048584192 1 14 NOLINK FILE 10485760000 209715200 8192

BR0119I Redo log files

File Size Group Device Status Link Type

M:\ORACLE\RRV\MIRRLOGA\LOG_G11M2.DBF 94372352 1 12 INUSE NOLINK FILE

L:\ORACLE\RRV\ORIGLOGA\LOG_G11M1.DBF 94372352 1 11 INUSE NOLINK FILE

M:\ORACLE\RRV\MIRRLOGB\LOG_G12M2.DBF 94372352 2 12 INUSE NOLINK FILE

L:\ORACLE\RRV\ORIGLOGB\LOG_G12M1.DBF 94372352 2 11 INUSE NOLINK FILE

M:\ORACLE\RRV\MIRRLOGA\LOG_G13M2.DBF 94372352 3 12 INUSE NOLINK FILE

L:\ORACLE\RRV\ORIGLOGA\LOG_G13M1.DBF 94372352 3 11 INUSE NOLINK FILE

M:\ORACLE\RRV\MIRRLOGB\LOG_G14M2.DBF 94372352 4 12 INUSE NOLINK FILE

L:\ORACLE\RRV\ORIGLOGB\LOG_G14M1.DBF 94372352 4 11 INUSE NOLINK FILE

M:\ORACLE\RRV\MIRRLOGA\LOG_G15M2.DBF 94372352 5 12 INUSE NOLINK FILE

L:\ORACLE\RRV\ORIGLOGA\LOG_G15M1.DBF 94372352 5 11 INUSE NOLINK FILE

M:\ORACLE\RRV\MIRRLOGB\LOG_G16M2.DBF 94372352 6 12 STALE NOLINK FILE

L:\ORACLE\RRV\ORIGLOGB\LOG_G16M1.DBF 94372352 6 11 STALE NOLINK FILE

M:\ORACLE\RRV\MIRRLOGA\LOG_G17M2.DBF 94372352 7 12 INUSE NOLINK FILE

L:\ORACLE\RRV\ORIGLOGA\LOG_G17M1.DBF 94372352 7 11 INUSE NOLINK FILE

M:\ORACLE\RRV\MIRRLOGB\LOG_G18M2.DBF 94372352 8 12 INUSE NOLINK FILE

L:\ORACLE\RRV\ORIGLOGB\LOG_G18M1.DBF 94372352 8 11 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

L:\oracle\RRV\origlogA\cntrl\cntlrRRV.dbf 32391168 0 11 NOLINK FILE

K:\oracle\RRV\oraarch\cntrl\cntrlRRV.dbf 32391168 0 10 NOLINK FILE

O:\oracle\RRV\sapdata1\cntrl\cntrlRRV.dbf 32391168 0 14 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:

PSAPSR3, PSAPSR3700, PSAPSR3USR

BR0280I BRBACKUP time stamp: 2008-08-22 18.44.43

BR0057I Backup of database: RRV

BR0058I BRBACKUP action ID: bdyqmger

BR0059I BRBACKUP function ID: afd

BR0110I Backup mode: ALL

BR0077I Database files for backup:

M:\ORACLE\RRV\MIRRLOGA\LOG_G11M2.DBF

M:\ORACLE\RRV\MIRRLOGB\LOG_G12M2.DBF

M:\ORACLE\RRV\MIRRLOGA\LOG_G13M2.DBF

M:\ORACLE\RRV\MIRRLOGB\LOG_G14M2.DBF

M:\ORACLE\RRV\MIRRLOGA\LOG_G15M2.DBF

M:\ORACLE\RRV\MIRRLOGB\LOG_G16M2.DBF

M:\ORACLE\RRV\MIRRLOGA\LOG_G17M2.DBF

M:\ORACLE\RRV\MIRRLOGB\LOG_G18M2.DBF

L:\oracle\RRV\origlogA\cntrl\cntlrRRV.dbf

BR0061I 27 files found for backup, total size 79551.035 MB

BR0143I Backup type: offline

BR0111I Files will be compressed

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory: O:\oracle\RRV\backups\bdyqmger

BR0140I Number of parallel copy processes: 8

BR0064I Database instance RRV will be shut down now

BR0280I BRBACKUP time stamp: 2008-08-22 18.44.43

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

BR0280I BRBACKUP time stamp: 2008-08-22 18.44.56

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0370I Directory O:\oracle\RRV\backups\bdyqmger created

BR0202I Saving init_ora

BR0203I to O:\oracle\RRV\backups\RRV ...

BR0202I Saving E:\oracle\RRV\102\database\initRRV_file.sap

BR0203I to O:\oracle\RRV\backups\RRV ...

BR0280I BRBACKUP time stamp: 2008-08-22 18.44.56

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2008-08-22 18.44.56

BR0307I Shutting down database instance RRV ...

BR0280I BRBACKUP time stamp: 2008-08-22 18.45.15

BR0308I Shutdown of database instance RRV successful

BR0201I Compressing O:\ORACLE\RRV\SAPDATA1\SR3_1\SR3.DATA1

BR0203I to O:\oracle\RRV\backups\bdyqmger\SR3.DATA1.Z ...

BR0252E Function spawnlp() failed for '( c:\winnt\sapcluster\sapgw30\mkszip -c O:\ORACLE\RRV\SAPDATA1\SR31\SR3.DATA1 > O:\oracle\RRV\backups\bdyqmger\SR3.DATA1.Z ) > O:\oracle\RRV\sapbackup\.bdyqmger.000 2>&1' at location BrProgStart-4

BR0253E errno 13: Permission denied

BR0267E Asynchronous execution of program failed

BR0224E Compressing O:\ORACLE\RRV\SAPDATA1\SR3_1\SR3.DATA1 to O:\oracle\RRV\backups\bdyqmger\SR3.DATA1.Z failed due to previous errors

BR0280I BRBACKUP time stamp: 2008-08-22 18.45.19

BR0304I Starting and opening database instance RRV ...

BR0280I BRBACKUP time stamp: 2008-08-22 18.45.32

BR0305I Start and open of database instance RRV successful

BR0280I BRBACKUP time stamp: 2008-08-22 18.45.34

BR0307I Shutting down database instance RRV ...

BR0280I BRBACKUP time stamp: 2008-08-22 18.45.52

BR0308I Shutdown of database instance RRV successful

BR0056I End of database backup: bdyqmger.afd 2008-08-22 18.45.15

BR0280I BRBACKUP time stamp: 2008-08-22 18.45.52

BR0054I BRBACKUP terminated with errors

[Former Member]

Hi,

I notice that you ran BRBACKUP with 8 parallel processes (-e 8). If a non-parallel backup works, this makes me think you might actually have a resource problem and the "permission denied" is just misleading (the standard function _spawnlp is not supposed to return that error).

Could you try what happens when you run with a smaller number of parallel processes (-e 2, -e 3, ...) and see whether there is a point at which the error starts appearing? Also, set the BR_TRACE environment variable as per note 029231 to get more detailed output (start with BR_TRACE=3, may need BR_TRACE=7).

Rgds,

Mark

[Former Member]

Hi All,

Thanks for your inputs.

Sorry for my late come back.

The <SID>ADM through which i login and start offline backup using BRTOOLS have all required permission. When i execute backup taking parallel process and run it is failing. But when i run backup without parallel execution (exec_parallel = 0) then backup completed successfully.

I am still not able to run backup using parallel execution. We are on Windows 2003 server with SP2 , Database is Oracle 10.2.0.2.0 and system is SRM 5.0. All this is in cluster MSCS.

Database is clustered in two nodes and services are clustered.

Thanks & Regards

Ravi

[ganesh_s7]

Hi,

See if the logon userid has the full privileges under folders "c:\winnt\sapcluster\sapgw30\" & "O:\oracle\RRV\sapbackup\". If not, give the access.

Check if the logon userid has 'backup operator', 'administrator', 'ora_<sid>_dba' previliges & retry

Rgds

[Former Member]

Hi,

Read the followin link:

Note 1173159 - Warnings of BR*Tools when accessing database directory

Try this out for permision related problems.

Hope it may help you.

Regards,

Keyur Dave