cancel
Showing results for 
Search instead for 
Did you mean: 

offline backup with BRTOOLS is failing after sometime

former_member209809
Active Participant
0 Kudos

Dear Experts,

I am scheduling offline backup with BRtools but after sometime is fails. like after 31%

below is error:

BR0202I Saving D:\ORACLE\BED\SAPDATA3\SR3702_10\SR3702.DATA10

BR0203I to G:\BED_BACKUP\bejlprfb\SR3702.DATA10 ...

BR0278E Command output of 'copy D:\ORACLE\BED\SAPDATA3\SR3702_10\SR3702.DATA10 G

:\BED_BACKUP\bejlprfb\SR3702.DATA10':

The parameter is incorrect.

        0 file(s) copied.

BR0280I BRBACKUP time stamp: 2012-09-17 21.56.35

BR0279E Return code from 'copy D:\ORACLE\BED\SAPDATA3\SR3702_10\SR3702.DATA10 G:

\BED_BACKUP\bejlprfb\SR3702.DATA10': 1

BR0222E Copying D:\ORACLE\BED\SAPDATA3\SR3702_10\SR3702.DATA10 to/from G:\BED_BA

CKUP\bejlprfb\SR3702.DATA10 failed due to previous errors

BR0280I BRBACKUP time stamp: 2012-09-17 21.56.40

BR0304I Starting and opening database instance BED ...

BR0280I BRBACKUP time stamp: 2012-09-17 21.57.31

BR0305I Start and open of database instance BED successful

BR0056I End of database backup: bejlprfb.afd 2012-09-17 21.56.35

BR0280I BRBACKUP time stamp: 2012-09-17 21.57.33

BR0054I BRBACKUP terminated with errors

###############################################################################

BR0292I Execution of BRBACKUP finished with return code 5

BR0280I BRTOOLS time stamp: 2012-09-17 21.57.33

BR0668I Warnings or errors occurred - you can continue to ignore them or go back

to repeat the last action

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

and below is log DEV_wo_BED log:

---------------------------------------------------

trc file: "dev_w0", trc level: 1, release: "720"

---------------------------------------------------

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

M sysno      00

M sid        BED

M systemid   562 (PC with Windows NT)

M relno      7200

M patchlevel 0

M patchno    120

M intno      20020600

M make       multithreaded, Unicode, 64 bit, optimized

M profile    \\MUMSAP03\sapmnt\BED\SYS\profile\BED_DVEBMGS00_MUMSAP03

M pid        4352

M

M  kernel runs with dp version 133000(ext=118000) (@(#) DPLIB-INT-VERSION-133000-UC)

M  length of sys_adm_ext is 588 bytes

M  ***LOG Q0Q=> tskh_init, WPStart (Workp. 0 4352) [dpxxdisp.c   1377]

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

M  DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M  DpIPCInit2: read dp-profile-values from sys_adm_ext

M  DpShMCreate: sizeof(wp_adm)                    43024          (2264)

M  DpShMCreate: sizeof(tm_adm)                    5517056          (27448)

M  DpShMCreate: sizeof(wp_ca_adm)                    64000          (64)

M  DpShMCreate: sizeof(appc_ca_adm)          64000          (64)

M  DpCommTableSize: max/headSize/ftSize/tableSize=500/16/584064/584080

M  DpShMCreate: sizeof(comm_adm)                    584080          (1144)

M  DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M  DpShMCreate: sizeof(slock_adm)                    0          (296)

M  DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M  DpShMCreate: sizeof(file_adm)                    0          (80)

M  DpShMCreate: sizeof(vmc_adm)                    0          (2152)

M  DpShMCreate: sizeof(wall_adm)                    (41664/42896/64/192)

M  DpShMCreate: sizeof(gw_adm)          48

M  DpShMCreate: sizeof(j2ee_adm)          3952

M  DpShMCreate: SHM_DP_ADM_KEY                    (addr: 000000000FF00050, size: 6374928)

M  DpShMCreate: allocated sys_adm at 000000000FF00060

M  DpShMCreate: allocated wp_adm_list at 000000000FF03070

M  DpShMCreate: allocated wp_adm at 000000000FF03260

M  DpShMCreate: allocated tm_adm_list at 000000000FF0DA80

M  DpShMCreate: allocated tm_adm at 000000000FF0DAD0

M  DpShMCreate: allocated wp_ca_adm at 00000000104509E0

M  DpShMCreate: allocated appc_ca_adm at 00000000104603F0

M  DpShMCreate: allocated comm_adm at 000000001046FE00

M  DpShMCreate: system runs without slock table

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 00000000104FE7A0

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated gw_adm at 00000000104FE850

M  DpShMCreate: allocated j2ee_adm at 00000000104FE890

M  DpShMCreate: allocated ca_info at 00000000104FF810

M  DpShMCreate: allocated wall_adm at 00000000104FF8A0

M  DpCommAttachTable: attached comm table (header=000000001046FE00/ft=000000001046FE10)

M  DpRqQInit: use protect_queue / slots_per_queue 0 / 2001 from sys_adm

M  rdisp/queue_size_check_value :  -> on,50,30,40,500,50,500,80

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  <ES> EsILock: use spinlock for locking

X  Using implementation view

X  <EsNT> Using memory model view.

M  <EsNT> Memory Reset disabled as NT default

X  ES initialized.

X  mm.dump: set maximum dump mem to 96 MB

M  DpVmcSetActive: set vmc state DP_VMC_NOT_ACTIVE

M Mon Sep 17 20:52:22 2012

M  ThStart: taskhandler started

M  ThInit: initializing DIA work process W0

M Mon Sep 17 20:52:23 2012

M  ThInit: running on host MUMSAP03

M Mon Sep 17 20:52:24 2012

M  calling db_connect ...

B  Loading DB library 'D:\usr\sap\BED\DVEBMGS00\exe\dboraslib.dll' ...

B  Library 'D:\usr\sap\BED\DVEBMGS00\exe\dboraslib.dll' loaded

B  Version of 'D:\usr\sap\BED\DVEBMGS00\exe\dboraslib.dll' is "720.00", patchlevel (0.120)

C  Prepending D:\usr\sap\BED\DVEBMGS00\exe to Path.

C  Register application info.

C  Oracle client version: 10.2.0.2.0, (dbsl 720 090112, UNICODE[2])

C  Detailed Oracle client (patch) info not available.

C  Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

C  Logon as OPS$-user to get SAPSR3's password

C  Connecting as /@BED on connection 0 (nls 0) ... (dbsl 720 090112, UNICODE[2])

C  Attaching to database server BED (con=0, svchp=151D2888, srvhp=151D33C8)

C Mon Sep 17 20:52:25 2012

C  Starting user session: OCISessionBegin(con=0, usr='/', svc=151D2888, srv=151D33C8, usr=07C11538)

C Mon Sep 17 20:52:26 2012

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:

C     ORA-01034: ORACLE not available

C  ORA-27101: shared memory realm does not exist                                            

C  Server handle (con=0,svchp=151D2888,srvhp=151D33C8) detached

C  *** ERROR => CONNECT failed with sql error '1034'

[dbsloci.c    14495]

C  SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=1034.

B  ***LOG BV3=> severe db error 1034      ; work process is stopped [dbsh         1241]

B  ***LOG BY2=> sql error 1034   performing CON [dblink       540]

B  ***LOG BY0=> ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist [dblink       540]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1490]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11319]

M  Info for wp 0

M    pid = 4352

M    severity = 0

M    status = 0

M    stat = WP_NEW

M    waiting_for = NO_WAITING

M    reqtype = DP_RQ_DIAWP

M    act_reqtype = NO_REQTYPE

M    req.req_info =

M    req.tid = -1

M    req.uid = 4294967295

M    req.mode = 255

M    req.len = 0

M    req.rq_id = 65535

M    req.rq_source =

M    last_tid = 0

M    last_uid = 0

M    last_mode = 0

M    act_cs_count = 0

M    csTrack = 0

M    csTrackRwExcl = 0

M    csTrackRwShrd = 0

M    mode_cleaned_counter = 0

M    control_flag = 0

M    int_checked_resource(RFC) = 0

M    ext_checked_resource(RFC) = 0

M    int_checked_resource(HTTP) = 0

M    ext_checked_resource(HTTP) = 0

M    report = >                                        <

M    action = 0

M    tab_name = >                              <

M    attachedVm = no VM

M  ThIErrHandle: current request:

M  -IN-- sender_id ?                 tid  -1    wp_ca_blk   -1      wp_id -1

M  -IN-- action    -                 uid  -1    appc_ca_blk -1      type  -   

M  -IN-- new_stat  NO_CHANGE         mode 255   len         0       rq_id -1

M  *****************************************************************************

M  *

M  *  LOCATION    SAP-Server MUMSAP03_BED_00 on host MUMSAP03 (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Mon Sep 17 20:52:26 2012

M  *  RELEASE     720

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        11600

M  *  COUNTER     1

M  *

M  *****************************************************************************

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrBtcCallLgCl< for event BEFORE_DUMP

M  ThCallHooks: hook >ThrBtcCallLgCl< o.k.

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   844]

M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  303]

M  ThIErrHandle: entering ThSetStatError

M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M  Entering ThReadDetachMode

M  call ThrShutDown (1)...

M  ***LOG Q02=> wp_halt, WPStop (Workp. 0 4352) [dpnttool.c   339]

kindly help me since this is offline backup.

Regards,

Sumit

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sumit,

Could you execute the command at the OS level, below;

copy D:\ORACLE\BED\SAPDATA3\SR3702_10\SR3702.DATA10 G:\BED_BACKUP\bejlprfb\SR3702.DATA10

Best regards,

Orkun Gedik

former_member209809
Active Participant
0 Kudos

Hi Orkun,

Thanks for reply.

I tried copying D:\ORACLE\BED\SAPDATA3\SR3702_10\SR3702.DATA10 to G:/ and got error "File size is too large for destination" i also found that i am getting this error because of destination drive is formatted with FAT32 and source is NTFS so in that case files more than 2GB size can't be copied...so is might be reason for BRtool failure?

Former Member
0 Kudos

Hi,

Yes, it is the root cause. Could you replace tape_copy_cmd = dd, in the "init<DBSID>.sap"? Then, try again?

Best regards,

Orkun Gedik

former_member209809
Active Participant
0 Kudos

Hi,

IT team has replaced HD and now its NTFS. I will try again. I am keeping this thread open and share further issue.

Thanks for your support.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

Please check also on CIO option of filesystem. THanks

Former Member
0 Kudos

Hi Luis,

This is a Windows system, not AIX.

Best regards,

Orkun Gedik

former_member209809
Active Participant
0 Kudos

Hi Orkun,

Thanks for your valuable help.

i need one more help from you

I am trying to upgrade EHP5 with EHPI tool.

When pre check phase is starting i am getting error as  "calling tp.exe failed with error 249".

I have updated kernal to latest release 720 patch 300 and also updated TP ans R3TRAN with 314 patch level still issue persist.

System Details:

Source release EHP5 -destination EHP5(updating EA-HR 600 to EA-HR 605)

OS: windows server 2008 R2 x64

DB: Oracle 11g

Need help.

Thnaks

Sumit

Former Member
0 Kudos

Hi Sumit,

The error indicates that tp is not able to connect to the database. The problem should be caused by the Oracle instant client or DBSL library. Try to update DBSL library, first.

Additionally, could you attach "SAPup.log" and "SAPupchk.log" in the thread, please?

Best regards,

Orkun Gedik

former_member209809
Active Participant
0 Kudos

Hi Sachin,

Here is SLOG extract

ERROR: No connect due to DbSl Load Lib Failure

ERROR: environment variable dbms_type is not set.

ERROR: Connect to BED failed (20120919120750).

ERROR: No connect due to DbSl Load Lib Failure

ERROR: environment variable dbms_type is not set.

ERROR: Connect to BED failed (20120919121857).

and below is SAPehpirv.log

#

# ************************* SAPehpi started in REVOKE mode *************************

# This is SAPehpi release lmt_001 version 40.027 compile time 01:16:19 Jul 27 2012.

# This is UNICODE SAPehpi!

# Running in graphics mode server.

CURRENTPHASE

Execution of REVOKE module "Resets PREPARE" begins at 20120919121924

CURRENTPHASE REV_PRPEXTRACT/RESET_PREPARE

...started at 20120919121924

# Using phase log file 'RESETPRP.LOG'.

# Error message set: 'Cannot create process 'tp\pf=D:\usr\sap\EHPI\EHPI.org\abap\bin\DEFAULT.TPP execdbscript BED -x UVERSRES.TQL': The filename, directory name, or volume label syntax is incorrect.

'

# WARNING: Could not create trouble ticket: Macro 'SAPDERL' not set!

...begin dialogue at 20120919121925

...end dialogue at 20120919121933

..answered at 20120919121933.

-> decided to try again.

CURRENTPHASE REV_PRPEXTRACT/RESET_PREPARE

...started at 20120919121933

# Using phase log file 'RESETPRP.LOG'.

# Error message set: 'Cannot create process 'tp\pf=D:\usr\sap\EHPI\EHPI.org\abap\bin\DEFAULT.TPP execdbscript BED -x UVERSRES.TQL': The filename, directory name, or volume label syntax is incorrect.

'

# WARNING: Could not create trouble ticket: Macro 'SAPDERL' not set!

...begin dialogue at 20120919121934

...end dialogue at 20120919122016

..answered at 20120919122016.

-> decided to exit tool.

#

# ************************* SAPehpi started in REVOKE mode *************************

# This is SAPehpi release lmt_001 version 40.027 compile time 01:16:19 Jul 27 2012.

# This is UNICODE SAPehpi!

# Running in graphics mode server.

# GUI reports feature 'dialogue' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'dialoghelp' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'html' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'console' as 'unknown' level 0, user said 'unknown'.

# GUI reports feature 'progress' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'unitcontrol' as 'enabled' level 3, user said 'unknown'.

# GUI reports feature 'remotecontrol' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'synchronization' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'mid' as 'enabled' level 3, user said 'unknown'.

# GUI reports feature 'evaluation' as 'unknown' level 0, user said 'unknown'.

# DB-functions initialized for 'ORACLE'.

# WARNING: Could not create trouble ticket: Macro 'SAPDERL' not set!

...begin dialogue at 20120919122023

...end dialogue at 20120919130120

#

# ************************* SAPehpi started in REVOKE mode *************************

# This is SAPehpi release lmt_001 version 40.027 compile time 01:16:19 Jul 27 2012.

# This is UNICODE SAPehpi!

# Running in graphics mode server.

# GUI reports feature 'dialogue' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'dialoghelp' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'html' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'console' as 'unknown' level 0, user said 'unknown'.

# GUI reports feature 'progress' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'unitcontrol' as 'enabled' level 3, user said 'unknown'.

# GUI reports feature 'remotecontrol' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'synchronization' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'mid' as 'enabled' level 3, user said 'unknown'.

# GUI reports feature 'evaluation' as 'unknown' level 0, user said 'unknown'.

# DB-functions initialized for 'ORACLE'.

# WARNING: Could not create trouble ticket: Macro 'SAPDERL' not set!

...begin dialogue at 20120919133142

...end dialogue at 20120919133201

..answered at 20120919133201.

-> decided to exit tool.

-> decided to exit revoke action.

#

# ************************* SAPehpi started in REVOKE mode *************************

# This is SAPehpi release lmt_001 version 40.027 compile time 01:16:19 Jul 27 2012.

# This is UNICODE SAPehpi!

# Running in graphics mode server.

# GUI reports feature 'dialogue' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'dialoghelp' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'html' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'console' as 'unknown' level 0, user said 'unknown'.

# GUI reports feature 'progress' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'unitcontrol' as 'enabled' level 3, user said 'unknown'.

# GUI reports feature 'remotecontrol' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'synchronization' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'mid' as 'enabled' level 3, user said 'unknown'.

# GUI reports feature 'evaluation' as 'unknown' level 0, user said 'unknown'.

# DB-functions initialized for 'ORACLE'.

# WARNING: Could not create trouble ticket: Macro 'SAPDERL' not set!

...begin dialogue at 20120919133456

...end dialogue at 20120919134409

#

# ************************* SAPehpi started in REVOKE mode *************************

# This is SAPehpi release lmt_001 version 40.027 compile time 01:16:19 Jul 27 2012.

# This is UNICODE SAPehpi!

# Running in graphics mode server.

# GUI reports feature 'dialogue' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'dialoghelp' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'html' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'console' as 'unknown' level 0, user said 'unknown'.

# GUI reports feature 'progress' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'unitcontrol' as 'enabled' level 3, user said 'unknown'.

# GUI reports feature 'remotecontrol' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'synchronization' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'mid' as 'enabled' level 3, user said 'unknown'.

# GUI reports feature 'evaluation' as 'unknown' level 0, user said 'unknown'.

# DB-functions initialized for 'ORACLE'.

# WARNING: Could not create trouble ticket: Macro 'SAPDERL' not set!

...begin dialogue at 20120919134920

#

# ************************* SAPehpi started in REVOKE mode *************************

# This is SAPehpi release lmt_001 version 40.027 compile time 01:16:19 Jul 27 2012.

# This is UNICODE SAPehpi!

# Running in graphics mode server.

# GUI reports feature 'dialogue' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'dialoghelp' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'html' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'console' as 'unknown' level 0, user said 'unknown'.

# GUI reports feature 'progress' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'unitcontrol' as 'enabled' level 3, user said 'unknown'.

# GUI reports feature 'remotecontrol' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'synchronization' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'mid' as 'enabled' level 3, user said 'unknown'.

# GUI reports feature 'evaluation' as 'unknown' level 0, user said 'unknown'.

# DB-functions initialized for 'ORACLE'.

# WARNING: Could not create trouble ticket: Macro 'SAPDERL' not set!

...begin dialogue at 20120919135432

...end dialogue at 20120919135751

Now when i am restarting tool then i am getting error like

       Checks after phase REV_PRPEXTRACT/RESET_PREPARE were negative!

Last error code set: Cannot open '\': The system cannot find the path specified.

Kindly help

Former Member
0 Kudos

>> ERROR: No connect due to DbSl Load Lib Failure

Check the Note 175627 - tp: Test import does not work (load lib)

Best regards,

Orkun Gedik