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

Data Store Upgrades 107
After the above procedures have been carried out on the upgrade
system, the active system can be upgraded using the same steps.
Limitations
Online upgrades can be performed only on data stores for which all the
user tables meet the replication requirements. All the user tables must
contain either a PRIMARY KEY declaration or have a unique index
declared over non-nullable columns.
Requirements
To perform online upgrades with replication, replication must be
configured to use static ports. See
“Dynamic vs. static port assignments”
on page 55 of the TimesTen to TimesTen Replication Guide .
If you are performing an online upgrade on a single system where a
bidirectional replication configuration does not already exist, you must
make sure that enough memory and disk space is available to support
two copies of the data store being upgraded. Both the original data store
and its copy will be active for the duration of the upgrade. To maintain
the performance of your production applications, you may wish to
create the copy of the data store on a second system.
Additional disk space must be allocated to hold a backup copy of the
data store made by the
ttMigrate utility. The size of the backup copy is
typically about the same as the in-use size of the data store. This size
may be determined by querying the
sys.monitor table, using ttIsql :
Command> SELECT perm_in_use_size FROM sys.monitor;
16. Wait for all of the updates to
propagate to the upgrade system.
17. Reconnect all applications to the
upgrade data store.