For very large databases, the
time required to completely re-create the database via the indirect methods may exclude them
as viable options.
The first direct method relies on the Database Upgrade Assistant (DBUA). DBUA is an
interactive tool that guides you through the upgrade process. DBUA evaluates your present
database configuration and recommends modifications that can be implemented during the
upgrade process. These recommendations may include the sizing of files and the specifications
for the new SYSAUX tablespace if you are upgrading from a version previous to 10g. After you
accept the recommendations, DBUA performs the upgrade in the background while a progress
panel is displayed. DBUA is very similar in approach to the Database Configuration Assistant
(DBCA). As discussed in Chapter 1 and the appendix, DBCA is a graphical interface to the steps
and parameters required to make the upgrade a success.
The second direct method is called a manual upgrade. Whereas DBUA runs scripts in the
background, the manual upgrade path involves database administrators running the scripts
themselves. The manual upgrade approach gives you a great deal of control, but it also adds
to the level of risk in the upgrade because you must perform the steps in the proper order.
52 Oracle Database 11g DBA Handbook
You can use the original Export and Import (or Oracle Data Pump Export/Import starting with
Oracle Database 10g) as an indirect method for upgrading a database.
Pages:
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142