RE: NetBackup restore issue.
you may also try not to do a point-in-time restore, try restoring the
database by passing the logical log number on which it is failing, i.e. you
may try restoring the database with the following command
onbar -r -n <logical log #>
e.g. if the logical log number is 1234 then the command will be
onbar -r -n 1234
this will tell whether the point-in-time recovery is an issue with storage
manager/informix.
-----Original Message-----
From: Eric Rowell [mailto:erowell@knology.net]
Sent: Monday, May 10, 2004 12:19 PM
To: Savio Pinto (s)
Cc: 'Mike Smith'; informix-list@iiug.org
Subject: RE: NetBackup restore issue.
It stays in Fast Recovery. We will have to check what happens if bring
it off-line and bring it back on-line.
Have Cases open. They are clueless at this point.
On Mon, 2004-05-10 at 09:37, Savio Pinto (s) wrote:
> does the instance remain in the "fast recovery" mode or does it come
> in the "quiescent mode" after the error?, did you try shutting down
> the instance and then bringing it on-line ?
>
> after looking at the log, it appears to me that this problem may be
> with the storage manager, you may need to open a case with veritas and
> informix and ask them to debug this log information.
>
> -----Original Message-----
> From: Mike Smith [mailto:idsquiz@yahoo.com]
> Sent: Saturday, May 08, 2004 4:31 PM
> To: Savio Pinto (s); informix-list@iiug.org
> Subject: RE: NetBackup restore issue.
>
>
> Thanks Savio.
>
> We are having problems. Here is the last lines of
> bar_dbug.log :
>
> 2004-05-07 19:07:13 18797 18795 od2bar_objdesc: return 0
> (0x00)
> 2004-05-07 19:07:13 18797 18795 barGetObject: return 0
> (0x00)
> 2004-05-07 19:07:13 18797 18795 barGetData: enter
> 2004-05-07 19:07:13 18797 18795 BSAGetData: enter
> 2004-05-07 19:07:13 18797 18795 BSAGetData: input 1
> 2004-05-07 19:07:13 18797 18795 BSAGetData: input: bufferLen
> = 63488, numBytes = 0
> 2004-05-07 19:07:13 18797 18795 BSAGetData: output:
> bufferLen = 63488, numBytes = 63488
> 2004-05-07 19:07:13 18797 18795 BSAGetData: return 14 (0x0e)
> 2004-05-07 19:07:13 18797 18795 barGetData: output last_lap
> 2004-05-07 19:07:13 18797 18795 barGetData: return 0 (0x00)
> 2004-05-07 19:07:13 18797 18795 address flags
> stamp uniqid number
> 2004-05-07 19:07:13 18797 18795 -1:24
> 0x409718d4 0 0 0
> 2004-05-07 19:07:13 18797 18795 3795781:256
> 0xa5386815 16410 0 0
> 2004-05-07 19:07:13 18797 18795 3795782:256
> 0xa5386afc 16410 1 0
> 2004-05-07 19:07:13 18797 18795 3795783:256
> 0xa5386b06 16410 2 0
> 2004-05-07 19:07:13 18797 18795 3795784:256
> 0xa5386b09 16410 3 0
> 2004-05-07 19:07:13 18797 18795 3795785:256
> 0xa5386b0f 16410 4 0
> 2004-05-07 19:07:13 18797 18795 3795786:256
> 0xa5386c14 16410 5 0
> 2004-05-07 19:07:13 18797 18795 3795787:256
> 0xa5387614 16410 6 0
> 2004-05-07 19:07:13 18797 18795 3795788:256
> 0xa5387648 16410 7 0
> 2004-05-07 19:07:14 18797 18795 3795789:256
> 0xa5387e82 16410 8 0
> 2004-05-07 19:07:14 18797 18795 3795790:256
> 0xa5387e87 16410 9 0
> 2004-05-07 19:07:14 18797 18795 3795791:256
> 0xa5388159 16410 10 0
> 2004-05-07 19:07:14 18797 18795 3795792:256
> 0xa538818b 16410 11 0
> 2004-05-07 19:07:14 18797 18795 3795793:256
> 0xa53881b0 16410 12 0
> 2004-05-07 19:07:14 18797 18795 3795794:256
> 0xa538843f 16410 13 0
> 2004-05-07 19:07:14 18797 18795 3795795:256
> 0xa5388d8b 16410 14 0
> 2004-05-07 19:07:14 18797 18795 3795796:256
> 0xa5388d90 16410 15 0
> 2004-05-07 19:07:14 18797 18795 3795797:256
> 0xa538973d 16410 16 0
> 2004-05-07 19:07:14 18797 18795 3795798:256
> 0xa5389776 16410 17 0
> 2004-05-07 19:07:14 18797 18795 3795799:256
> 0xa5389c0a 16410 18 0
> 2004-05-07 19:07:14 18797 18795 3795800:256
> 0xa5389c8a 16410 19 0
> 2004-05-07 19:07:14 18797 18795 3795801:256
> 0xa5389c8f 16410 20 0
> 2004-05-07 19:07:14 18797 18795 3795802:256
> 0xa5389cbb 16410 21 0
> 2004-05-07 19:07:14 18797 18795 3795803:256
> 0xa5389cc9 16410 22 0
> 2004-05-07 19:07:14 18797 18795 3795804:256
> 0xa5389cd7 16410 23 0
> 2004-05-07 19:07:14 18797 18795 3795805:256
> 0xa5389ce5 16410 24 0
> 2004-05-07 19:07:14 18797 18795 3795806:256
> 0xa5389ce9 16410 25 0
> 2004-05-07 19:07:14 18797 18795 3795807:256
> 0xa5389ec0 16410 26 0
> 2004-05-07 19:07:14 18797 18795 3795808:256
> 0xa538a02f 16410 27 0
> 2004-05-07 19:07:14 18797 18795 3795809:256
> 0xa538a049 16410 28 0
> 2004-05-07 19:07:14 18797 18795 3795810:256
> 0xa538a118 16410 29 0
> 2004-05-07 19:07:14 18797 18795 bar_log_write_restore: enter
> 2004-05-07 19:07:14 18797 18795 bar_log_write_restore: input
> buf 0x6c701400 bufnbytes 63488
> 2004-05-07 19:07:14 18797 18795 bar_log_write_restore:
> output buf 0x6c711400 events 0x1 errtxt
> 2004-05-07 19:07:14 18797 18795 bar_log_write_restore:
> return 0 (0x00)
> 2004-05-07 19:07:14 18797 18795 do_log_restore: Got 1
> buffers
> 2004-05-07 19:07:14 18797 18795 barEndTxn: enter
> 2004-05-07 19:07:14 18797 18795 BSAEndData: enter
> 2004-05-07 19:07:19 18797 18795 BSAEndData: return 3 (0x03)
> 2004-05-07 19:07:19 18797 18795 do_xbsa_error: enter
> 2004-05-07 19:07:19 18797 18795 do_xbsa_error: input
> the_error 3 function BSAEndData
> 2004-05-07 19:07:19 18797 18795 do_xbsa_error: return 138
> (0x8a)
> 2004-05-07 19:07:19 18797 18795 BSAEndTxn: enter
> 2004-05-07 19:07:19 18797 18795 BSAEndTxn: return 0 (0x00)
> 2004-05-07 19:07:19 18797 18795 barEndTxn: return 3 (0x03)
> 2004-05-07 19:07:19 18797 18795 barEndTxn: enter
> 2004-05-07 19:07:19 18797 18795 BSAEndTxn: enter
> 2004-05-07 19:07:19 18797 18795 BSAEndTxn: return 5 (0x05)
> 2004-05-07 19:07:19 18797 18795 do_xbsa_error: enter@@N