blogger

    blogger
  • hot log

  • comment

    twitter

    • 空间续费,加上ssl连接。。

      2018-11-22 01:04

    • 12.10.xC6出来时候碰到"Could not determine encryption mode from page zero",竟果然是BUG!http://www-01.ibm.com/support/docview.wss?rs=630&uid=swg21973408

      2015-12-21 20:15

    • 空间已经转移到新加坡,希望会好一些。

      2015-11-16 14:34

    • 增加新域名liaosnet.cc,与liaosnet.com同指向。

      2015-10-09 15:25

    • 空间迁移到香港。或许速度会快一点。。

      2014-02-13 20:10

    • More»

    blog sort

    links

    record

    banner

    INFORMIX表级恢复

    暗夜星空's Memory from Jan 30 , 2011 at 11:36 AM , under Category:IFX/GBase

    目的: 使用archecker从备机中进行表级恢复.
    环境: rhel4.7,ids11.50uc5

    注:archecker只恢复已经备份的0级备份及逻辑日志备份中的日志。

    步骤:
    1.建立测试表t1(id char(10),name char(10),info(10)),并insert一些记录.
    2.对数据库进行0级备份(可使用ontape或者onbar,这两种备份在进行archecker表级恢复时有所区别,需注意).
    3.检查备份
        onbar备份:onbar -v 或者 archecker -bvs
        ontape备份:archecker -tvs
          (注:在使用ontape备份时发现ac_msg.log中,dbspace/table检查都通过,最后出现"STATUS: archecker completed Validation pid = 24032 exit code: 3",但不影响表恢复.why?)
        确认备份是正常的..
    4.删除测试表t1
    5.创建表恢复模式文件t1.cmd
       database dbmon;             --对应库名.
       create table t1
       (  id   char(10),
          name char(10),
          info char(10)
       ) in rootdbs;               --源表(即存在于备份中的表,及所在的dbspace.)
       create table t1
       (  id   char(10),
          name char(10),
          info char(10)
       );                          --目标表结构,表明恢复后的表.
       insert into t1 select * from t1; --insert到目标表,从源表读取数据.
       restore to current;              --可选,恢复到的时间点,在使用时间点恢复的时候需要设置GL_DATETIME环境变量,如GL_DATETIME="%Y-%m-%d %H:%M:%S", 例:restore to "2010-09-09 15:52:00";

    6.执用恢复
       onbar备份:  archecker -bvs -f t1.cmd
       ontape备份: archecker -tvs -f t1.cmd

    以下是一个ontape备份的表恢复ac_msg.log

    IBM Informix Dynamic Server Version 11. 50. UC5 
    Program Name:  archecker
    Version:  8. 0
    Released:  2009- 07- 14 19: 19: 21
    CSDK:  IBM Informix CSDK Version 3. 50
    ESQL:  IBM Informix- ESQL Version 3. 50. UC4 
    Compiled:  07/ 14/ 09 19: 19 on Linux 2. 6. 9- 34. ELsmp # 1 SMP Fri Feb 24 16: 54: 53 EST 2006 

    AC_STORAGE / tmp
    AC_MSGPATH / tmp/ ac_msg. log
    AC_VERBOSE on
    AC_TAPEDEV / opt/ informix/ backup/ fullbak/
    AC_TAPEBLOCK 1024 KB
    AC_LTAPEDEV / opt/ informix/ lp
    AC_LTAPEBLOCK 32 KB
    Dropping old log  control tables
    Extracting table dbmon: t1 into dbmon: t1
    Archive file  / opt/ informix/ backup/ fullbak/ suse10_0_L0
    Tape type:  Archive Backup Tape
    OnLine version:  IBM Informix Dynamic Server Version 11. 50. UC5 
    Archive date:  Thu Nov 26 15: 12: 29 2009
    Archive level:  0
    Tape blocksize:  1048576
    Tape size:  2147483647
    Tape number in series:  1

    Scan PASSED
    Control page checks PASSED
    Table checks PASSED
    Table extraction commands 1
    Tables found on archive 1
    LOADED:  dbmon: t1 produced 2 rows.
    Creating log  control tables

    Please put in log  tape with log  id 8.
    Type < return >  or  0 to end:  

    Read / Write  End Of Medium enabled:  blocks =  0

    Logically recovered dbmon: t1 Inserted 0 Deleted 0 Updated 0


    以下是onbar备份的表恢复ac_msg.log

     

    2010-09-09 15:54:10

    -----------------------------------------

    STATUS: IBM Informix Dynamic Server Version 11.50.UC6

    Program Name:   archecker

    Version:        8.0

    Released:       2009-12-15 21:59:36

    CSDK:           IBM Informix CSDK Version 3.50

    ESQL:           IBM Informix-ESQL Version 3.50.UC4

    Compiled:       12/15/09 21:59  on Linux 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:54:53 EST 2006


    STATUS: Arguments [-bvs -f t1.cmd]

    STATUS: AC_STORAGE               /tmp

    STATUS: AC_MSGPATH               /tmp/ac_msg.log

    STATUS: AC_VERBOSE               on

    STATUS: AC_TAPEBLOCK             62 KB

    STATUS: AC_IXBAR                 /opt/informix/etc/ixbar.0

    STATUS: AC_SCHEMA                t1.cmd

    TIME: [2010-09-09 15:54:10] All old validation files removed.

    STATUS: Dropping old log control tables

    STATUS: SQL [SET  INDEXES, TRIGGERS,  CONSTRAINTS FOR t1 DISABLED]

    STATUS: Extracting table tt:t1 into tt:t1

    STATUS: Determined Storage Manager to be ism.

    STATUS: starting to scan dbspace 4 created on 2010-09-09 15:50:11.

    STATUS: Archive timestamp 0X001213EA.

    TIME: [2010-09-09 15:54:11] Found Partition t1 in space workdbs (0x00400041).

    STATUS: Scan PASSED

    STATUS: Control page checks PASSED

    STATUS: Table checks PASSED

    STATUS: Table extraction commands 1

    STATUS: Tables found on archive 1

    STATUS: LOADED: tt:t1 produced 1000 rows.

    TIME: [2010-09-09 15:54:12] Physical Extraction Completed

    STATUS: Creating log control tables

    TIME: [2010-09-09 15:54:12] Log Stager started (pid = 19106)

    TIME: [2010-09-09 15:54:12] Log Applier started (pid = 19100)

    STATUS: Setting up log stream 1

    STATUS: Determined Storage Manager to be ism.

    STATUS: Starting recovery at log 43.

    STATUS: Common rollforward point 0043:0x00043:0x0018.

    STATUS: Staging Log 43

    STATUS: Determined Storage Manager to be ism.

    STATUS: Staging Log 44

    TIME: [2010-09-09 15:54:14] Switching to log 44

    STATUS: Determined Storage Manager to be ism.

    STATUS: All logstreams have been staged by stager 19106

    TIME: [2010-09-09 15:54:15] Scanner (19106) is done scanning logs

    STATUS: Log stager elapsed processing time 00 H 00 M 02.855 S

    TIME: [2010-09-09 15:54:15] Unload Completed




    STATUS: archecker completed staging pid = 19106 exit code: 0

    STATUS: SQL [SET INDEXES, TRIGGERS, CONSTRAINTS FOR t1 ENABLED]

    STATUS: Logically recovered tt:t1 Inserted 1 Deleted 0 Updated 0

    STATUS: Log applier processing time 00 H 00 M 03.018 S

    TIME: [2010-09-09 15:54:15] Unload Completed




    STATUS: archecker completed applying pid = 19100 exit code: 0

     


    7.检查表恢复..

    表级恢复的表模式文件,可以定义多种恢复,具体参考<IBM Informix 备份与恢复指南 V11.0>

    参考文献:<IBM Informix备份与恢复指南 V11.0>