INFORMIX表级恢复

目的: 使用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.检查表恢复..

表级恢复的表模式文件,可以定义多种恢复,具体参考

参考文献: