3 data store upgrades – Oracle Audio Technologies B31679-01 User Manual

Page 6

Advertising
background image

vi

Oracle TimesTen In-Memory Database Installation Guide

3 Data Store Upgrades

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . 87

Data store compatibility . . . . . . . . . . . . . . . . . . . . 87
Data type compatibility . . . . . . . . . . . . . . . . . . . . 87
Data store character set . . . . . . . . . . . . . . . . . . . . 88

Data type conversion . . . . . . . . . . . . . . . . . . . . . . . 89

Converting data types to Oracle data types . . . . . . . . . . . . . 90
Upgrading data types as TimesTen data types . . . . . . . . . . . . 90

Data store character set conversion . . . . . . . . . . . . . . . . . 91

Converting from the TIMESTEN8 character set . . . . . . . . . . . 91
Converting from a character set

other than TIMESTEN8 . . . . . . . . . . . . . . . . . . . 92

Upgrade modes . . . . . . . . . . . . . . . . . . . . . . . . . 93

In-place upgrades . . . . . . . . . . . . . . . . . . . . . . . 93
Offline upgrades . . . . . . . . . . . . . . . . . . . . . . . 93
Online upgrades with replication . . . . . . . . . . . . . . . . . 94
Online upgrades with Client/Server. . . . . . . . . . . . . . . . 94

Performing an in-place data store upgrade . . . . . . . . . . . . . . 95

Unloading a data store . . . . . . . . . . . . . . . . . . . . . 95
Moving to a new patch release of TimesTen . . . . . . . . . . . . 96

Performing an offline upgrade . . . . . . . . . . . . . . . . . . . 97

Moving to a different directory . . . . . . . . . . . . . . . . . 98
Moving to a different machine. . . . . . . . . . . . . . . . . . 98
Reducing data store size . . . . . . . . . . . . . . . . . . . 100
Moving between 32-bit and 64-bit data stores. . . . . . . . . . . 101
Moving to a different major release of TimesTen . . . . . . . . . 101

Performing an online upgrade with replication . . . . . . . . . . . . 104

Overview . . . . . . . . . . . . . . . . . . . . . . . . . 104
Limitations . . . . . . . . . . . . . . . . . . . . . . . . 107
Requirements . . . . . . . . . . . . . . . . . . . . . . . 107
Online upgrade example . . . . . . . . . . . . . . . . . . . 108

Performing a Client/Server online upgrade from a TimesTen version prior to 6.0

113
Overview . . . . . . . . . . . . . . . . . . . . . . . . . .113
Limitations . . . . . . . . . . . . . . . . . . . . . . . . .114
Client/Server online upgrade example. . . . . . . . . . . . . . .114

Performing a Client/Server online upgrade from TimesTen version 6.0 and

above . . . . . . . . . . . . . . . . . . . . . . . . . . .116
Client/Server online upgrade . . . . . . . . . . . . . . . . . .116
Client/Server online upgrade with continuous access to the data store . .117

Record of Upgrades . . . . . . . . . . . . . . . . . . . . . . .117

Advertising