TimesTen一些管理命令:
1.ttdaemonadmin
启停服务
C:\Documents and
Settings\ChenLi>ttdaemonadmin -stop
TimesTen Data Manager 11.2.1 服务正在停止...
TimesTen Data Manager 11.2.1 服务已成功停止。
C:\Documents and
Settings\ChenLi>ttdaemonadmin -start
TimesTen Data Manager 11.2.1 服务正在启动 .
TimesTen Data Manager 11.2.1 服务已经启动成功。
2.ttisql datastoreName
登录dataStore
C:\Documents and
Settings\ChenLi>ttisql test
Copyright (c) 1996-2009, Oracle. All rights
reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "DSN=test";
Connection successful:
DSN=test;UID=ChenLi;DataStore=F:\Timesten\DataSore\TEST\;
……
--内部用户登录:
C:\Documents and
Settings\ChenLi>ttisql "dsn=test;uid=tt;pwd=tt"
Copyright (c) 1996-2009, Oracle. All rights
reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "dsn=test;uid=tt;pwd=tt";
Connection successful:
DSN=test;UID=tt;DataStore=F:\Timesten\DataSore\TEST\;
……
3.ttStatus
查看timesten服务/进程状态
C:\Documents and
Settings\ChenLi>ttstatus
TimesTen status report as of Tue Sep 22
22:16:14 2009
Daemon pid 2616 port 53384 instance tt1121_32
TimesTen server pid 1748 started on port 53385
------------------------------------------------------------------------
Data store f:\timesten\datasore\TEST
There are 11 connections to the data store
Shared Memory KEY Global\TEST.SHM.19 HANDLE 0x224
Type
PID
Context
Connection
Name
ConnID
Process
3112
0x00de48e8
test
1
Subdaemon
916
0x006cc398
Manager
2032
Subdaemon
916
0x007212c8
Rollback
2033
Subdaemon
916
0x0110cf48
Flusher
2034
Subdaemon
916
0x011820e8
Monitor
2035
Subdaemon
916
0x011d7018 Deadlock
Detector
2036
Subdaemon
916
0x0122bf48
Checkpoint
2037
Subdaemon
916
0x1b910078
Aging
2038
Subdaemon
916
0x1b964fa8 Log
Marker
2039
Subdaemon
916
0x1b9b9ed8
AsyncMV
2040
Subdaemon
916
0x1ba0ee08
HistGC
2041
RAM residence policy: When In Use and 30 Seconds
Longer
Replication policy : Manual
Cache Agent policy : Manual
------------------------------------------------------------------------
Accessible by group BUILTIN\Administrators
End of report
4.ttAdmin
指定内存加载策略,具体查看帮助 ttadmin --help
-ramPolicy:
always
The data store should remain in system RAM all the time.
manual
The data store is loaded in system RAM manually by the user
(via the -ramLoad option).
inUse
The data store is loaded in system RAM when in use (i.e.,
when
applications are connected). This is the
default. The -ramGrace
option may be used to modify the behavior of this policy.
5.ttBulkCp -i/-o
数据导入、导出。只导出数据,字段数据可指定分隔符。
ttBulkCp -o –s "|" ttcore departments
dept.dat
6.ttbackup
备份datastore,功能类似rman,支持全量、增量、stream备份
--全备
ttBackup -type [fileFullEnable | fileIncrOrFull] -dir
BackupDirectory
ttcore
--增量
ttBackup -type [fileIncremental |fileIncrOrFull ] -dir
BackupDirectory
ttcore
7.ttRestore
恢复ttbackup 备份的数据;不覆盖已存在的数据
ttRestore -dir BackupDirectory ttcore
8.ttDestroy
删除datastore,可用ttRestore恢复已备份的datastore
ttDestroy ttcore
9.ttSchema
查看表、索引、试图、等对象的DDL语句
ttSchema –list tables,views ttcore inven%
10.ttMigrate
迁移工具。用于升级、重建、回退datastore.
ttMigrate -c ttcore BinaryDataFile
--To be continue--
分享到:
相关推荐
129255-oracle_timesten_in-memory_database129255-oracle_timesten_in-memory_database129255-oracle_timesten_in-memory_database129255-oracle_timesten_in-memory_database
TimesTen Patchset 17019459 -01 Description TIMESTEN 11.2.1.9.9 RELEASE Product Oracle TimesTen In-Memory Database Release TimesTen 11.2.1.9.9
TimesTen安装配置-Oracle 内存数据库
Oracle TimesTen API 和 SQL 参考指南,不可多得的资料。
Oracle公司下缓存数据库TimesTen,大多用于电信,金融等行业,对数据读取要求较高行业,
TimesTen常用命令,方便初学者学习使用
TimesTen 驱动包5-8
Oracle® TimesTen In-Memory Database Installation Guide Release 11.2.1
Oracle TimesTen In-Memory Database TTClasses Guide 11g Release 2 (11.2.2)-114
Oracle TimesTen In-Memory Database Reference 11g Release 2 (11.2.2)-542
Oracle TimesTen In-Memory Database SQL Reference 11g Release 2 (11.2.2)-498
Oracle TimesTen In-Memory Database SQL Reference Guide Release 7.0
Oracle TimesTen Application-Tier Database Cache Introduction 11g Release 2 (11.2.2)-74
Oracle TimesTen In-Memory Database Troubleshooting Guide 11g Release 2 (11.2.2)-124
Oracle TimesTen In-Memory Database Replication Guide 11g Release 2 (11.2.2)-310
Oracle TimesTen In-Memory Database Operations Guide 11g Release 2 (11.2.2)-302
Oracle TimesTen In-Memory Database Installation Guide 11g Release 2 (11.2.2)-120
Oracle TimesTen In-Memory Database Error Messages and SNMP Traps 11g Release 2 (11.2.2)-346
Oracle TimesTen In-Memory Database System Tables and Views Reference 11g Release 2 (11.2.2)-140
Oracle Enterprise Manager for Oracle TimesTen In-Memory Database Release Notes Release 12.1.0.3.0