create table tt
(
id char(10),
name char(20),
primary key(id)
) fragment by round robin in userdbs1,userdbs2,userdbs3;
database testdb;
create table tt
(
id char(10),
name char(20),
primary key(id)
) fragment by round robin in userdbs1,userdbs2,userdbs3;
create table tt_new
(
id char(10),
name char(20),
primary key(id)
) fragment by round robin in userdbs1,userdbs2,userdbs3;
insert into tt_new select * from tt;
restore to current;
informix@suse10:/opt/informix/tmp/test> archecker -tvs -f tt.sc
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
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/backup/logbak/
AC_LTAPEBLOCK 32 KB
Dropping old log control tables
Extracting table testdb:tt into testdb:tt_new
Archive file /opt/informix/backup/fullbak/suse10_0_L0
Tape type: Archive Backup Tape
OnLine version: IBM Informix Dynamic Server Version 11.50.UC6
Archive date: Sun Feb 20 17:25:45 2011
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: testdb:tt_new produced 100 rows.
Creating log control tables
Log file /opt/informix/backup/logbak/suse10_0_Log0000000060
Log tape backup date: Sun Feb 20 17:28:40 2011
Tape blocksize: 32768
Tape size: 2147483647
Tape number in series: 2
Log file /opt/informix/backup/logbak/suse10_0_Log0000000061
Log tape backup date: Sun Feb 20 17:28:44 2011
Tape blocksize: 32768
Tape size: 2147483647
Tape number in series: 3
Switching to log 61
Logically recovered testdb:tt_new Inserted 0 Deleted 0 Updated 0
2011-02-20 17:31:26
-----------------------------------------
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 [-tvs -f tt.sc]
STATUS: AC_STORAGE /tmp
STATUS: AC_MSGPATH /tmp/ac_msg.log
STATUS: AC_VERBOSE on
STATUS: AC_TAPEDEV /opt/informix/backup/fullbak/
STATUS: AC_TAPEBLOCK 1024 KB
STATUS: AC_LTAPEDEV /opt/informix/backup/logbak/
STATUS: AC_LTAPEBLOCK 32 KB
STATUS: AC_SCHEMA tt.sc
TIME: [2011-02-20 17:31:26] All old validation files removed.
STATUS: Dropping old log control tables
STATUS: SQL [SET INDEXES, TRIGGERS, CONSTRAINTS FOR tt_new DISABLED]
STATUS: Extracting table testdb:tt into testdb:tt_new
STATUS: Archive file /opt/informix/backup/fullbak/suse10_0_L0
STATUS: Tape type: Archive Backup Tape
STATUS: OnLine version: IBM Informix Dynamic Server Version 11.50.UC6
STATUS: Archive date: Sun Feb 20 17:25:45 2011
STATUS: Archive level: 0
STATUS: Tape blocksize: 1048576
STATUS: Tape size: 2147483647
STATUS: Tape number in series: 1
TIME: [2011-02-20 17:31:26] Phys Tape 1 started
STATUS: starting to scan dbspace 1 created on 2011-02-20 17:25:45.
STATUS: Archive timestamp 0X001D4847.
STATUS: starting to scan dbspace 7 created on 2011-02-20 17:25:45.
STATUS: Archive timestamp 0X001D4847.
STATUS: starting to scan dbspace 8 created on 2011-02-20 17:25:45.
STATUS: Archive timestamp 0X001D4847.
STATUS: starting to scan dbspace 9 created on 2011-02-20 17:25:45.
STATUS: Archive timestamp 0X001D4847.
STATUS: starting to scan dbspace 3 created on 2011-02-20 17:25:45.
STATUS: Archive timestamp 0X001D4847.
STATUS: starting to scan dbspace 4 created on 2011-02-20 17:25:45.
STATUS: Archive timestamp 0X001D4847.
STATUS: starting to scan dbspace 5 created on 2011-02-20 17:25:45.
STATUS: Archive timestamp 0X001D4847.
STATUS: starting to scan dbspace 6 created on 2011-02-20 17:25:45.
STATUS: Archive timestamp 0X001D4847.
STATUS: starting to scan dbspace 10 created on 2011-02-20 17:25:45.
STATUS: Archive timestamp 0X001D4847.
TIME: [2011-02-20 17:31:26] Found Partition tt in space userdbs1 (0x00A00002).
STATUS: starting to scan dbspace 11 created on 2011-02-20 17:25:45.
STATUS: Archive timestamp 0X001D4847.
TIME: [2011-02-20 17:31:26] Found Partition tt in space userdbs2 (0x00B00002).
STATUS: starting to scan dbspace 12 created on 2011-02-20 17:25:45.
STATUS: Archive timestamp 0X001D4847.
TIME: [2011-02-20 17:31:26] Found Partition tt in space userdbs3 (0x00C00002).
TIME: [2011-02-20 17:31:26] Tape 1 completed
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: testdb:tt_new produced 100 rows.
TIME: [2011-02-20 17:31:26] Physical Extraction Completed
STATUS: Creating log control tables
TIME: [2011-02-20 17:31:26] Log Stager started (pid = 12174)
TIME: [2011-02-20 17:31:26] Log Applier started (pid = 12173)
STATUS: Setting up log stream 1
STATUS: Starting recovery at log 60.
STATUS: Common rollforward point 0060:0x0038E:0x0018.
STATUS: Log file /opt/informix/backup/logbak/suse10_0_Log0000000060
STATUS: Log tape backup date: Sun Feb 20 17:28:40 2011
STATUS: Tape blocksize: 32768
STATUS: Tape size: 2147483647
STATUS: Tape number in series: 2
STATUS: Log tape log block header logid=60
TIME: [2011-02-20 17:31:27] Log Tape 60_2 started
WARNING: Not a complete buffer
TIME: [2011-02-20 17:31:27] Tape 2 completed
STATUS: Log file /opt/informix/backup/logbak/suse10_0_Log0000000061
STATUS: Log tape backup date: Sun Feb 20 17:28:44 2011
STATUS: Tape blocksize: 32768
STATUS: Tape size: 2147483647
STATUS: Tape number in series: 3
STATUS: Log tape log block header logid=61
TIME: [2011-02-20 17:31:27] Log Tape 61_3 started
TIME: [2011-02-20 17:31:27] Switching to log 61
WARNING: Not a complete buffer
TIME: [2011-02-20 17:31:27] Tape 3 completed
TIME: [2011-02-20 17:31:27] Scanner (12174) is done scanning logs
STATUS: Log stager elapsed processing time 00 H 00 M 00.091 S
TIME: [2011-02-20 17:31:27] Unload Completed
STATUS: archecker completed staging pid = 12174 exit code: 2
STATUS: SQL [SET INDEXES, TRIGGERS, CONSTRAINTS FOR tt_new ENABLED]
STATUS: Logically recovered testdb:tt_new Inserted 0 Deleted 0 Updated 0
STATUS: Log applier processing time 00 H 00 M 01.064 S
TIME: [2011-02-20 17:31:27] Unload Completed
STATUS: archecker completed applying pid = 12173 exit code: 0
欢迎光临 Chinaunix (http://bbs.chinaunix.net/) | Powered by Discuz! X3.2 |