home‎ > ‎restore‎ > ‎

restore clone

Copy an instance from a remote host using the Informix ifxclone utility.

usage

infx restore type=clone inst source [ force=yes|no online=yes|no port dispo=RSS|ER ]
     clone remote instance
       required:
         inst - instance name
         source - the instance to copy from
       optional:
         force - force the instance offline first
         online - bring the instance online after
         port - optional, use this source port instead
         dispo - set disposition flag to RSS or ER
  • You have to set FULL_DISK_INIT to 1 for ifxclone to run
  • This command is executed on the target server
  • For ssh without a password, target server key must be sent to source server

example

Copy the contents of the demo1b instance on host awsvpn01, to the demo1bhdr instance on awsvpn02.

demo1bhdr@awsvpn02:/home/informix>infx restore demo1bhdr type=clone source=demo1b@awsvpn01

Your evaluation license will expire on 2012-06-26 00:00:00
onclean: Cleaning up processes and resources for 'demo1bhdr'...
onclean: Cannot open the file /home/informix/infx/inst/demo1bhdr/informixdir/etc/.conf.demo1bhdr.
Ensure that the value of the INFORMIXSERVER environment variable
matches the value of the DBSERVERNAME configuration parameter
from your onconfig file.
ifxclone --source=demo1b --sourceIP=awsvpn01 --sourcePort=62002 --target=demo1bhdr --targetIP=awsvpn02 --targetPort=62000 --useLocal --trusted --configParm=DIRECT_IO=1
Restoring clone server demo1bhdr from source server demo1b.
Look at online log for status of clone server...

The copy is forked into background.

Monitor progress of storage space restoires:

demo1bhdr@awsvpn02:/home/informix>infx dbspace

class  space    pg  flags                chks  size mb  free mb  used mb    used%  read mb  write mb  L0
warn   root     2k  READY RESTORED,AUTO     2   225.00   205.66    19.34    8.60%     0.09     13.33  2012-02-31 05:48
warn   plog     2k  READY RESTORED,AUTO     1   100.00     4.89    95.11   95.11%     0.00      0.01  2012-02-31 05:48
warn   log01    2k  READY RESTORED,AUTO     1   100.00     0.89    99.11   99.11%     0.00      0.01  2012-02-31 05:48
warn   log02    2k  READY RESTORED,AUTO     1   100.00     0.89    99.11   99.11%     0.00      0.01  2012-02-31 05:48
warn   dat01    2k  IP RESTORE,AUTO         1   100.00    27.94    72.06   72.06%     0.00     15.06  2012-02-31 05:48
error  dat02    2k  DOWN DOWN,AUTO          1    25.00    24.89     0.11    0.42%     0.00      0.00  2012-02-28 06:19
error  dat03    2k  DOWN DOWN,AUTO          1    25.00    24.89     0.11    0.42%     0.00      0.00  2012-02-28 06:19
error  dat04    2k  DOWN DOWN,AUTO          1    25.00    24.89     0.11    0.42%     0.00      0.00  2012-02-28 06:19
error  idx01    2k  DOWN DOWN,AUTO          1   100.00    39.99    60.01   60.01%     0.00      0.00  2012-02-28 06:19
error  idx02    2k  DOWN DOWN,AUTO          1    25.00    24.89     0.11    0.42%     0.00      0.00  2012-02-28 06:19
error  idx03    2k  DOWN DOWN,AUTO          1    25.00    24.89     0.11    0.42%     0.00      0.00  2012-02-28 06:19
error  idx04    2k  DOWN DOWN,AUTO          1    25.00    24.89     0.11    0.42%     0.00      0.00  2012-02-28 06:19
good   tmp01    2k  OK DOWN,TMP,AUTO        1    25.00    24.84     0.16    0.62%     0.00      0.00  never
good   tmp02    2k  OK DOWN,TMP,AUTO        1    25.00    24.89     0.11    0.42%     0.00      0.00  never
error  ltmp01   2k  DOWN DOWN,AUTO          1    25.00    24.89     0.11    0.42%     0.00      0.00  2012-02-28 06:19
error  blob01   8k  DOWN DOWN,BLBSPACE,AUTO 1    25.00    25.00     0.00    0.00%     0.01      0.00  2012-02-28 06:19
error  sblob01  2k  DOWN DOWN,SBSPACE,AUTO  3    65.00    -0.01    65.01  100.01%     0.01      0.00  2012-02-28 06:19
warn   new01    2k  LO DOWN,DBSCHG,AUTO     1   100.00    99.89     0.11    0.11%     0.00      0.00  never

Check online.log for messages or errors

demo1bhdr@awsvpn02:/home/informix>onstat -m

IBM Informix Dynamic Server Version 11.70.FC4TL -- Fast Recovery -- Up 00:00:31 -- 219180 Kbytes

Message Log File: /home/informix/infx/inst/demo1bhdr/logs/online.log
05:48:48  Physical Restore of dat03 Completed.
05:48:48  Checkpoint Completed:  duration was 0 seconds.
05:48:48  Sat Mar 31 - loguniq 29, logpos 0xa03018, timestamp: 0x115a4b Interval: 380

05:48:48  Maximum server connections 0
05:48:48  Physical Restore of dat04 started.

05:48:48  Checkpoint Completed:  duration was 0 seconds.
05:48:48  Sat Mar 31 - loguniq 29, logpos 0xa03018, timestamp: 0x115a58 Interval: 381

05:48:48  Maximum server connections 0
05:48:48  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 0

05:48:50  Physical Restore of dat04 Completed.
05:48:50  Checkpoint Completed:  duration was 0 seconds.
05:48:50  Sat Mar 31 - loguniq 29, logpos 0xa03018, timestamp: 0x115a5d Interval: 381

05:48:50  Maximum server connections 0
05:48:50  Physical Restore of idx01 started.

notes

  • Check the documentation of the Informix ifxclone utility for more information