|  | 
| 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 ) | 
