Upgrade a Database Using Database Upgrade Assistant
– If you used DBUA to back up your database, then clicking Restore restores the original database and the original database settings from the backup.
– If you used your own backup procedure to back up the database, then clicking Restore restores only the original database settings. To restore the database itself, you must restore the backup you created with your own backup utilities.
If you are satisfied with the upgrade results, then click Exit to quit DBUA and use your newly upgraded database. DBUA removes the entry of the upgraded database from the old listener.ora file and reloads the listener of the old database.
Table 3–3 DBUA Command Line options
Option Description
-silent Specifies that DBUA should operate in silent mode.
-sid SID Specifies the system identifier (SID) of the database to upgrade
-oracleHome home_name Specifies the Oracle Database home directory of the database to upgrade
-oracleBasebase_name Specifies the Oracle Database base directory of the database to upgrade
-diagnosticDest diagnostic_
destination
Specifies the default location to store Oracle trace and diagnostic files. It replaces the initialization parameter settings for background dump destination and user dump destination from earlier releases.
-sysDBAUserNameSYSDBA_user Specifies a user with SYSDBA privileges.
-sysDBAPassword SYSDBA_pwd Specifies the password for SYSDBA_user.
-autoextendFiles This option autoextends database files during the upgrade. Data files revert to their original autoextend settings after the upgrade.
-newGlobalDbName db_name Specifies a new global database name. This option applies only if you are moving data files or upgrading an Oracle XE database.
-newSidnew_SID Specifies a new system identifier (SID) of the database to upgrade. This option applies only if you are moving data files or upgrading an Oracle XE database.
-generateMapFile If you specify this option, then DBUA only generates a database map file in the log location and then exits. This option applies only if you are moving data files or upgrading an Oracle XE database.
-useASM If the database to upgrade has an ASM instance, then this option tells DBUA to use it for the upgrade. This option applies only if you are moving data files or upgrading an Oracle XE database.
-commonFileLocation common_files Specifies a common location to store database files. This option applies only if you are moving data files or upgrading an Oracle XE database.
-omfLocationomf_area Specifies a database area for Oracle-Managed Files. This option applies only if you are moving data files or upgrading an Oracle XE database.
-databaseMapFile map_file_name Specifies the full name of the map file to map database files. This option applies only if you are moving data files or upgrading an Oracle XE database.
-newRecoveryArearecover_area Specifies the recovery area for a database that is moved during upgrade. This option applies only if you are moving data files or upgrading an Oracle XE database.
Upgrade a Database Using Database Upgrade Assistant
-newRecoveryAreaSize recover_size Specifies the recovery area size (MB) for a database that is moved during upgrade. This option applies only if you are moving data files or upgrading an Oracle XE database.
-apexAdminPasswordapex_pwd Specifies the password for the Application Express Administrator.
-disableUpgradeScriptLogging This option disables the detailed log generation for running SQL scripts during the upgrade process. This is enabled by default. To enable log generation, do not specify this option.
-backupLocation directory Specifies a directory to back up your database before the upgrade starts
-sysauxTablespace This option creates a new SYSAUX tablespace -datafileNamename Specifies the complete path of the data file for
creating the new SYSAUX tablespace
-datafileSize size Specifies the size of the data file for creating the new SYSAUX tablespace {500M, 10G}
-datafileSizeNextsize Specifies the next extent for the data file -datafileSizeMax size Specifies the maximum size of the data file -postUpgradeScripts script [,
script ] ... Specifies a comma-delimited list of SQL scripts.
Specify complete path names. The scripts are executed at the end of the upgrade.
-initParam parameter=value [, parameter=value ] ...
Specifies a comma-delimited list of initialization parameter values of the form name=value -disableArchiveLogMode This option turns off archiving and flashback
logging for the duration of the upgrade.
-recompile_invalid_objects true|false
When you specify true for this option, DBUA recompiles all invalid PL/SQL modules immediately after the upgrade is performed.
-degree_of_parallelismcpu_number Specifies the number of CPUs to be used for parallel recompilation.
-emConfiguration
{CENTRAL|LOCAL|ALL|NOBACKUP|
NOEMAIL|NONE}
Specifies Oracle Enterprise Manager management options:
■ CENTRAL - Database is centrally managed by Oracle Enterprise Manager.
■ LOCAL - Database is locally managed by Oracle Enterprise Manager.
■ ALL - This option configures Oracle Enterprise Manager Database Control, enables daily backups, and enables e-mail notifications
■ NOBACKUP - Automatic daily backups of the database are not enabled.
■ NOEMAIL - E-mail notifications are not enabled.
■ NONE - Database is not managed by Enterprise Manager.
Table 3–3 (Cont.) DBUA Command Line options
Option Description