Failed to recover the logs after restore

Hi Gurus, I have a DB that i want to do some log replay. startup --- oninit -PHYv ## This looks good and shows in fast recovery mode. When i do "ontape -l -C", it showed that all my dbspaces are "Online" but the the itself is in fast recovery. 0/11/16 08:59:51 Started 1 B-tree scanners. 10/11/16 08:59:51 B-tree scanner threshold set at 10000. 10/11/16 08:59:51 B-tree scanner range scan size set to -1. 10/11/16 08:59:51 B-tree scanner ALICE mode set to 6. 10/11/16 08:59:51 B-tree scanner index compression level set to med. 10/11/16 08:59:51 Data replication type and state information reset. To start DR, use the 'onmode -d' command and wait for the pair to be operational, before shutting down the database server 10/11/16 08:59:51 Physical Recovery Started at Page (2:71212). 10/11/16 08:59:53 Physical Recovery Complete: 1543 Pages Examined, 1543 Pages Restored. 10/11/16 08:59:53 Dataskip is now OFF for all dbspaces 10/11/16 08:59:53 Restartable Restore has been ENABLED 10/11/16 08:59:53 Recovery Mode =================================== Chunks address chunk/dbs offset size free bpages flags pathname 700000063ef7258 1 1 0 524287 510256 PO-B-- /links/dbs02root0101 7000000658c4028 2 2 0 524288 0 PO-B-- /links/dbs02plog0101 7000000658c5028 3 3 0 8388608 131019 PO-B-- /links/dbs02llog0101 7000000658c6028 4 4 0 4194304 4194251 PO-B-- /links/dbs02temp0101 7000000658c7028 5 5 0 4194304 4194251 PO-B-- /links/dbs02temp0201 7000000658c8028 6 6 0 16777216 0 PO-B-- /links/dbs02datb0101 ........ ===================================== when i tried "ontape -l -C" it showed: informix@#ontape -l -C Logical restore failed There are no DBspaces or BLOBspaces to recover. Check the status by using onstat -d. Program over. I am using IBM Informix Dynamic Server Version 12.10.FC4AEE on AIX 7 Thanks, Ronald

After you restore the last logical log you have to bring the engine to full online mode with onmode -m to complete fast recovery. If you shutdown and rstart without doing that you have start the restore all over again! Art On Oct 10, 2016 19:56, "RONALD OLAVIDEZ" <ronald.olavidez@gmail.com> wrote: > Hi Gurus, > > I have a DB that i want to do some log replay. > > startup --- oninit -PHYv ## This looks good and shows in fast recovery > mode. > > When i do "ontape -l -C", it showed that all my dbspaces are "Online" but > the > the itself is in fast recovery. > > 0/11/16 08:59:51 Started 1 B-tree scanners. > 10/11/16 08:59:51 B-tree scanner threshold set at 10000. > 10/11/16 08:59:51 B-tree scanner range scan size set to -1. > 10/11/16 08:59:51 B-tree scanner ALICE mode set to 6. > 10/11/16 08:59:51 B-tree scanner index compression level set to med. > 10/11/16 08:59:51 Data replication type and state information reset. To > start > DR, use > > the 'onmode -d' command and wait for the pair to be operational, > > before shutting down the database server > > 10/11/16 08:59:51 Physical Recovery Started at Page (2:71212). > 10/11/16 08:59:53 Physical Recovery Complete: 1543 Pages Examined, 1543 > Pages > Restored. > 10/11/16 08:59:53 Dataskip is now OFF for all dbspaces > 10/11/16 08:59:53 Restartable Restore has been ENABLED > 10/11/16 08:59:53 Recovery Mode > > =================================== > Chunks > address chunk/dbs offset size free bpages flags pathname > 700000063ef7258 1 1 0 524287 510256 PO-B-- /links/dbs02root0101 > 7000000658c4028 2 2 0 524288 0 PO-B-- /links/dbs02plog0101 > 7000000658c5028 3 3 0 8388608 131019 PO-B-- /links/dbs02llog0101 > 7000000658c6028 4 4 0 4194304 4194251 PO-B-- /links/dbs02temp0101 > 7000000658c7028 5 5 0 4194304 4194251 PO-B-- /links/dbs02temp0201 > 7000000658c8028 6 6 0 16777216 0 PO-B-- /links/dbs02datb0101 > ......... > > ===================================== > when i tried "ontape -l -C" it showed: > > informix@#ontape -l -C > Logical restore failed > There are no DBspaces or BLOBspaces to recover. > Check the status by using onstat -d. > > Program over. > > I am using IBM Informix Dynamic Server Version 12.10.FC4AEE on AIX 7 > > Thanks, > Ronald > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01030114509482053e8da8ad

Hey Art, Thanks a lot.. it's intended to be in "Fast Recovery" mode after oninit -PHYv, to do the log replay. I don't want it to be in On-Line mode. What i'm just curious is the chunks are marked as "Primary Online", which should be Primary Inconsistent. Anyways, i'm doing a physical restore tonight and hopefully, i can continue the log replay tomorrow.. Cheers, Ronald

Yes after the physical restore and even after the log restore the chunks should be inconsistent not online. I agree that after the physical restore you want to leave the engine as is waiting for the log restore. What I was saying is that after restoring the last logical log that you need to restore you need to bring the engine online before shutting down or trying to establish HDR. If for some reason the engine crashes or must be brought down before the restores complete you have to restart it with: oninit -PHYto avoid the fast recovery phase which will fail because of the aborted restore. Then you could continue the log restore. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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, Oct 11, 2016 at 1:29 AM, RONALD OLAVIDEZ <ronald.olavidez@gmail.com> wrote: > Hey Art, > > Thanks a lot.. it's intended to be in "Fast Recovery" mode after oninit > -PHYv, > to do the log replay. I don't want it to be in On-Line mode. What i'm just > curious is the chunks are marked as "Primary Online", which should be > Primary > Inconsistent. > > Anyways, i'm doing a physical restore tonight and hopefully, i can continue > the log replay tomorrow.. > > Cheers, > Ronald > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1130d406bdcb1e053e973fa5

Thanks Art. I've restored from our backup and works good now.