Full Backup Operation not working

[Former Member]

Hi,

Iu2019m using MAXDB 7.8 and using Dataprotector tool to take full backup. Data Protector toool uses the below commands to take full backup.. but it is giving ERROR saying that

Error: ERR

-24920,ERR_BACKUPOP: backup operation was unsuccessful

The backup tool failed with 2 as sum of exit codes. The database request was canceled and ended with error -903.

*******************************************************************************************

qapaux26# dbmcli -d tvs -u dbm,dbm

dbmcli on tvs>user_logon dbm,dbm

OK

---

dbmcli on tvs>dbm_configset -raw BSI_ENV /var/opt/omni/tmp/TVS.bsi_env

OK

---

dbmcli on tvs>medium_put BACKDP-Data[1]/1 /var/opt/omni/tmp/TVS.BACKDP-Data[1].1 PIPE DATA 0 8 NO NO \"\" BACK

OK

---

dbmcli on tvs>util_connect

OK

---

dbmcli on tvs>backup_start BACKDP-Data[1] DATA

ERR

-24920,ERR_BACKUPOP: backup operation was unsuccessful

The backup tool failed with 2 as sum of exit codes. The database request was canceled and ended with error -903.

Help is much appreciatedu2026could you please help me out if anybody has idea on this..

The same command commands works for MAXDB 7.7 but not for MAXDB 7.8

Regards,

Ranganath

[markus_doehr2]

> Error: ERR

> -24920,ERR_BACKUPOP: backup operation was unsuccessful

> The backup tool failed with 2 as sum of exit codes. The database request was canceled and ended with error -903.

Please check the knldiag/KnlMsg for possible errors.

Markus

[Former Member]

following error found from krlmsg.

It is does not have proper explanation to solve issue.

Error:

-903 Hostfile I/O error

KrlMsg show:

Thread 0x1F Task 269 2010-12-15 16:11:19 RTEIO 112: Open of medium /sapdb/TATA/data/wrk/TVS/data_000 as number 3 for READ successfull

Thread 0x1F Task 269 2010-12-15 16:11:19 RTEIO 112: Open of medium /sapdb/TATA/data/wrk/TVS/arch_000 as number 4 for READ successfull

Thread 0x1F Task 268 2010-12-15 16:11:19 CONNECT 12633: Connect req. (TVS, T268, connection obj. 0xc000018de08ba3e0, Node:'qapaux26', PID: 7256)

Thread 0x1F Task 268 2010-12-15 16:11:19 CONNECT 12651: Connection released (TVS, T268, connection obj. c000018de08ba3e0)

Thread 0x1B Task 300 2010-12-15 16:12:23 ERR RTEIO 113: medium /var/opt/omni/tmp/TVS.BACKDP-Data[1].1 cannot be opened for WRITE access,_FILE=RTEIO_StreamMedium.cpp,_LINE=1261

2010-12-15 16:12:23 ERR RTEIO 65: open of medium /var/opt/omni/tmp/TVS.BACKDP-Data[1].1 was canceled,_FILE=RTEIO_StreamMedium.cpp,_LINE=4804

Thread 0x1B Task 299 2010-12-15 16:12:23 WNG SAVE 52108: canceled by user

Thread 0x1F Task 269 2010-12-15 16:12:23 RTEIO 114: medium /sapdb/TATA/data/wrk/TVS/data_000 with number 3 was closed

Thread 0x1F Task 269 2010-12-15 16:12:23 RTEIO 114: medium /sapdb/TATA/data/wrk/TVS/arch_000 with number 4 was closed

Thread 0x1F Task 269 2010-12-15 16:12:23 ERR SAVE 52012: error occured, basis_err 3700

Thread 0x1F Task 269 2010-12-15 16:12:23 ERR Backup 3: Data backup failed,_FILE=Kernel_Administration.cpp,_LINE=1560

2010-12-15 16:12:23 SrvTasks 17: Servertask Info: because Error in backup task occured

2010-12-15 16:12:23 SrvTasks 10: Job 1 (Backup / Restore Medium Task) [executing] WaitingT269 Result=3700

2010-12-15 16:12:23 KernelComm 6: Error in backup task occured, Error code 3700 "hostfile_error"

2010-12-15 16:12:23 Backup 1: Backupmedium #1 (/var/opt/omni/tmp/TVS.BACKDP-Data[1].1) Could not open stream

2010-12-15 16:12:23 KernelComm 6: Backup error occured, Error code 3700 "hostfile_error"

please help me out.

Edited by: ranganv on Dec 15, 2010 12:12 PM

[markus_doehr2]

> Thread       0x1B Task    300  2010-12-15 16:12:23 ERR RTEIO        113:  medium /var/opt/omni/tmp/TVS.BACKDP-Data[1].1 cannot be opened for WRITE access,_FILE=RTEIO_StreamMedium.cpp,_LINE=1261

It seems DP doesn't create the medium appropriately.

I guess you'll have to ask HP about that problem.

Markus

[Former Member]

Hi Markus Doehr,

Thanks for your information. is it may be Data Protector Configuration issue?

dbmcli on tvs>dbm_configget all

OK

BSI_ENV = /var/opt/omni/tmp/TVS.bsi_env

set_variable_10 = OB2BACKUPAPPNAME=TVS

set_variable_11 = OB2BACKUPHOSTNAME=qapaux26.ind.hp.com

set_variable_12 = OB2OPTS=(null)

I'm new to this work and I'm learning the concepts of maxdb as well as DataProtector and trying to fix this issue. Asper your replay i came to know that DP doesn't create the medium appropriately.. can you just let me know more on this?

if possible just tell me with example how to create medium appropriately?

I'm waiting for your replay.....

Ranganath

[Former Member]

Hi Markus Doehr,

Thanks for your information. is it may be Data Protector Configuration issue?

dbmcli on tvs>dbm_configget all

OK

BSI_ENV = /var/opt/omni/tmp/TVS.bsi_env

set_variable_10 = OB2BACKUPAPPNAME=TVS

set_variable_11 = OB2BACKUPHOSTNAME=qapaux26.ind.hp.com

set_variable_12 = OB2OPTS=(null)

I'm new to this work and I'm learning the concepts of maxdb as well as DataProtector and trying to fix this issue. Asper your replay i came to know that DP doesn't create the medium appropriately.. can you just let me know more on this?

if possible just tell me with example how to create medium appropriately?

I'm resending KnlMsg

*****************************************************************************************************************************

0xc000016740669928, Node:'qapaux26', PID: 6152)

Thread 0x1F Task 269 2010-12-07 12:32:03 Savepoint 1: Savepoint (SaveData) started by T269

Thread 0x1B Task 284 2010-12-07 12:32:03 Pager 20003: SVP(1) Start Write Data

Thread 0x1B Task 284 2010-12-07 12:32:03 Pager 20004: SVP(1) Stop Data IO, Pages: 6 IO: 6

Thread 0x1B Task 284 2010-12-07 12:32:03 Pager 20005: SVP(2) Wait for last synchronizing task: 284

Thread 0x1B Task 284 2010-12-07 12:32:03 Pager 20006: SVP(2) Stop Wait for last synchronizing task, Pages: 0 IO: 0

Thread 0x1B Task 284 2010-12-07 12:32:03 DataCache 4: Mark data pages for savepoint (prepare phase)

Thread 0x1B Task 284 2010-12-07 12:32:03 Pager 20007: SVP(3) Start Write Data

Thread 0x1B Task 284 2010-12-07 12:32:03 Pager 20008: SVP(3) Stop Data IO, Pages: 2 IO: 2

Thread 0x1B Task 284 2010-12-07 12:32:03 Pager 20009: SVP(3) Start Write Converter

Thread 0x1B Task 284 2010-12-07 12:32:03 Pager 20011: SVP(3) Stop Converter IO, Pages: 8 IO: 8

Thread 0x1B Task 284 2010-12-07 12:32:03 DataCache 3: Savepoint with ID 10 completed

Thread 0x1F Task 268 2010-12-07 12:32:03 CONNECT 12633: Connect req. (TVS, T268, connection obj. 0xc00001674089dd38, Node:'qapaux26', PID: 6152)

Thread 0x1F Task 269 2010-12-07 12:32:03 Log 20083: New DBIdentifier set (qapaux26:TVS_20101207_123203)

Thread 0x1F Task 269 2010-12-07 12:32:03 RTEIO 112: Open of medium /sapdb/TATA/data/wrk/TVS/data_000 as number 3 for READ successfull

Thread 0x1F Task 269 2010-12-07 12:32:03 RTEIO 112: Open of medium /sapdb/TATA/data/wrk/TVS/arch_000 as number 4 for READ successfull

Thread 0x1F Task 268 2010-12-07 12:32:04 CONNECT 12651: Connection released (TVS, T268, connection obj. c00001674089dd38)

Thread 0x1B Task 300 2010-12-07 12:33:08 ERR RTEIO 113: medium /var/opt/omni/tmp/TVS.BACKDP-Data[1].1 cannot be opened for WRITE access,_FILE=RTEIO_St

reamMedium.cpp,_LINE=1261

2010-12-07 12:33:08 ERR RTEIO 65: open of medium /var/opt/omni/tmp/TVS.BACKDP-Data[1].1 was canceled,_FILE=RTEIO_StreamMedium.cp

p,_LINE=4804

Thread 0x1B Task 299 2010-12-07 12:33:08 WNG SAVE 52108: canceled by user

Thread 0x1F Task 269 2010-12-07 12:33:08 RTEIO 114: medium /sapdb/TATA/data/wrk/TVS/data_000 with number 3 was closed

Thread 0x1F Task 269 2010-12-07 12:33:08 RTEIO 114: medium /sapdb/TATA/data/wrk/TVS/arch_000 with number 4 was closed

Thread 0x1F Task 269 2010-12-07 12:33:08 ERR SAVE 52012: error occured, basis_err 3700

Thread 0x1F Task 269 2010-12-07 12:33:08 ERR Backup 3: Data backup failed,_FILE=Kernel_Administration.cpp,_LINE=1560

2010-12-07 12:33:08 SrvTasks 17: Servertask Info: because Error in backup task occured

2010-12-07 12:33:08 SrvTasks 10: Job 1 (Backup / Restore Medium Task) [executing] WaitingT269 Result=3700

2010-12-07 12:33:08 KernelComm 6: Error in backup task occured, Error code 3700 "hostfile_error"

2010-12-07 12:33:08 Backup 1: Backupmedium #1 (/var/opt/omni/tmp/TVS.BACKDP-Data[1].1) Could not open stream

2010-12-07 12:33:08 KernelComm 6: Backup error occured, Error code 3700 "hostfile_error"

Thread 0x1F Task 269 2010-12-07 12:33:08 ERR Backup 3: Data backup failed,_FILE=Kernel_Administration.cpp,_LINE=1560

2010-12-07 12:33:08 SrvTasks 17: Servertask Info: because Error in backup task occured

2010-12-07 12:33:08 SrvTasks 10: Job 1 (Backup / Restore Medium Task) [executing] WaitingT269 Result=3700

2010-12-07 12:33:08 KernelComm 6: Error in backup task occured, Error code 3700 "hostfile_error"

2010-12-07 12:33:08 Backup 1: Backupmedium #1 (/var/opt/omni/tmp/TVS.BACKDP-Data[1].1) Could not open stream

2010-12-07 12:33:08 KernelComm 6: Backup error occured, Error code 3700 "hostfile_error"

Thread 0x1F Task 269 2010-12-07 12:33:10 CONNECT 12651: Connection released (TVS, T269, connection obj. c000016740669928)

Thread 0x1F Task 269 2010-12-07 12:47:18 CONNECT 12633: Connect req. (TVS, T269, connection obj. 0xc00001674089dd38, Node:'qapaux26', PID: 5802)

Thread 0x1F Task 269 2010-12-07 12:47:34 Savepoint 1: Savepoint (SaveData) started by T269

Thread 0x1B Task 284 2010-12-07 12:47:34 Pager 20003: SVP(1) Start Write Data

Thread 0x1B Task 284 2010-12-07 12:47:34 Pager 20004: SVP(1) Stop Data IO, Pages: 0 IO: 0

Thread 0x1B Task 284 2010-12-07 12:47:34 Pager 20005: SVP(2) Wait for last synchronizing task: 284

Thread 0x1B Task 284 2010-12-07 12:47:34 Pager 20006: SVP(2) Stop Wait for last synchronizing task, Pages: 0 IO: 0

Thread 0x1B Task 284 2010-12-07 12:47:34 DataCache 4: Mark data pages for savepoint (prepare phase)

Thread 0x1B Task 284 2010-12-07 12:47:34 Pager 20007: SVP(3) Start Write Data

*******************************************************************************************************************************************************

I'm waiting for your replay.....

Ranganath

[Former Member]

Hi Markus,

I think it may be help full for analysis

<MSGL _NO="7225" _PROCESS="13730" _THREAD="0x1F" _TASK="269" _TIME="2010-12-17 13:27:38.000">

<MSG _NO="1" _ID="53000" _COMP="DATACACH" _TEXT="Finish data cache shutdown">

<MSG_ARGS

FILE="MsgOutputLegacy.cpp"

_LINE="57"

_TIME="2010-12-17 13:27:38.000"

_LABEL="DATACACH"

/>

</MSG>

</MSGL>

<MSGL _NO="7226" _PROCESS="13730" _THREAD="0x1F" _TASK="269" _TIME="2010-12-17 13:27:38.000">

<MSG _NO="1" _TYPE="Error" _ID="3" _COMP="Backup" _TEXT="Data backup failed">

<MSG_ARGS

FILE="KernelAdministration.cpp"

_LINE="1560"

_TIME="2010-12-17 13:27:38.000"

_MESSAGEVERSION="1"

/>

</MSG>

<MSG _NO="2" _ID="17" _COMP="SrvTasks" _TEXT="Servertask Info: because $DESCRIPTION$">

<MSG_ARGS

FILE="SrvTasksJob.cpp"

_LINE="117"

_TIME="2010-12-17 13:27:38.000"

_DETAILS="4"

_MESSAGEVERSION="1"

DESCRIPTION="Error in backup task occured"

/>

</MSG>

<MSGD>

<MSG _NO="3" _ID="10" _COMP="SrvTasks" TEXT="Job $JOBID$ ($DESCRIPTION$) [$JOB_STATE$] WaitingT$JOB_WAITING_TASKID$ Result=$JOB_RESULT$">

<MSG_ARGS

FILE="SrvTasksJobBackupRestore.cpp"

_LINE="89"

_TIME="2010-12-17 13:27:38.000"

_MESSAGEVERSION="1"

JOB_ID="1"

DESCRIPTION="Backup / Restore Medium Task"

JOB_STATE="executing"

JOB_WAITING_TASKID="269"

JOB_RESULT="3700"

/>

</MSG>

<MSG _NO="4" _ID="6" _COMP="KernelCommon" TEXT="$TITLE$, Error code $BASISERROR$ &quot;$ERRORTEXT$&quot;">

<MSG_ARGS

FILE="KernelTrace.cpp"

_LINE="219"

_TIME="2010-12-17 13:27:38.000"

_MESSAGEVERSION="1"

TITLE="Error in backup task occured"

BASIS_ERROR="3700"

ERRORTEXT="hostfile_error"

/>

</MSG>

<MSG _NO="5" _ID="1" _COMP="Backup" TEXT="Backupmedium #$BACKUPMEDIA_NO$ ($BACKUP_MEDIUM_NAME$) $ERRORTEXT$">

<MSG_ARGS

_FILE="vkb38.cpp"

_LINE="309"

_TIME="2010-12-17 13:27:38.000"

_MESSAGEVERSION="1"

BACKUP_MEDIA_NO="1"

BACKUP_MEDIUM_NAME="/var/opt/omni/tmp/TVS.BACKDP-Data[1].1"

ERRORTEXT="Could not open stream"

/>

</MSG>

<MSG _NO="6" _ID="6" _COMP="KernelCommon" TEXT="$TITLE$, Error code $BASISERROR$ &quot;$ERRORTEXT$&quot;">

<MSG_ARGS

FILE="KernelTrace.cpp"

_LINE="219"

_TIME="2010-12-17 13:27:38.000"

_MESSAGEVERSION="1"

TITLE="Backup error occured"

BASIS_ERROR="3700"

ERRORTEXT="hostfile_error"

/>

</MSG>

[markus_doehr2]

> I'm new to this work and I'm learning the concepts of maxdb as well as DataProtector and trying to fix this issue.

Since DP creates the pipes and does this apparently not correct there's not much you can do from the database side, it just can't write to the pipe.

I would ask HP if they have a new client that supports MaxDB 7.8.

Markus

[Former Member]

Hi Markus,

I would ask HP if they have a new client that supports MaxDB 7.8.

Any update on this?

Ranganath

[markus_doehr2]

Ehem.. don't know what you expect from me - but I don't work at HP so I can't ask.

Did you open a call and asked them?

Markus