unable to do continuous log replay

Hi IIUG, I've done startup of my instance via 'oninit -vPHY' , it showed that the instance is in Fast Recovery mode, however, if i try to do continuous log restore via "ontape -l -C", error shows: ================ Logical restore failed There are no DBspaces or BLOBspaces to recover. Check the status by using onstat -d. Program over. ================ Upon checking, all the dbspaces are in 'Consistent mode', which may caused 'ontape -l -C' not to function.. Chunks address chunk/dbs offset size free bpages flags pathname 700000063ef7258 1 1 0 524287 509776 PO-B-- /links/dbs02root0101 7000000659a9028 2 2 0 524288 0 PO-B-- /links/dbs02plog0101 7000000659aa028 3 3 0 8388608 131019 PO-B-- /links/dbs02llog0101 7000000659ab028 4 4 0 4194304 4194251 PO-B-- /links/dbs02temp0101 Is there a way to fix this? i dont want to use 'ontape -p' because the DB is around 2 TB in size. I did disk duplicate aka dd via OS. IDS 12.10.FC4AEE on AIX 7. Thanks,

This would be performing an external backup and restore with ontape. https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.bar.doc/ids _bar_262.htm You need to block/unblock the database server before/after the backup to get an consistent image. https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.bar.doc/ids_ba r_141.htm Then use the ontape -p -e command to perform a cold external restore, this also marks the storage spaces as physically restored. https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.bar.doc/ids _bar_144.htm Finally perform a logical (log) restore https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.bar.doc/ids _bar_145.htm Regards, David. > On 01 September 2017 at 05:16 RONALD OLAVIDEZ <ronald.olavidez@gmail.com> wrote: > > > Hi IIUG, > > I've done startup of my instance via 'oninit -vPHY' , it showed that the > instance is in Fast Recovery mode, however, if i try to do continuous log > restore via "ontape -l -C", error shows: > ================ > Logical restore failed > There are no DBspaces or BLOBspaces to recover. > Check the status by using onstat -d. > > Program over. > ================ > Upon checking, all the dbspaces are in 'Consistent mode', which may caused > 'ontape -l -C' not to function.. > > Chunks > address chunk/dbs offset size free bpages flags pathname > 700000063ef7258 1 1 0 524287 509776 PO-B-- /links/dbs02root0101 > 7000000659a9028 2 2 0 524288 0 PO-B-- /links/dbs02plog0101 > 7000000659aa028 3 3 0 8388608 131019 PO-B-- /links/dbs02llog0101 > 7000000659ab028 4 4 0 4194304 4194251 PO-B-- /links/dbs02temp0101 > > Is there a way to fix this? i dont want to use 'ontape -p' because the DB is > around 2 TB in size. I did disk duplicate aka dd via OS. > > IDS 12.10.FC4AEE on AIX 7. > > Thanks, > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >