Upgrade Involving Huge Database

[Former Member]

Hi,

I'm looking for some view points/blogs etc. on SAP upgrades involving with huge size of database (about 15 TB).

The intention is to know about the effect of such huge sizes of database on upgrades.

Please provide relevant pointers.

Thanks,

Ashish

[Former Member · Accepted solution]

Hi Ashish,

You can find a lot of information and articles about upgrades at service.sap.com/upgrade.

Also you can consider Data Archiving before upgrade, which will make things easier.

Regards,

Naveen

[Former Member]

Hellow Ashish,

SAP recommends to delete all <u>unwanted user created clients</u> before you proceed with the upgrade.

Huge size of the Database would lead to larger space requirement for the shadow instance created during the upgrade.

Every upgrade should have a decent backup strategy, incase you have planned more backups then considerable time will be required for Database backup

I guess the runtime of the upgrade will be increased as well.

As mentioned by Naveen, do consider Data Archiving before upgrade

Regards,

Ammey Kesarkar

[Former Member]

Hi Naveen & Ammey

Data Archiving is an option. But will the archived data work with new upgraded system?

The critical point is to know the best strategy without increasing the downtime substantially.

Regards,

Ashish

[Former Member]

Hi Ashish,

One of the benefits of Data Archiving is Faster Upgrades! So definately it should reduce the burden of upgrading. Yes, you are right, less downtime. Less the data, less the downtime.

Data Archiving is based on ADK. And ADK ensures release independency. See this link:

http://help.sap.com/saphelp_47x200/helpdata/en/2a/fa0391493111d182b70000e829fbfe/frameset.htm

There is a possibility that you may need some SLO services if you plan to change things like client, system id etc. But if not, it should not be a problem to access the archived data from earlier system.

By the way, Backup time will be reduced as well as the database is smaller after archiving.

Hope this helps,

Naveen

Message was edited by:

Naveen Prabhakar

[Former Member]

before Upgrade

=============

It's highly recommended that you backup your DB

Collect baseline OS and DB statistics

Check your init.ora parameter file (or spfile)

After upgrade/migrate you should make sure that all your objects are valid

Become Familiar with the Features of the New

Develop a test plan

Vinod