Overview of Timesten:
Oracle TimesTen In-Memory Database (TimesTen) is a full-featured, memory-optimized, relational database with persistence and recoverability. It provides applications with the instant responsiveness and very high throughput required by database-intensive applications. Deployed in the application tier, TimesTen operates on databases that fit entirely in physical memory (RAM). Applications access the TimesTen database using standard SQL interfaces. For customers with existing application data residing on the Oracle Database, TimesTen is deployed as an in-memory cache database with automatic data synchronization between TimesTen and the Oracle Database.
Timesten Datasource Refresh:
Step 1: Take backup. (Source)
/export/TimesTen/7.0.5_64/bin/ttbackup -dir /var/tmp -fname PROD_DATASTORE_081010_Bkp DSNNAME
Step 2: Scp dumps to Target.
Step 3: Destroy the DSN(Target)
hostname% ./ttdestroy DSNNAME
hostname% ./ttstatus
TimesTen status report as of Mon Oct 11 2010
Daemon pid 10251 port 53388 instance tt1121
TimesTen server pid 10256 started on port 53389
------------------------------------------------------------------------
Accessible by group cheops
End of report
Step 4: Start restore
hostname% ./ttrestore -fname PROD_DATASTORE_081010_Bkp -dir /var/tmp DSNNAME
Restore started ...
ttRestore: SQL Warning: Connected to data store with warning
*** [TimesTen][TimesTen 11.2.1.6.1 ODBC Driver][TimesTen]TT6200: New value for permanent data partition size ignored since smaller than current value of 10240 megabytes -- file "db.c", lineno 10141, procedure "sbDbConnect"
*** ODBC Warning = 01000, TimesTen Warning = 6200 ( HAVE TO CHANGE PERMSIZE VALUE)
Restore complete
Some times we might encounter above warning. It is because the permsize is different from source & target. We have to change the permsize in sys.odbc.ini.
Changing sys.odbc.ini file.
hostname% cd /var/TimesTen/tt11
hostname% cp -p sys.odbc.ini sys.odbc.ini_sep11_2010
hostname% vi sys.odbc.ini
change PermSizeà 10240
We have to do below steps in order to apply the new value.
Step 5: make rampolicy manual.
hostname% ./ttAdmin -rampolicy manual DSNNAME
Step 6: Ram unload and load it
hostname% ./ttAdmin -ramunload DSNNAME
hostname% ./ttAdmin -ramload DSNNAME
hostname% ./ttisql DSNNAME
Copyright (c) 1996-2010, Oracle. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
Step 7: drop replications.
Command> repschemes;
Replication Scheme REPL.PROD:
Store: PROD_DS on HOSTNAME
Port: (auto)
Log Fail Threshold: (none)
Retry Timeout: 120 seconds
Compress Traffic: Disabled
1 replication scheme found.
Command> drop replication REPL.PROD;
Command> repschemes;
0 replication schemes found.
Step 8: Delete bookmark.
Command> delete xladeletebookmark
Read Log File: 1286099029
Read Offset: 1705274
Purge Log File: 1310
Purge Offset: 55749560
PID: 1868
In Use: No
1 bookmark found.
Command> xladeletebookmark PROD_bookmark;
Command> xladeletebookmark;
0 bookmarks found.
Command>
Command>
Step 9: Create the users which are requested by user.
Command> create user USERNAME identified by 'PASSWORD';
Step 10: Make Rampolicy to always.
hostname% ./ttAdmin -rampolicy always DSNNAME
No comments:
Post a Comment