Hi,
Recently one of our server database went down.
We are having HP OVPI applicaion installed on that, which got
corrupted.
We tried to restore the db using a dmp file as follows,
load database dpipe_db from "/backup/dpipe_db_200801242300.dmp"
The dmp file is of size 13366116352 bytes
But the command doesnt return to the db prompt nor it gives any error.
It is running for a long time even for half a day or more.
Is there any error/transaction log file to check the progress of the
restoration process.
Below is an extract from the error.log file.
Or what could be the problem?
Thanks,
Arun
--------------------------------------------------------------------------------------------------------------------------------------------
************************************
02:00000:00044:2008/01/31 13:57:42.34 kernel SQL causing error :
02:00000:00044:2008/01/31 13:57:42.34 kernel
************************************
02:00000:00044:2008/01/31 13:57:42.34 server SQL Text:
02:00000:00044:2008/01/31 13:57:42.34 kernel curdb = 1 pstat =
0x10000 lasterror = 0
02:00000:00044:2008/01/31 13:57:42.34 kernel preverror = 0 transtate
= 1
02:00000:00044:2008/01/31 13:57:42.38 kernel curcmd = 0 program =
mw_collect
02:00000:00044:2008/01/31 13:57:42.38 kernel pc: 0x66f438 pcstkwalk
+0x3c()
02:00000:00044:2008/01/31 13:57:42.38 kernel pc: 0x66f278
ucstkgentrace+0x210()
02:00000:00044:2008/01/31 13:57:42.38 kernel pc: 0x65cd0c ucbacktrace
+0x88()
02:00000:00044:2008/01/31 13:57:42.38 kernel pc: 0x2b1618
terminate_process+0xa60()
02:00000:00044:2008/01/31 13:57:42.38 kernel pc: 0x686f2c kisignal
+0xb4()
02:00000:00044:2008/01/31 13:57:42.38 kernel pc: 0x7cd068
_sigreturn()
02:00000:00044:2008/01/31 13:57:42.38 kernel [Handler pc: 0x338eac
hdl_backout installed by the following function:-]
02:00000:00044:2008/01/31 13:57:42.38 kernel [Handler pc: 0x470174
ut_handle installed by the following function:-]
02:00000:00044:2008/01/31 13:57:42.38 kernel [Handler pc: 0x470174
ut_handle installed by the following function:-]
02:00000:00044:2008/01/31 13:57:42.38 kernel pc: 0x1bd65c conn_hdlr
+0x440()
02:00000:00044:2008/01/31 13:57:42.38 kernel pc: 0x1bd054 conn_hdlr()
02:00000:00044:2008/01/31 13:57:42.38 kernel end of stack trace, spid
44, kpid 38207614, suid 3
02:00000:00044:2008/01/31 13:57:42.38 kernel Cannot send, host
process disconnected: mgtph002 19725 spid: 44
02:00000:00044:2008/01/31 13:57:42.38 server Error: 1608, Severity:
18, State: 1
02:00000:00044:2008/01/31 13:57:42.38 server A client process exited
abnormally, or a network error was encountered. Unless
other errors occurred, continue processing normally.
03:00000:00044:2008/01/31 13:58:42.46 kernel current process
(0x248007f) infected with 11
03:00000:00044:2008/01/31 13:58:42.46 kernel Error at address
0x1bd65f (conn_hdlr+0x443)
03:00000:00044:2008/01/31 13:58:42.46 kernel
************************************
03:00000:00044:2008/01/31 13:58:42.46 kernel SQL causing error :
03:00000:00044:2008/01/31 13:58:42.46 kernel
************************************
03:00000:00044:2008/01/31 13:58:42.46 server SQL Text:
03:00000:00044:2008/01/31 13:58:42.46 kernel curdb = 1 pstat =
0x10000 lasterror = 0
03:00000:00044:2008/01/31 13:58:42.46 kernel preverror = 0 transtate
= 1
03:00000:00044:2008/01/31 13:58:42.46 kernel curcmd = 0 program =
bcp_gateway
03:00000:00044:2008/01/31 13:58:42.46 kernel pc: 0x66f438 pcstkwalk
+0x3c()
03:00000:00044:2008/01/31 13:58:42.46 kernel pc: 0x66f278
ucstkgentrace+0x210()
03:00000:00044:2008/01/31 13:58:42.46 kernel pc: 0x65cd0c ucbacktrace
+0x88()
03:00000:00044:2008/01/31 13:58:42.46 kernel pc: 0x2b1618
terminate_process+0xa60()
03:00000:00044:2008/01/31 13:58:42.46 kernel pc: 0x686f2c kisignal
+0xb4()
03:00000:00044:2008/01/31 13:58:42.46 kernel pc: 0x7cd068
_sigreturn()
03:00000:00044:2008/01/31 13:58:42.46 kernel [Handler pc: 0x338eac
hdl_backout installed by the following function:-]
03:00000:00044:2008/01/31 13:58:42.46 kernel [Handler pc: 0x470174
ut_handle installed by the following function:-]
03:00000:00044:2008/01/31 13:58:42.46 kernel [Handler pc: 0x470174
ut_handle installed by the following function:-]
03:00000:00044:2008/01/31 13:58:42.46 kernel pc: 0x1bd65c conn_hdlr
+0x440()
03:00000:00044:2008/01/31 13:58:42.46 kernel pc: 0x1bd054 conn_hdlr()
03:00000:00044:2008/01/31 13:58:42.46 kernel end of stack trace, spid
44, kpid 38273151, suid 3
00:00000:00046:2008/01/31 13:58:42.64 server Error: 1608, Severity:
18, State: 4
00:00000:00046:2008/01/31 13:58:42.64 server A client process exited
abnormally, or a network error was encountered. Unless
other errors occurred, continue processing normally.
00:00000:00044:2008/01/31 14:01:16.86 server Error: 1608, Severity:
18, State: 4
00:00000:00044:2008/01/31 14:01:16.86 server A client process exited
abnormally, or a network error was encountered. Unless
other errors occurred, continue processing normally.
02:00000:00048:2008/01/31 14:01:48.61 kernel current process
(0x24c0083) infected with 11
02:00000:00048:2008/01/31 14:01:48.61 kernel Error at address
0x1bd65f (conn_hdlr+0x443)
02:00000:00048:2008/01/31 14:01:48.61 kernel
************************************
02:00000:00048:2008/01/31 14:01:48.61 kernel SQL causing error :
02:00000:00048:2008/01/31 14:01:48.61 kernel
************************************
02:00000:00048:2008/01/31 14:01:48.61 server SQL Text:
02:00000:00048:2008/01/31 14:01:48.61 kernel curdb = 1 pstat =
0x10000 lasterror = 0
02:00000:00048:2008/01/31 14:01:48.61 kernel preverror = 0 transtate
= 1
02:00000:00048:2008/01/31 14:01:48.61 kernel curcmd = 0 program =
trendcopy
02:00000:00048:2008/01/31 14:01:48.61 kernel pc: 0x66f438 pcstkwalk
+0x3c()
02:00000:00048:2008/01/31 14:01:48.61 kernel pc: 0x66f278
ucstkgentrace+0x210()
02:00000:00048:2008/01/31 14:01:48.61 kernel pc: 0x65cd0c ucbacktrace
+0x88()
02:00000:00048:2008/01/31 14:01:48.61 kernel pc: 0x2b1618
terminate_process+0xa60()
02:00000:00048:2008/01/31 14:01:48.61 kernel pc: 0x686f2c kisignal
+0xb4()
02:00000:00048:2008/01/31 14:01:48.61 kernel pc: 0x7cd068
_sigreturn()
02:00000:00048:2008/01/31 14:01:48.61 kernel [Handler pc: 0x338eac
hdl_backout installed by the following function:-]
02:00000:00048:2008/01/31 14:01:48.61 kernel [Handler pc: 0x470174
ut_handle installed by the following function:-]
02:00000:00048:2008/01/31 14:01:48.61 kernel [Handler pc: 0x470174
ut_handle installed by the following function:-]
02:00000:00048:2008/01/31 14:01:48.61 kernel pc: 0x1bd65c conn_hdlr
+0x440()
02:00000:00048:2008/01/31 14:01:48.61 kernel pc: 0x1bd054 conn_hdlr()
02:00000:00048:2008/01/31 14:01:48.61 kernel end of stack trace, spid
48, kpid 38535299, suid 3
00:00000:00048:2008/01/31 14:02:48.79 server Error: 1608, Severity:
18, State: 4
00:00000:00048:2008/01/31 14:02:48.79 server A client process exited
abnormally, or a network error was encountered. Unless
other errors occurred, continue processing normally.
03:00000:00048:2008/01/31 14:03:48.97 server Error: 1608, Severity:
18, State: 4
03:00000:00048:2008/01/31 14:03:48.97 server A client process exited
abnormally, or a network error was encountered. Unless
other errors occurred, continue processing normally.
00:00000:00048:2008/01/31 14:04:49.20 server Error: 1608, Severity:
18, State: 4
00:00000:00048:2008/01/31 14:04:49.20 server A client process exited
abnormally, or a network error was encountered. Unless
other errors occurred, continue processing normally.
01:00000:00048:2008/01/31 14:05:49.50 kernel current process
(0x2500087) infected with 11
01:00000:00048:2008/01/31 14:05:49.50 kernel Error at address
0x1bd65f (conn_hdlr+0x443)
01:00000:00048:2008/01/31 14:05:49.50 kernel
************************************
01:00000:00048:2008/01/31 14:05:49.50 kernel SQL causing error :
01:00000:00048:2008/01/31 14:05:49.50 kernel
************************************
01:00000:00048:2008/01/31 14:05:49.50 server SQL Text:
01:00000:00048:2008/01/31 14:05:49.50 kernel curdb = 1 pstat =
0x10000 lasterror = 0
01:00000:00048:2008/01/31 14:05:49.50 kernel preverror = 0 transtate
= 1
01:00000:00048:2008/01/31 14:05:49.50 kernel curcmd = 0 program =
trendcopy
01:00000:00048:2008/01/31 14:05:49.50 kernel pc: 0x66f438 pcstkwalk
+0x3c()
01:00000:00048:2008/01/31 14:05:49.50 kernel pc: 0x66f278
ucstkgentrace+0x210()
01:00000:00048:2008/01/31 14:05:49.50 kernel pc: 0x65cd0c ucbacktrace
+0x88()
01:00000:00048:2008/01/31 14:05:49.50 kernel pc: 0x2b1618
terminate_process+0xa60()
01:00000:00048:2008/01/31 14:05:49.50 kernel pc: 0x686f2c kisignal
+0xb4()
01:00000:00048:2008/01/31 14:05:49.50 kernel pc: 0x7cd068
_sigreturn()
01:00000:00048:2008/01/31 14:05:49.50 kernel [Handler pc: 0x338eac
hdl_backout installed by the following function:-]
-------------------------------------------------------------------------------------------------------------------------------------------
|
