ontape -r and CKPT REQ

[F. David]

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

[John Carlson]

On Wed, 08 Oct 2003 19:05:44 +0200, F. David

Post by F. David
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?

[F. David]

On Wed, 08 Oct 2003 13:26:22 -0400, John Carlson

Post by John Carlson
On Wed, 08 Oct 2003 19:05:44 +0200, F. David

Post by F. David
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.

[John Carlson]

On Wed, 08 Oct 2003 19:26:54 +0200, F. David

Post by F. David
On Wed, 08 Oct 2003 13:26:22 -0400, John Carlson

Post by John Carlson
On Wed, 08 Oct 2003 19:05:44 +0200, F. David

Post by F. David
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.

[Alexey Sonkin]

You can't and shouldn't do anything.

Just monitor with 'onstat' or 'vmstat' how the
restore process is going and wait, until online
status changes to 'quiescent' from 'recovery'

If 'vmstat' shows some CPU/disk activity during restore,
and onstat (-D, -p, etc) shows increments in IDS activity parameters,
everything is OK

------------------------------------------
Alexey Sonkin
Senior Database Administrator

-----Original Message-----
Sent: Wednesday, October 08, 2003 1:06 PM
Subject: ontape -r and CKPT REQ
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

sending to informix-list

[S***@nylex.com.au]

Sounds like it is still going then. The restore process performs a
checkpoint at the end of each dbspace restored.
In my experience, the restore process takes about twice as long as the
backup process.

Stefan






"F. David"
<***@uke.uni-ha To: informix-***@iiug.org
mburg.de> cc:
Sent by: Subject: Re: ontape -r and CKPT REQ
owner-informix-li
***@iiug.org


09/10/2003 03:26
Please respond to
"F. David"






On Wed, 08 Oct 2003 13:26:22 -0400, John Carlson

Post by John Carlson
On Wed, 08 Oct 2003 19:05:44 +0200, F. David

Post by F. David
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.







**********************************************************************

This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. If you have received this email in error
please notify the sender and delete the material from any computer.

You can visit Nylex at http://www.nylex.com.au


**********************************************************************

sending to informix-list

[c***@gmail.com]

Post by F. David
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

Boa tarde,

Quando essa isso ocorrer digite : onmode -c