Oracle Audio Technologies B31679-01 manual Moving to a different directory

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.

98Oracle TimesTen In-Memory Database Installation Guide