13 Replies Latest reply: Feb 22, 2014 4:58 AM by Andy.....! RSS

How to upgrade database 10g to 11g with the minimum downtime?

Andy.....! Newbie
Currently Being Moderated

Hi all,

 

We want to upgrade our 10.2.0.4 RAC linux database to 11.2.0.3 RAC linux. We have two different servers where one is the production server (10.2.0.4) and another is the 11.2.0.3 server.

Here we want to minimize the downtime of production database.

 

Our db size is near by 1 Tb. If we go with the traditional method of upgradation like given below then it will take near by 15 hrs:

1. Take RMAN bkp of 10g.

2. Transfer it to 11g server.

3. Restore the db.

4. Upgrade the database.

 

I got the two methods to minimize the downtime which are as follow but I am not sure these ways are feasible or not...

 

1st Method :

Here our source db server is 10.2.0.4 and target db server is 11.2.0.3.

 

1. Create a DR on target server. (10.2.0.4)

-Here we have installed db software(stand alone) of 10.2.0.4 on target server as well as 11.2.0.3 rac linux.

-All datafiles of DR will be on filesystem(not on ASM).

 

Sync the production database with the DR.

 

2. Break the DR and activate it.

 

3. shut down the db and move that datafiles of DR to ASM storage(11.2.0.3)

 

4. start the db with upgrade option and upgrade it.

 

It will take near by 5 hrs.

 

 

2nd Method:

 

-Install 11g grid software and 10g as well as 11g db software on target db server.

-We will configure DR like first method but the here Grid home will be of 11g and db home will be of 10g.

- Now we will sync the DR with production database.

-will activate database on 10g (target server)

- will restart the database with 11g home and then we will upgrade it.

 

Here I want to know that is it possible to create a DR with the following setup?

Production db is of 10.2.0.4 and DR is configured with 11g grid and 10g db home.

 

 

Kindly give your inputs....

 

Regards,

Andy.....!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points