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

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

参考文献: