ontape -r and CKPT REQ
F. David, restoring all dbspaces with ontape -r between two Linux servers on a roughly 2GB database, saw onstat show Fast Recovery (CKPT REQ) with no further checkpoints for over an hour. John Carlson asked whether the command had returned (it had not) and suggested running onstat -D in another session. No outcome in the thread.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello,
I am trying to do a cold restore for all DBSpaces from one Server to
another(both Linux 7.0). I did an
ontape -rI mounted the tape
Continue restore?(Y/N) Y
Do you want to backup the logs?(Y/N) N
The first Checkpoints in online.log were made, but then onstat - gives
Fast Recovery(CKPT REQ) and no more Checkpoint is done. I waited more
than 1 hour. The database is about 2Gb.
Is there anything I can do to finish the restore?
Regards
Fredo David
On Wed, 08 Oct 2003 19:05:44 +0200, F. David
<david@uke.uni-hamburg.de> wrote:
>Hello,
>
>I am trying to do a cold restore for all DBSpaces from one Server to
>another(both Linux 7.0). I did an
>ontape -r>I mounted the tape
>Continue restore?(Y/N) Y
>Do you want to backup the logs?(Y/N) N
>
>The first Checkpoints in online.log were made, but then onstat - gives
>Fast Recovery(CKPT REQ) and no more Checkpoint is done. I waited more
>than 1 hour. The database is about 2Gb.
>Is there anything I can do to finish the restore?
>
>Regards
>Fredo David
Did the ontape command return to the command line?
On Wed, 08 Oct 2003 13:26:22 -0400, John Carlson
<john_carlson@whsmithusa.com> wrote:
>On Wed, 08 Oct 2003 19:05:44 +0200, F. David
><david@uke.uni-hamburg.de> wrote:
>
>>Hello,
>>
>>I am trying to do a cold restore for all DBSpaces from one Server to
>>another(both Linux 7.0). I did an
>>ontape -r>>I mounted the tape
>>Continue restore?(Y/N) Y
>>Do you want to backup the logs?(Y/N) N
>>
>>The first Checkpoints in online.log were made, but then onstat - gives
>>Fast Recovery(CKPT REQ) and no more Checkpoint is done. I waited more
>>than 1 hour. The database is about 2Gb.
>>Is there anything I can do to finish the restore?
>>
>>Regards
>>Fredo David
>
>Did the ontape command return to the command line?
No, The command did not.
On Wed, 08 Oct 2003 19:26:54 +0200, F. David
<david@uke.uni-hamburg.de> wrote:
>On Wed, 08 Oct 2003 13:26:22 -0400, John Carlson
><john_carlson@whsmithusa.com> wrote:
>
>>On Wed, 08 Oct 2003 19:05:44 +0200, F. David
>><david@uke.uni-hamburg.de> wrote:
>>
>>>Hello,
>>>
>>>I am trying to do a cold restore for all DBSpaces from one Server to
>>>another(both Linux 7.0). I did an
>>>ontape -r>>>I mounted the tape
>>>Continue restore?(Y/N) Y
>>>Do you want to backup the logs?(Y/N) N
>>>
>>>The first Checkpoints in online.log were made, but then onstat - gives
>>>Fast Recovery(CKPT REQ) and no more Checkpoint is done. I waited more
>>>than 1 hour. The database is about 2Gb.
>>>Is there anything I can do to finish the restore?
>>>
>>>Regards
>>>Fredo David
>>
>>Did the ontape command return to the command line?
>
>No, The command did not.
Then in another session run 'onstat -D'. this shows the dbspace
status and any disk activity.