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.
