Oracle 11g upgrade in SAP ECC 6.0

[Former Member]

Dear All,

Database size details :

SAP PRD : 5 TB

SAP QA : 2 TB

SAP DEV : 1 TB

How upgrade the database because it is large of size database in SAP.

Please help me.

Thanks,

Manas

[stefan_koehler · Accepted solution]

Hello Manas,

the upgrade duration itself has nothing to do with the database size. The database upgrade only touches the software (binaries, libraries, etc.) and the oracle dictionary / coding (apart from special date parts).

Just follow the upgrade guide mentioned by Ivy.

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan,

I already downloaded document for upgrade guide.

You can tell me how many times required.

If not doing the database size how it will compress the database.

Thanks,

Manas

[Former Member · Accepted solution]

Hi Manas,

As Stefan mentioned, Oracle Upgrade only upgrades the Database software, it has nothing to do with compressing it.

The time taken for the upgrade process (DBUA) to run depends mainly on the size of the database and the capacity of the hardware.

Renu

[former_member189725 · Accepted solution]

Just upgrading your database to Oracle 11g would not automatically compress the data if you are referring to OLTP compression. You need to enable OLTP compression after the upgrade.

Refer this SCN thread

http://scn.sap.com/thread/2040224

Also refer these documents for more info.

http://www.oracle.com/technetwork/database/performance/sapstorageoptimization-335322.pdf

http://www.oracle.com/technetwork/database/storage/advanced-compression-whitepaper-130502.pdf

As of now just upgrade the database to 11.2.0.3 as mentioned in the previous replies.

Regards

Ratnajit

[Former Member · Accepted solution]

Hi Renu,

Thanks for your reply.

As Stefan tell upgrade process not depends the size of the database.

Why you tell it depends mainly on the size of database.

Thanks,

Manas

[former_member189725 · Accepted solution]

The upgrade of the database version is independent of the database size. The time required to do a same version upgrade of a 1 TB and a 10 GB database would be almost same. Size does not impact the runtime .

Regards

Ratnajit

[Former Member · Accepted solution]

Hi Ratnajit,

Thanks for your reply.

How I upgrade mu standby database i.e. DR database.

Thanks,

Manas.

[Former Member · Accepted solution]

Thanks ratnajit.

Can you tell me how upgrade standby database.

Thanks,

Manas

[former_member189725 · Accepted solution]

You install the Oracle 11g software on the DR server and then backup the primary database and restore it on the DR server and then start the recovery of the standby database. You do not need to upgrade the database on the DR server as you do on the primary .

Regards

Ratnajit

[Former Member · Accepted solution]

Hi Ratnajit,

My Primary database size is 5 TB and it located in remote location.

Backup & restoration it take near 20 days time.

Any other procedure for it.

Thnaks,

Manas

[former_member189725 · Accepted solution]

I am not very confident of any other procedure . The DR has to be a standby of the primary and this basic concept is violated if the DR is upgraded separately as the standby once opened for any write is no more a standby .

Any suggestions , please post here.

Regards

Ratnajit

[stefan_koehler · Accepted solution]

Hi Manas,

i already answered this question on this thread: http://scn.sap.com/thread/2017608

However as it seems you are not very confident / experienced with such activities. I would highly recommend to do this not on your own, because of with Oracle DG it is getting even more complicated.

Best Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan,

Thanks for your reply.

Thanks,

Manas

[Former Member · Accepted solution]

Hi Stefan,

Can you help me how to plan the compression process in large DB ( 5 TB approx).

I have a document for compression.

Thanks,

Manas

[former_member197466]

Hi Manas,

You can upgrade the db to 11.2.0.3 follow Oracle upgrade guide which you can download at:

http://service.sap.com/instguides

Other Documentation

-> Database Upgrades

-> Oracle

Cheers,

Ivy