Oninit cdi / Archive
Talk to an expert →

Fast Recovery

Posted in 2010

Topics: Logging & Checkpoints

ELIEL FERRAZ — — source: IIUG Forums & Mailing Lists

I have a case that I need the help of friends to solve An instance (very badly configured) received a transaction that was to last a LONG TRANSACTION, when I did a rollback to 7828 LOG 7815, but not complete, and is an instance in the status of Fast Recovery (CKPT REQ) and not change this status .. to aggravate the situation I have no current backup, I need to know if there is any way to recover or extract data ... 14:47:31 Fast Recovery Switching to Log 7815 14:47:32 Fast Recovery Switching to Log 7816 14:47:32 Fast Recovery Switching to Log 7817 14:47:32 Fast Recovery Switching to Log 7818 14:47:32 Fast Recovery Switching to Log 7819 14:47:32 Fast Recovery Switching to Log 7820 14:47:33 Fast Recovery Switching to Log 7821 14:47:33 Fast Recovery Switching to Log 7822 14:47:33 Fast Recovery Switching to Log 7823 14:47:33 Fast Recovery Switching to Log 7824 14:47:34 Fast Recovery Switching to Log 7825 14:47:34 Fast Recovery Switching to Log 7826 14:47:34 Fast Recovery Switching to Log 7827 14:47:34 Fast Recovery Switching to Log 7828 14:47:38 Logical Recovery has Reached the transaction cleanup phase. 14:47:38 Waiting for Next Logical Log File to Be Freed

↪ replying to ELIEL FERRAZ
Keith Simmons — — source: IIUG Forums & Mailing Lists

Operating system? IDS Version ? Support Contract !!!! On 9 November 2010 18:12, ELIEL FERRAZ <elielmferraz.dba@gmail.com> wrote: > I have a case that I need the help of friends to solve > > An instance (very badly configured) received a transaction that was to last a > LONG TRANSACTION, when I did a rollback to 7828 LOG 7815, but not complete, > and is an instance in the status of Fast Recovery (CKPT REQ) and not change > this status .. to aggravate the situation I have no current backup, I need to > know if there is any way to recover or extract data ... > > 14:47:31 Fast Recovery Switching to Log 7815 > 14:47:32 Fast Recovery Switching to Log 7816 > 14:47:32 Fast Recovery Switching to Log 7817 > 14:47:32 Fast Recovery Switching to Log 7818 > 14:47:32 Fast Recovery Switching to Log 7819 > 14:47:32 Fast Recovery Switching to Log 7820 > 14:47:33 Fast Recovery Switching to Log 7821 > 14:47:33 Fast Recovery Switching to Log 7822 > 14:47:33 Fast Recovery Switching to Log 7823 > 14:47:33 Fast Recovery Switching to Log 7824 > 14:47:34 Fast Recovery Switching to Log 7825 > 14:47:34 Fast Recovery Switching to Log 7826 > 14:47:34 Fast Recovery Switching to Log 7827 > 14:47:34 Fast Recovery Switching to Log 7828 > 14:47:38 Logical Recovery has Reached the transaction cleanup phase. > 14:47:38 Waiting for Next Logical Log File to Be Freed > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to ELIEL FERRAZ
DAN MUELLER — — source: IIUG Forums & Mailing Lists

Call IBM support and take tghe down systems queue. They can terminate the transaction for you. W/o a good backup, I know of no other way.

↪ replying to ELIEL FERRAZ
Art Kagel — — source: IIUG Forums & Mailing Lists

You can try to add another logical log file or three. If that doesn't work, you will have to contact IBM and report a "down system". They can truncate the logical logs so that the engine can complete recovery and you will be able to dbexport your databases and rebuild a new server from the export. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Nov 9, 2010 at 1:12 PM, ELIEL FERRAZ <elielmferraz.dba@gmail.com>wrote: > I have a case that I need the help of friends to solve > > An instance (very badly configured) received a transaction that was to last > a > LONG TRANSACTION, when I did a rollback to 7828 LOG 7815, but not complete, > and is an instance in the status of Fast Recovery (CKPT REQ) and not change > this status .. to aggravate the situation I have no current backup, I need > to > know if there is any way to recover or extract data ... > > 14:47:31 Fast Recovery Switching to Log 7815 > 14:47:32 Fast Recovery Switching to Log 7816 > 14:47:32 Fast Recovery Switching to Log 7817 > 14:47:32 Fast Recovery Switching to Log 7818 > 14:47:32 Fast Recovery Switching to Log 7819 > 14:47:32 Fast Recovery Switching to Log 7820 > 14:47:33 Fast Recovery Switching to Log 7821 > 14:47:33 Fast Recovery Switching to Log 7822 > 14:47:33 Fast Recovery Switching to Log 7823 > 14:47:33 Fast Recovery Switching to Log 7824 > 14:47:34 Fast Recovery Switching to Log 7825 > 14:47:34 Fast Recovery Switching to Log 7826 > 14:47:34 Fast Recovery Switching to Log 7827 > 14:47:34 Fast Recovery Switching to Log 7828 > 14:47:38 Logical Recovery has Reached the transaction cleanup phase. > 14:47:38 Waiting for Next Logical Log File to Be Freed > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016364ec7a4f9db7e0494a8a3fd

Glossary