on 12-14-2010 3:08 PM
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
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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$ "$ERRORTEXT$"">
<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$ "$ERRORTEXT$"">
<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>
> 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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.