Oracle Audio Technologies B31679-01 - Manual (Page 106)

98 Oracle TimesTen In-Memory Database Installation Guide
Note: After ttMigrate has been used, all autorefresh cache groups in
the destination data store have AUTOREFRESH STATE set to OFF, no
matter how it was set on the source data store. Reset AUTOREFRESH
STATE to ON by using the
ALTER CACHE GROUP statement.
Moving to a different directory
The TimesTen daemon identifies a data store by the full path name of
the data store’s checkpoint files. To move a TimesTen data store to a
different directory, back up the data store using the
ttBackup utility,
create a new DSN definition that specifies the new data store pathname,
then restore the data store into its new location using the
ttRestore
utility. When you have verified that the data store functions properly in
the new location, free up the disk space by using
ttDestroy to remove
the old data store.
For example, to move a data store from /old/SalesData/sales with a
data store name SalesData ( "DSN=SalesData ") to /new/SalesData/
sales with data store name NewSalesData ( "DSN=NewSalesData" ),
using the /tmp/dump directory for temporary storage, use the
commands:
1. mkdir /tmp/dump
2. ttBackup -dir /tmp/dump -fname salesdata "DSN=SalesData"
3. Create a DSN definition for the NewSalesData data store and specify
the new data store path: /new/SalesData/sales/NewSalesData .
4. ttRestore -dir /tmp/dump -fname salesdata
"DSN=NewSalesData"
(Verify that NewSalesData is operational.)
5. rm -r /tmp/dump
6. ttDestroy /old/SalesData/sales/SalesData
7. Remove the DSN definition for the SalesData data store.
Note: You must reconfigure replication if the data store has been
configured to replicate.
Moving to a different machine
You can also use the ttBackup and ttRestore utilities to move a data
store between two machines that have the same CPU architecture and
are running the same operating system.