Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Approach for upgrade 11g database to 19c database Inquiry

in Database Install/Upgrade/Opatch (MOSC) 3 commentsAnswered

Source database version:11.2.0.2

Source OS:Solaris 10

Target database version:19.5

Source OS:Solaris 11

Database size :450 GB

Storage :File system storage

Shortlisted some method to fulfill the requirement

  1. Data Pump expdp/impdp
  2. i) Using DBUA upgrade 11.2.0.2 to 11.2.0.4 at Solaris 10 ii) Using Full Transportable Export/Import to migrate database from Solaris 10 to Solaris 11
  3. i) Using DBUA upgrade 11.2.0.2 to 11.2.0.4 at Solaris 10 ii) Do RMAN backup 11.2.0.4 DB at Solaris 10 , transfer backupset to Solaris 11 server iii) Using RMAN recover 11.2.0.4 DB at Solaris 11 iv) Using DBUA upgrade 11.2.0.4 to 19.5 at Solaris 10

Anyone have any idea how to estimate duration for each method above ? or got any other approach can achieve target ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center