cancel
Showing results for 
Search instead for 
Did you mean: 

Best Trategy to reduce the Database Size

0 Kudos

Hi Everyone,

In our Client's Landscape SAP systems have been upgraded to newer versions whereas our client want

one copy of older Production systems (one copy to retain)

1) SAP R/3 4.6 C system (database size of this system is approx 2TB)

2) SAP BW 3.0 (database size of this system is approx 2TB)

Now CLient wants us to reduce the database size via re-organization because Archiving of IDOCs & Links we have already done

Client has recommended for :

1) Oracle Export/Import: Only Oracle DBA can do (ignore this one)

2) Database Reorganization : We have tried Reoragnization via BRtools but found very tedious 9 (ignore this one)

3) SAP Export/Import : Via this way we want to reduce the database size

Can anybody Tell us How much Free space do we require in order at OS level in order to store the Database Export

of Two Databases of size around 4TB & what would be the best strategy of reducing the Dabase size.

Via SAP Export/Import how much approx how much database size will be reduced

Thanks & Regards

Deepak Gosain

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

>Can anybody Tell us How much Free space do we require in order at OS level in order to store the Database Export

>of Two Databases of size around 4TB & what would be the best strategy of reducing the Dabase size.

The only realistic way to know is to do a system copy of the production system on a testbed system and to test the Database Export.

If you really want to decrease the database size you will have to archive a lot more than the IDOC archiving object.

Regards,

Olivier

JPReyes
Active Contributor
0 Kudos

You can achieve that by doing a Homogenous System Copy which is basically a Export/Import scenario.

SAP Export/Import how much approx how much database size will be reduced

As far as I remember the dump created by Homogenous system copy was about 1/5 of the size of the DB but this is only my experience.

Regards

Juan