High number of archive logs - log switching

[Former Member]

Hi All,

We have the following issue on our R/3 enviroment. We have upgraded our ECC 6.0 system SP14. Our DB is oracle 10.

The issue is oracle log switching is happening very frequently , mostly it is generating log file every minute constantly and sometimes more than 2. This is happening since the upgrade.

I looked at SAP side to see if there are any updates,inserts ,delete happening constantly and I dont see any of these.

Have any one faced this situation ?

Any help ?

Thanks!

[audunlea_hansen]

Hi!

Do the database alert<SID>.log tell You anything?

Look in v$session for sessions where status=active.

Regards

Audun

[Former Member]

after upgrading have to executed SGEN?

cheers,

-Sunil

[markus_doehr2]

Are you using ASSM tablespaces?

What exact version are you using?

Markus

[Former Member]

Yes we are using ASSM.

Exact oracle version is 10.2.0.2.0.

After upgrade, we also ran SGEN.

Thanks for helping on this !

[markus_doehr2]

Are maybe tablespaces in backup mode?

Markus

[Former Member]

what is database log file size configured?

[Former Member]

Log file is 256 MB and DB is not in backup mode.

[Former Member]

are there any background jobs running or anyone uploading data to the system?

Cheers,

-Sunil

[markus_doehr2]

> Log file is 256 MB and DB is not in backup mode

Did you check all the tablespaces?

You can check also

Note 896717 - Problems with tables in ASSM tablespaces

That is not your original problem but your problem may be caused by this.

Markus