Wednesday, November 23, 2011

5 ways to perform Oracle Database Up-gradation


1) DBUA (Database Upgrade Assistant) 

  1. Interactive
  2. Automated up gradation steps
  3. Provides configuration recommendation e.g. tablespaces and redologs
  4. Comparatively difficult to diagnose if there is a problem

2) Manual upgrade
  1. Manual SQL scripts execution
  2. Gives more control as easier to diagnose the error
  3. Can would if source and target Home are on different servers unlike DBCA
  4. More chance of failure if even a single step is missed out

3) Export/Import

  1. Can be performed while the existing database is up and running
  2. Disk placement of data can cause unexpected performance problems
  3. Compares to DBUA /Manual takes long time to upgrade

4) Data Copying 
  1. Can use INSERT INTO and CREATE TABLE...AS statements
  2. Can copy data from one database to another using database links
  3. Same advantages as Export/Import method
  4. Can copy only specified database objects or users
  5. Unlike EXPORT/IMPORT, rows can be filtered out to be placed in new database

5) Golden Gate



The Upgrade Path to Oracle 11g: 


(source: OCP Oracle database new features for Admin 1z0-050)

Depending on your current database release, you may or may not be able to directly upgrade to the Oracle Database 11g Release 1 (11.1) version. You can directly upgrade to Oracle Database Release 1 if your current database is based on an Oracle 9.2.0.4 or newer release. For Oracle database releases older than Oracle 9.2.0.4, you have to migrate via one or two intermediate releases, as shown by the following 
upgrade paths:

■ 7.3.3 (or lower) => 7.3.4 => 9.2.0.8 => 11.1
■ 8.0.5 (or lower) => 8.0.6 => 9.2.0.8 => 11.1
■ 8.1.7 (or lower) => 8.1.7.4 => 9.2.0.8 => 11.1
■ 9.0.1.3 (or lower) => 9.0.1.4 => 9.2.0.8 => 11.1
■ 9.2.0.3 (or lower) => 9.2.0.8 => 11.1

For example, if you want to upgrade a database from the 8.1.6 release, the following would be your game plan: upgrade release 8.1.6 to 8.1.7; upgrade 8.1.7 to release 9.2.0.8; upgrade release 9.2.0.8 to release 11.1

No comments:

Post a Comment