Copying from one server to another
User copied a 200GB Informix environment via network (ontape -s piped to ontape_restore) between HP-UX servers. After restore, Fast Recovery Mode ran for hours; rebooting caused shared memory initialization failure. Art Kagel advised running 'onmode -m' and waiting for the online message before shutdown/reboot, rather than interrupting Fast Recovery Mode prematurely.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I recently copied my Informix environment from one server to another using
information provided by John Miller below. Thanks John and others for the
information.
ontape -s -L 0 -t STDIO -F | rsh server2 ontape_restore.ksh
I had to modify some environment variables to get it to work but the archive
completed to the other server. After an hour in Fast Recovery Mode on the
target server, I rebooted and could not get Informix to come online. It would
pass the validation of chunks but then fail with an error of oninit: Fatal
error in shared memory initialization. When I did some research I saw some
postings about interrupting Fast Recovery mode. So I did another restore and
it completed and now the target server is in Fast Recovery mode again and has
been for several hours. How can I tell if it is still doing something? I'll
give more information below.
Both servers running HPUX 11iv3 and Informix Dynamic Server 11.70.FC4.
Production source server is HP Integrity Blade and target server is a slower
HP Integrity RX 2600 server. We've restored to the RX 2600 target server many
times with HPUX Ignite process and Informix tapes using ontape -r. This is the
first time using the network instead of tape.
Other information:
* The entire backup / restore process took about 9 hours. I have at least 4
dbspaces with several 30 to 40GB databases. Probably a total of about 200GB of
databases.
* All databases are Unbuffered logging on our production server.
* On target server all file systems, chunks, dbspaces are the same size.
Since the entire backup / restore process took 9 hours, I'm wondering if Fast
Recovery will take that much or longer. Below is the output from onstat -p on
target server.
Andy Pistocchi
DBA / Systems Administrator
The University of Tampa
# onstat -p
IBM Informix Dynamic Server Version 11.70.FC4 -- Fast Recovery -- Up 15:33:32
-- 2636400 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
33 22 81 59.26 4636521 73374275 5 0.00
isamtot open start read write rewrite delete commit rollbk
0 0 0 0 0 0 0 0 0
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 186.52 310.92 6 5
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
0 0 0 0 0 0 0 0
ixda-RA idx-RA da-RA logrec-RA RA-pgsused lchwaits
0 0 0 0 0 19320
Did you try using ifxclone?
Sent from my iPad
On Jun 27, 2013, at 5:51 AM, "ANDREW PISTOCCHI" <APISTOCCHI@UT.EDU> wrote:
> I recently copied my Informix environment from one server to another
using
> information provided by John Miller below. Thanks John and others for the
> information.
>
> ontape -s -L 0 -t STDIO -F | rsh server2 ontape_restore.ksh>
> I had to modify some environment variables to get it to work but the
archive
> completed to the other server. After an hour in Fast Recovery Mode on the
> target server, I rebooted and could not get Informix to come online. It
would
> pass the validation of chunks but then fail with an error of oninit:
Fatal
> error in shared memory initialization. When I did some research I saw
some
> postings about interrupting Fast Recovery mode. So I did another restore
and
> it completed and now the target server is in Fast Recovery mode again and
has
> been for several hours. How can I tell if it is still doing something?
I'll
> give more information below.
>
> Both servers running HPUX 11iv3 and Informix Dynamic Server 11.70.FC4.
> Production source server is HP Integrity Blade and target server is a
slower
> HP Integrity RX 2600 server. We've restored to the RX 2600 target server
many
> times with HPUX Ignite process and Informix tapes using ontape -r. This
is the
> first time using the network instead of tape.
>
> Other information:
>
> * The entire backup / restore process took about 9 hours. I have at least
4
> dbspaces with several 30 to 40GB databases. Probably a total of about
200GB of
> databases.
>
> * All databases are Unbuffered logging on our production server.
>
> * On target server all file systems, chunks, dbspaces are the same size.
>
> Since the entire backup / restore process took 9 hours, I'm wondering if
Fast
> Recovery will take that much or longer. Below is the output from onstat
-p on
> target server.
>
> Andy Pistocchi
> DBA / Systems Administrator
> The University of Tampa
>
> # onstat -p
> IBM Informix Dynamic Server Version 11.70.FC4 -- Fast Recovery -- Up
15:33:32
> -- 2636400 Kbytes>
> Profile
> dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> 33 22 81 59.26 4636521 73374275 5 0.00
>
> isamtot open start read write rewrite delete commit rollbk
> 0 0 0 0 0 0 0 0 0
>
> gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
> 0 0 0 0 0 0 0
>
> ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
> 0 0 0 186.52 310.92 6 5
>
> bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
> 0 0 0 0 0 0 0 0
>
> ixda-RA idx-RA da-RA logrec-RA RA-pgsused lchwaits
> 0 0 0 0 0 19320
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Have you run onmode -m yet? If not, do that and wait for the online
message log to report that the engine in "Online" before shutting it down
to restart it and/or rebooting.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Thu, Jun 27, 2013 at 7:50 AM, ANDREW PISTOCCHI <APISTOCCHI@ut.edu> wrote:
> I recently copied my Informix environment from one server to another using
> information provided by John Miller below. Thanks John and others for the
> information.
>
> ontape -s -L 0 -t STDIO -F | rsh server2 ontape_restore.ksh>
> I had to modify some environment variables to get it to work but the
> archive
> completed to the other server. After an hour in Fast Recovery Mode on the
> target server, I rebooted and could not get Informix to come online. It
> would
> pass the validation of chunks but then fail with an error of oninit: Fatal
> error in shared memory initialization. When I did some research I saw some
> postings about interrupting Fast Recovery mode. So I did another restore
> and
> it completed and now the target server is in Fast Recovery mode again and
> has
> been for several hours. How can I tell if it is still doing something? I'll
> give more information below.
>
> Both servers running HPUX 11iv3 and Informix Dynamic Server 11.70.FC4.
> Production source server is HP Integrity Blade and target server is a
> slower
> HP Integrity RX 2600 server. We've restored to the RX 2600 target server
> many
> times with HPUX Ignite process and Informix tapes using ontape -r. This is
> the
> first time using the network instead of tape.
>
> Other information:
>
> * The entire backup / restore process took about 9 hours. I have at least 4
> dbspaces with several 30 to 40GB databases. Probably a total of about
> 200GB of
> databases.
>
> * All databases are Unbuffered logging on our production server.
>
> * On target server all file systems, chunks, dbspaces are the same size.
>
> Since the entire backup / restore process took 9 hours, I'm wondering if
> Fast
> Recovery will take that much or longer. Below is the output from onstat -p
> on
> target server.
>
> Andy Pistocchi
> DBA / Systems Administrator
> The University of Tampa
>
> # onstat -p
> IBM Informix Dynamic Server Version 11.70.FC4 -- Fast Recovery -- Up
> 15:33:32
> -- 2636400 Kbytes>
> Profile
> dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> 33 22 81 59.26 4636521 73374275 5 0.00
>
> isamtot open start read write rewrite delete commit rollbk
> 0 0 0 0 0 0 0 0 0
>
> gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
> 0 0 0 0 0 0 0
>
> ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
> 0 0 0 186.52 310.92 6 5
>
> bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
> 0 0 0 0 0 0 0 0
>
> ixda-RA idx-RA da-RA logrec-RA RA-pgsused lchwaits
> 0 0 0 0 0 19320
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e013d17429832c404e022218e
Thanks Art! That worked. It took about 10 minutes after the onmode -m to come
online.
In the future is there sometime after the restore that I have to wait to run
the onmode -m when in Fast Recovery mode, or can I run it right away?
Andy P.
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel
Sent: Thursday, June 27, 2013 8:45 AM
To: ids@iiug.org
Subject: Re: Copying from one server to another [30683]
Have you run onmode -m yet? If not, do that and wait for the online message
log to report that the engine in "Online" before shutting it down to restart
it and/or rebooting.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Thu, Jun 27, 2013 at 7:50 AM, ANDREW PISTOCCHI <APISTOCCHI@ut.edu> wrote:
> I recently copied my Informix environment from one server to another
> using information provided by John Miller below. Thanks John and
> others for the information.
>
> ontape -s -L 0 -t STDIO -F | rsh server2 ontape_restore.ksh>
> I had to modify some environment variables to get it to work but the
> archive completed to the other server. After an hour in Fast Recovery
> Mode on the target server, I rebooted and could not get Informix to
> come online. It would pass the validation of chunks but then fail with
> an error of oninit: Fatal error in shared memory initialization. When
> I did some research I saw some postings about interrupting Fast
> Recovery mode. So I did another restore and it completed and now the
> target server is in Fast Recovery mode again and has been for several
> hours. How can I tell if it is still doing something? I'll give more
> information below.
>
> Both servers running HPUX 11iv3 and Informix Dynamic Server 11.70.FC4.
> Production source server is HP Integrity Blade and target server is a
> slower HP Integrity RX 2600 server. We've restored to the RX 2600
> target server many times with HPUX Ignite process and Informix tapes
> using ontape -r. This is the first time using the network instead of
> tape.
>
> Other information:
>
> * The entire backup / restore process took about 9 hours. I have at
> least 4 dbspaces with several 30 to 40GB databases. Probably a total
> of about 200GB of databases.
>
> * All databases are Unbuffered logging on our production server.
>
> * On target server all file systems, chunks, dbspaces are the same size.
>
> Since the entire backup / restore process took 9 hours, I'm wondering
> if Fast Recovery will take that much or longer. Below is the output
> from onstat -p on target server.
>
> Andy Pistocchi
> DBA / Systems Administrator
> The University of Tampa
>
> # onstat -p
> IBM Informix Dynamic Server Version 11.70.FC4 -- Fast Recovery -- Up
> 15:33:32
> -- 2636400 Kbytes>
> Profile
> dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> 33 22 81 59.26 4636521 73374275 5 0.00
>
> isamtot open start read write rewrite delete commit rollbk
> 0 0 0 0 0 0 0 0 0
>
> gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
> 0 0 0 0 0 0 0
>
> ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
> 0 0 0 186.52 310.92 6 5
>
> bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
> 0 0 0 0 0 0 0 0
>
> ixda-RA idx-RA da-RA logrec-RA RA-pgsused lchwaits
> 0 0 0 0 0 19320
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e013d17429832c404e022218e
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
You can run the onmode -m immediate after the ontape/onbar restore
completes (or after restoring any logical logs you need to restore). You
must bring the engine to full online mode (with the onmode -m) before
shutting down or it will not restart because all of the chunks will be
marked "Inconsistent" (Flag 'I' in the onstat -d report) because "fast
recovery" was not completed by bringing it online.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Thu, Jun 27, 2013 at 9:22 AM, ANDREW PISTOCCHI <APISTOCCHI@ut.edu> wrote:
> Thanks Art! That worked. It took about 10 minutes after the onmode -m to
> come
> online.
>
> In the future is there sometime after the restore that I have to wait to
> run
> the onmode -m when in Fast Recovery mode, or can I run it right away?
>
> Andy P.
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Thursday, June 27, 2013 8:45 AM
> To: ids@iiug.org
> Subject: Re: Copying from one server to another [30683]
>
> Have you run onmode -m yet? If not, do that and wait for the online message
> log to report that the engine in "Online" before shutting it down to
> restart
> it and/or rebooting.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Thu, Jun 27, 2013 at 7:50 AM, ANDREW PISTOCCHI <APISTOCCHI@ut.edu>
> wrote:
>
> > I recently copied my Informix environment from one server to another
> > using information provided by John Miller below. Thanks John and
> > others for the information.
> >
> > ontape -s -L 0 -t STDIO -F | rsh server2 ontape_restore.ksh> >
> > I had to modify some environment variables to get it to work but the
> > archive completed to the other server. After an hour in Fast Recovery
> > Mode on the target server, I rebooted and could not get Informix to
> > come online. It would pass the validation of chunks but then fail with
> > an error of oninit: Fatal error in shared memory initialization. When
> > I did some research I saw some postings about interrupting Fast
> > Recovery mode. So I did another restore and it completed and now the
> > target server is in Fast Recovery mode again and has been for several
> > hours. How can I tell if it is still doing something? I'll give more
> > information below.
> >
> > Both servers running HPUX 11iv3 and Informix Dynamic Server 11.70.FC4.
> > Production source server is HP Integrity Blade and target server is a
> > slower HP Integrity RX 2600 server. We've restored to the RX 2600
> > target server many times with HPUX Ignite process and Informix tapes
> > using ontape -r. This is the first time using the network instead of
> > tape.
> >
> > Other information:
> >
> > * The entire backup / restore process took about 9 hours. I have at
> > least 4 dbspaces with several 30 to 40GB databases. Probably a total
> > of about 200GB of databases.
> >
> > * All databases are Unbuffered logging on our production server.
> >
> > * On target server all file systems, chunks, dbspaces are the same size.
> >
> > Since the entire backup / restore process took 9 hours, I'm wondering
> > if Fast Recovery will take that much or longer. Below is the output
> > from onstat -p on target server.
> >
> > Andy Pistocchi
> > DBA / Systems Administrator
> > The University of Tampa
> >
> > # onstat -p
> > IBM Informix Dynamic Server Version 11.70.FC4 -- Fast Recovery -- Up
> > 15:33:32
> > -- 2636400 Kbytes> >
> > Profile
> > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> > 33 22 81 59.26 4636521 73374275 5 0.00
> >
> > isamtot open start read write rewrite delete commit rollbk
> > 0 0 0 0 0 0 0 0 0
> >
> > gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
> > 0 0 0 0 0 0 0
> >
> > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
> > 0 0 0 186.52 310.92 6 5
> >
> > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
> > 0 0 0 0 0 0 0 0
> >
> > ixda-RA idx-RA da-RA logrec-RA RA-pgsused lchwaits
> > 0 0 0 0 0 19320
> >
> >
> >
> >
>
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --089e013d17429832c404e022218e
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e013d1cf845b6a704e0232db7
Check the online.log and see when it has finished clearing the physical/logical
logs
Regards,
David.
On 27 June 2013 at 14:22 ANDREW PISTOCCHI <APISTOCCHI@UT.EDU> wrote:
> Thanks Art! That worked. It took about 10 minutes after the onmode -m to come
> online.
>
> In the future is there sometime after the restore that I have to wait to run
> the onmode -m when in Fast Recovery mode, or can I run it right away?
>
> Andy P.
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Thursday, June 27, 2013 8:45 AM
> To: ids@iiug.org
> Subject: Re: Copying from one server to another [30683]
>
> Have you run onmode -m yet? If not, do that and wait for the online message
> log to report that the engine in "Online" before shutting it down to restart
> it and/or rebooting.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Thu, Jun 27, 2013 at 7:50 AM, ANDREW PISTOCCHI <APISTOCCHI@ut.edu> wrote:
>
> > I recently copied my Informix environment from one server to another
> > using information provided by John Miller below. Thanks John and
> > others for the information.
> >
> > ontape -s -L 0 -t STDIO -F | rsh server2 ontape_restore.ksh> >
> > I had to modify some environment variables to get it to work but the
> > archive completed to the other server. After an hour in Fast Recovery
> > Mode on the target server, I rebooted and could not get Informix to
> > come online. It would pass the validation of chunks but then fail with
> > an error of oninit: Fatal error in shared memory initialization. When
> > I did some research I saw some postings about interrupting Fast
> > Recovery mode. So I did another restore and it completed and now the
> > target server is in Fast Recovery mode again and has been for several
> > hours. How can I tell if it is still doing something? I'll give more
> > information below.
> >
> > Both servers running HPUX 11iv3 and Informix Dynamic Server 11.70.FC4.
> > Production source server is HP Integrity Blade and target server is a
> > slower HP Integrity RX 2600 server. We've restored to the RX 2600
> > target server many times with HPUX Ignite process and Informix tapes
> > using ontape -r. This is the first time using the network instead of
> > tape.
> >
> > Other information:
> >
> > * The entire backup / restore process took about 9 hours. I have at
> > least 4 dbspaces with several 30 to 40GB databases. Probably a total
> > of about 200GB of databases.
> >
> > * All databases are Unbuffered logging on our production server.
> >
> > * On target server all file systems, chunks, dbspaces are the same size.
> >
> > Since the entire backup / restore process took 9 hours, I'm wondering
> > if Fast Recovery will take that much or longer. Below is the output
> > from onstat -p on target server.
> >
> > Andy Pistocchi
> > DBA / Systems Administrator
> > The University of Tampa
> >
> > # onstat -p
> > IBM Informix Dynamic Server Version 11.70.FC4 -- Fast Recovery -- Up
> > 15:33:32
> > -- 2636400 Kbytes> >
> > Profile
> > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
> > 33 22 81 59.26 4636521 73374275 5 0.00
> >
> > isamtot open start read write rewrite delete commit rollbk
> > 0 0 0 0 0 0 0 0 0
> >
> > gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
> > 0 0 0 0 0 0 0
> >
> > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
> > 0 0 0 186.52 310.92 6 5
> >
> > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
> > 0 0 0 0 0 0 0 0
> >
> > ixda-RA idx-RA da-RA logrec-RA RA-pgsused lchwaits
> > 0 0 0 0 0 19320
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --089e013d17429832c404e022218e
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>