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.