timesten備份還原，timesten備份

timesten備份還原，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.