cancel
Showing results for 
Search instead for 
Did you mean: 

db13 back up error BR0278E, BR0279E, BR0222E

Former Member
0 Kudos

Dear basis gurus,

I am attaching the error details, What may be the cause?

-


Detail log: bdvzqlev.afd

-


BR0051I BRBACKUP 7.00 (24)

BR0055I Start of database backup: bdvzqlev.afd 2007-08-24 21.00.01

BR0484I BRBACKUP log file: E:\oracle\KC9\sapbackup\bdvzqlev.afd

BR0252W Function remove() failed for 'D:\oracle\KC9\102\database\sap.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

BR0252W Function remove() failed for 'D:\oracle\KC9\102\database\sap.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR0166I Parameter 'control_files' not found in file D:\oracle\KC9\102\database\initKC9.ora - default assumed

BR0274W File 'D:\oracle\KC9\102\database\CTL1KC9.ORA' not found

BR0101I Parameters

Name Value

oracle_sid KC9

oracle_home D:\oracle\KC9\102

oracle_profile D:\oracle\KC9\102\database\initKC9.ora

sapdata_home E:\oracle\KC9

sap_profile D:\oracle\KC9\102\database\initkc9.sap

backup_mode ALL

backup_type offline_force

backup_dev_type disk

backup_root_dir F:\SAPBACKUPS

compress yes

compress_cmd D:\usr\sap\KC9\SYS\exe\uc\NTAMD64\mkszip -c $ > $

exec_parallel 0

system_info SAPServiceKC9 FCPRDSER Windows 5.2 Build 3790 Service Pack 1 AMD64

oracle_info KC9 10.2.0.2.0 8192 2457 23948128 FCPRDSER UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003KC90011T04721109050013NetWeaver_ORA

make_info NTAMD64 OCI_10201_SHARE Mar 19 2007

command_line brbackup -u / -jid ALGOF20070824210000 -c force -t offline_force -m all -p initkc9.sap -a -c force -p initkc9.sap -s

BR0116I ARCHIVE LOG LIST before backup for database instance KC9

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination G:\oracle\KC9\oraarch\KC9arch

Archive format ARC%S_%R.%T

Oldest online log sequence 2454

Next log sequence to archive 2457

Current log sequence 2457 SCN: 23948128

Database block size 8192 Thread: 1

Current system change number 23956292 ResetId: 616541544

BR0118I Tablespaces and data files

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

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA1\SR3_1\SR3.DATA1 2097160192 4 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA1\SR3_2\SR3.DATA2 2097160192 5 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA1\SR3_3\SR3.DATA3 2097160192 6 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA1\SR3_4\SR3.DATA4 2097160192 7 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA1\SR3_5\SR3.DATA5 2097160192 8 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA2\SR3_10\SR3.DATA10 2097160192 13 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA2\SR3_6\SR3.DATA6 2097160192 9 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA2\SR3_7\SR3.DATA7 2097160192 10 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA2\SR3_8\SR3.DATA8 2097160192 11 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA2\SR3_9\SR3.DATA9 2097160192 12 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA3\SR3_11\SR3.DATA11 2097160192 14 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA3\SR3_12\SR3.DATA12 2097160192 15 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA3\SR3_13\SR3.DATA13 2097160192 16 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA3\SR3_14\SR3.DATA14 2097160192 17 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA3\SR3_15\SR3.DATA15 2097160192 18 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA4\SR3_16\SR3.DATA16 2097160192 19 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA4\SR3_17\SR3.DATA17 2097160192 20 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA4\SR3_18\SR3.DATA18 2097160192 21 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA4\SR3_19\SR3.DATA19 2097160192 22 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA4\SR3_20\SR3.DATA20 2097160192 23 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA1\SR3700_1\SR3700.DATA1 2705334272 24 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA1\SR3700_2\SR3700.DATA2 2684362752 25 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA1\SR3700_3\SR3700.DATA3 2684362752 26 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA1\SR3700_4\SR3700.DATA4 2684362752 27 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA2\SR3700_5\SR3700.DATA5 2684362752 28 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA2\SR3700_6\SR3700.DATA6 2642419712 29 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA2\SR3700_7\SR3700.DATA7 2558533632 30 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA2\SR3700_8\SR3700.DATA8 2495619072 31 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA3\SR3700_10\SR3700.DATA10 2474647552 33 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA3\SR3700_11\SR3700.DATA11 2474647552 34 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA3\SR3700_12\SR3700.DATA12 2495619072 35 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA3\SR3700_9\SR3700.DATA9 2495619072 32 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA4\SR3700_13\SR3700.DATA13 2474647552 36 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA4\SR3700_14\SR3700.DATA14 2537562112 37 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA4\SR3700_15\SR3700.DATA15 2558533632 38 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA4\SR3700_16\SR3700.DATA16 2747277312 39 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA4\SR3DB_1\SR3DB.DATA1 1048584192 41 4 NOLINK FILE 10485760000 20971520 8192

PSAPSR3USR ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA1\SR3USR_1\SR3USR.DATA1 20979712 40 4 NOLINK FILE 10485760000 20971520 8192

PSAPTEMP ONLINE# ONLINE+ E:\ORACLE\KC9\SAPDATA2\TEMP_1\TEMP.DATA1 2097160192 -1 4 NOLINK FILE 10485760000 20971520 8192

PSAPUNDO ONLINE- ONLINE+ E:\ORACLE\KC9\SAPDATA3\UNDO_1\UNDO.DATA1 6039805952 2 4 NOLINK FILE 10485760000 20971520 8192

SYSAUX ONLINE* ONLINE+ E:\ORACLE\KC9\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 272637952 3 4 NOLINK FILE 10485760000 20971520 8192

SYSTEM ONLINE* SYSTEM+ E:\ORACLE\KC9\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 880812032 1 4 NOLINK FILE 10485760000 20971520 8192

BR0119I Redo log files

File Size Group Device Status Link Type

F:\ORACLE\KC9\MIRRLOGA\LOG_G11M2.DBF 52429312 1 5 INUSE NOLINK FILE

E:\ORACLE\KC9\ORIGLOGA\LOG_G11M1.DBF 52429312 1 4 INUSE NOLINK FILE

F:\ORACLE\KC9\MIRRLOGB\LOG_G12M2.DBF 52429312 2 5 INUSE NOLINK FILE

E:\ORACLE\KC9\ORIGLOGB\LOG_G12M1.DBF 52429312 2 4 INUSE NOLINK FILE

F:\ORACLE\KC9\MIRRLOGA\LOG_G13M2.DBF 52429312 3 5 INUSE NOLINK FILE

E:\ORACLE\KC9\ORIGLOGA\LOG_G13M1.DBF 52429312 3 4 INUSE NOLINK FILE

F:\ORACLE\KC9\MIRRLOGB\LOG_G14M2.DBF 52429312 4 5 INUSE NOLINK FILE

E:\ORACLE\KC9\ORIGLOGB\LOG_G14M1.DBF 52429312 4 4 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

D:\oracle\KC9\102\database\CTL1KC9.ORA 8192 0 0 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:

PSAPSR3, PSAPSR3700, PSAPSR3USR

BR0280I BRBACKUP time stamp: 2007-08-24 21.00.02

BR0057I Backup of database: KC9

BR0058I BRBACKUP action ID: bdvzqlev

BR0059I BRBACKUP function ID: afd

BR0110I Backup mode: ALL

BR0077I Database files for backup:

F:\ORACLE\KC9\MIRRLOGA\LOG_G11M2.DBF

F:\ORACLE\KC9\MIRRLOGB\LOG_G12M2.DBF

F:\ORACLE\KC9\MIRRLOGA\LOG_G13M2.DBF

F:\ORACLE\KC9\MIRRLOGB\LOG_G14M2.DBF

BR0061I 46 files found for backup, total size 89560.330 MB

BR0143I Backup type: offline_force

BR0111I Files will be compressed

BR0130I Backup device type: disk

BR0106I Files will be saved on disk in directory: F:\SAPBACKUPS\bdvzqlev

BR0289I BRARCHIVE will be started at the end of processing

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

BR0370I Directory F:\SAPBACKUPS\bdvzqlev created

BR0202I Saving init_ora

BR0203I to F:\SAPBACKUPS\KC9 ...

BR0278E Command output of 'D: && cd D:\oracle\KC9\102\database && D:\usr\sap\KC9\SYS\exe\uc\NTAMD64\brtools.exe -f copyfile F:\SAPBACKUPS\KC9 initKC9.ora spfileKC9.ora':

Access is denied.

0 file(s) copied.

BR0280I BRBACKUP time stamp: 2007-08-24 21.00.02

BR0279E Return code from 'D: && cd D:\oracle\KC9\102\database && D:\usr\sap\KC9\SYS\exe\uc\NTAMD64\brtools.exe -f copyfile F:\SAPBACKUPS\KC9 initKC9.ora spfileKC9.ora': 5

BR0222E Copying init_ora to/from F:\SAPBACKUPS\KC9 failed due to previous errors

BR0056I End of database backup: bdvzqlev.afd 2007-08-24 21.00.02

BR0280I BRBACKUP time stamp: 2007-08-24 21.00.02

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2007-08-24 21.00.02

BR0291I BRARCHIVE will be started with options '-U -jid ALGOF20070824210000 -d disk -c force -p initkc9.sap -s'

BR0280I BRBACKUP time stamp: 2007-08-24 21.00.06

BR0292I Execution of BRARCHIVE finished with return code 1

Regards

Joseph

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi ,

Pls adjust the permissions for the directories like D:\oracle\KC9\102\database etc.

Regards

Umesh

0 Kudos

Hello Joseph,

The user, SAPService<sid> has to be a member of Administrators group. Please check it using:

net localgroup administrators

Regards

Arun

Former Member
0 Kudos

>>>>>>>>>>The user, SAPService<sid> has to be a member of Administrators group. Please check it using:

that is definitely wrong.

Starting with 700 SAPService<SID> is not longer member of the local administrators group!

Peter