× News Cego SysMT Croom Web Statistics Impressum
SysMT Logo
Special October 2025 - From scrarch recovery with online backup
Category : Admin
Level : Easy
Back to Overview

TODO

lisa:~/work/cego-2.52.33/samples/chkdb $ ./mkdb TS1
Init database xml ...... operation ok
Creating admin user ...... operation ok
Creating role ...... operation ok
Creating database user ...... operation ok
Defining tableset TS1...... operation ok
Creating tableset TS1...... operation ok
Adding tableset TS1 to role ...... operation ok
lisa:~/work/cego-2.52.33/samples/chkdb $ ./chkadm 
CGADM > add archlog al1 path './arch' to TS1;
Archlog added
ok ( 0.000 s )
CGADM > set logmng 'NONE';
Log manager set
ok ( 0.000 s )
CGADM > set backupmng './backupManager';
Backup manager set
ok ( 0.000 s )
CGADM > enable archlog for TS1;
Arch mode enabled
ok ( 0.000 s )
CGADM > quit;
lisa:~/work/cego-2.52.33/samples/chkdb $ ./chkclt
Connected to Cego ( Version 2.52.33 )
CGCLT > create table t1 ( a int, b string(30));
Table t1 created
ok ( 0.001 s )
CGCLT > insert into t1 values ( 1, 'XXX');
1 tuples inserted
ok ( 0.001 s )
CGCLT > insert into t1 values ( 2, 'XXX');
1 tuples inserted
ok ( 0.000 s )
CGCLT > insert into t1 values ( 3, 'XXX');
1 tuples inserted
ok ( 0.000 s )
CGCLT > quit;
Goodbye
ok ( 0.000 s )
lisa:~/work/cego-2.52.33/samples/chkdb $ ./chkadm 
CGADM > begin backup for TS1;
Backup mode started
ok ( 0.006 s )
CGADM > backup tableset TS1;
Starting backup ..
a ./db/TS1_ticket.xml
a ./db/TS1.sys
a ./db/TS1.temp
a ./db/TS1_data.dat
Backup finished successful
Backup execution status : OK
ok ( 0.226 s )
CGADM > end backup for TS1;
Backup mode finished
ok ( 0.005 s )
CGADM > stop tableset TS1;
Tableset TS1 stopped
ok ( 4.017 s )
CGADM > drop tableset TS1;
Tableset TS1 dropped
ok ( 0.006 s )
CGADM > list tableset;
+---------------------+-----------+-----------+------+------+------+------+
| TS                  | TS        | TS        | TS   |   TS |   TS |   TS |
| NAME                | RUNSTATE  | SYNCSTATE | ARCH |  SYS | TEMP |  APP |
+---------------------+-----------+-----------+------+------+------+------+
| TS1                 | DEFINED   | SYNCHED   | ON   |   0% |   0% |   0% |
+---------------------+-----------+-----------+------+------+------+------+
Tableset list
ok ( 0.000 s )
CGADM > list backup for TS1;
+--------------------------+--------------------------+
|               BACKUPLIST |               BACKUPLIST |
|                       ID |                       TS |
+--------------------------+--------------------------+
|                        1 |      2025-10-26 12:39:32 |
+--------------------------+--------------------------+
Backup info
ok ( 0.025 s )
CGADM > restore tableset TS1 from '1';
Starting restore ..
x ./db/TS1_ticket.xml
x ./db/TS1.sys
x ./db/TS1.temp
x ./db/TS1_data.dat
Restore finished successful
Restore execution status : OK
ok ( 0.053 s )
CGADM > list tableset;
+---------------------+-----------+-----------+------+------+------+------+
| TS                  | TS        | TS        | TS   |   TS |   TS |   TS |
| NAME                | RUNSTATE  | SYNCSTATE | ARCH |  SYS | TEMP |  APP |
+---------------------+-----------+-----------+------+------+------+------+
| TS1                 | DEFINED   | SYNCHED   | ON   |   0% |   0% |   0% |
+---------------------+-----------+-----------+------+------+------+------+
Tableset list
ok ( 0.001 s )
CGADM > recover tableset TS1;
Releasing log files ...
Stopping log ...
Registering datafiles ...
Registering objects ...
Committed lsn is 6
Datafile recovery with ./arch/TS1-2-000000000006.dbf
Starting up-to-crash recovery ...
Transaction recovery with ./arch/TS1-2-000000000006.dbf
Transaction recovery with ./arch/TS1-2-000000000008.dbf
Init logfiles ...
Starting log ...
Writing final checkpoint ...
Tableset recovered to lsn 9
Recover completed
ok ( 4.035 s )
CGADM > quit;
lisa:~/work/cego-2.52.33/samples/chkdb $ ./chkclt
Connected to Cego ( Version 2.52.33 )
CGCLT > select * from t1;
+-----------+-----+
|        t1 |  t1 |
|         a |   b |
+-----------+-----+
|         1 | XXX |
|         2 | XXX |
|         3 | XXX |
+-----------+-----+
3 tuples
ok ( 0.001 s )
CGCLT > quit;
Goodbye
ok ( 0.000 s )