Database Administration (MOSC)

MOSC Banner

Archive log increase abnormal

edited Jul 14, 2015 5:04AM in Database Administration (MOSC) 22 commentsAnswered ✓

database version : 11.2.0.4

I enabled data guard in production DB on 6/22, but the archive logs abnormal increased 62GB and  54GB on 6/24 , 7/3.

In normal, this DB generate archive log files about 2GB ~5GB / per day.

Checked no ORA error in alert log on this period and used Logminer to parse archive logs,

the most records are null and operation is INTERNAL.

I suspect resource manager issue, because huge archive log start at 10 pm, in this moment just only resource manager starting.

but i was disabled resource manager on 6/26

alter system set resource_manager_plan='' scope=both;

anyone can help me to solve this problem? if need more information, please tell me.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center