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.