timesten备份和恢复

ttIsql "DSN=ttwind;UID=cacheuser;PWD=cacheuser;OraclePWD=cacheuser;"

--1.查看当前版本号

Command> version
TimesTen Release 11.2.2.7.0

Command> cachegroups;

Cache Group CACHEUSER.CACHETBLORDERS:

Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: On
Autorefresh Interval: 10 Seconds
Autorefresh Status: ok
Aging: No aging defined

Root Table: SCOTT.TBLORDERS
Table Type: Read Only

Command> select count(*) from scott.tblorders;
< 111001 >

--2.断开到TT的全部连接

--3.备份数据库

mkdir /backup

ttBackup -type fileFull -dir /backup -fname ttwindbk -force -connstr "DSN=ttwind"

--4.删除cachegroup

ttIsql "DSN=ttwind;UID=cacheuser;PWD=cacheuser;OraclePWD=cacheuser;"

call ttcachestop;

DROP Cache Group cachetblorders;

exit;

--5.卸载内存

ttDaemonAdmin -stop

ttadmin -ramunload ttwind --二选一

--6.毁坏数据库

ttDestroy ttwind;

--7.删除原来数据

rm -rf /app/timesten/TimesTen/ttwind/info/datastore/ttwind.ds*

rm -rf /app/timesten/TimesTen/ttwind/info/datastore/ttwind.log*

rm -rf /app/timesten/TimesTen/ttwind/info/datastore/ttwind.res**

--8.恢复数据

ttDaemonAdmin -start

ttRestore -dir /backup -fname ttwindbk -noconn -connstr "DSN=ttwind"

/******常见错误
Error 12133: TT12133: Data store file already exists -- file "restore.c", lineno 1006, procedure "doRestore"

Error 12134: TT12134: Log file(s) already exist -- file "restore.c", lineno 1040, procedure "doRestore"

解决的方法:
rm -rf /app/timesten/TimesTen/ttwind/info/datastore/ttwind.ds*

rm -rf /app/timesten/TimesTen/ttwind/info/datastore/ttwind.log*

rm -rf /app/timesten/TimesTen/ttwind/info/datastore/ttwind.res**

*********/

ttIsql "DSN=ttwind;UID=cacheuser;PWD=cacheuser;OraclePWD=cacheuser;"

call ttCacheStart;

---9.验证恢复结果

Command> cachegroups;

Cache Group CACHEUSER.CACHETBLORDERS:

Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: On
Autorefresh Interval: 10 Seconds
Autorefresh Status: C
Aging: No aging defined

Root Table: SCOTT.TBLORDERS
Table Type: Read Only

1 cache group found.
Command> select count(*) from scott.tblorders;
< 111001 >
1 row found.