TimesTen的一次简单的备份和恢复

TimesTen的一次简单的备份和恢复

ttBackup -type fileFull -dir /ttadmin/backup -fname backup_tt_20110607.bak "dsn=instance;uid=user;pwd=pass"

ttdestroy instance
Failed to destroy data store: TT0839: Cannot access data store because it is in use. A data store may be considered to be in use due to its RAM Policy setting, even though there are no active connections to it. -- file "db.c", lineno 22173, procedure "sbDbDestroy"

ttdaemonadmin -stop或者ttadmin -stop;ttadmin -ramunload instance
TimesTen Daemon stopped.

ttdestroy instance
ttDestroy: TimesTen daemon is not running

ttdaemonadmin -start
TimesTen Daemon startup OK.

ttdestroy master1

ttrestore -fname backup_tt_20110607.bak -dir /ttadmin/backup instance
Restore started ...
Restore complete

ttadmin -ramload instance

ttadmin -ramLoad instance
ttAdmin: TimesTen Error: 10009; RAM load ignored due to ramPolicy setting

ttdaemonadmin -start
Daemon is already running (port 53366, pid 3232124)

ttadmin -ramPolicy Manual instance
RAM Residence Policy            : manual
Manually Loaded In RAM          : False
Replication Agent Policy        : manual
Replication Manually Started    : False
Cache Agent Policy              : manual
Cache Agent Manually Started    : False

ttadmin -ramload instance --OK 启动成功