Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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.
>
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.