huge amount of archivelog after upgrading to oracle 11

[Former Member]

Dear all,

we have upgradated our BI system from 7.20 on oracle 10 to BI 7.40 on oracle 11.

after performing this operation we are experiencing a great volume of archive log produced by the solution.

We have followed even the instruction of sap note 1431798 and 1627481 enhancing the size of online redolog to 400 MB each.

Any suggestion to overcome the problem?

regards

[stefan_koehler · Accepted solution]

Hi Bruno,

> Any suggestion to overcome the problem?

The amount of generated redo is usually triggered by the application behavior and not by the Oracle database itself (disregarding some uncommon used Oracle features in SAP environments or bugs in general).

However you can determine who or what is causing the new amount of redo with Log Miner (DBMS_LOGMNR) by analyzing the redo / archive log files. As you are talking about a SAP BI system i would guess that some logic has changed or that some operations are executed with the LOGGING option now (e.g. CREATE / REBUILD INDEX in BI chains).

Regards

Stefan

[former_member188883]

Hi Bruno,

Did you also perform unicode conversion ?

Regards,

Deepak Kori

[JamesZ]

Hi Bruno,

As Stefan mentioned, in most cases, the problem is caused by application. You can analyze the redo log according to SAP note 701562 and 1128990. You may find out the most active segments, then talking with your application colleagues to see if the performed large activity.

Best regards,
James