Problem Restoring A Database From Timesten With larger PERM And TEMP Size to a new system with smaller perm/temp size
Last updated on FEBRUARY 27, 2016
Applies to:Oracle TimesTen In-Memory Database - Version 11.2.1 and later
Information in this document applies to any platform.
Cannot restore db to different machine with different size.
The machine where the db is backup from has larger memory footprint. The machine where the restoring of the backup file has much smaller memory. This is the error encountered:
Restore started ...
ttRestore: SQL Error: Failed to connect to data store
*** [TimesTen][TimesTen 22.214.171.124.0 ODBC Driver][TimesTen]TT0703: Subdaemon connect to data store failed with error TT802 -- file "db.c", lineno 9759, procedure "sbDbConnect"
*** ODBC Error = 08001, TimesTen Error = 703
ttRestore: Failed connecting to data store after restore
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms