oracle快照不自动创建导致没办法收集awr报告的原因和解决方法

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
InfORMation in this document applies to any platform.

SYMPTOMS

Due to other reasons, the MMON process died and subsequent AWR reports are therefore not getting generated.

The MMON process should automatically be respawned but it is not.

CAUSE

MMON/MMNL not being respawned or recreated is due to:

unpublished bug: Bug 19565533 - MMON/MMNL CAN NOT BE AUTOMATICALLY RESTARTED AFTER KILLED

The issue only occurs on 11.2.0.4 and is a regression of the fix for

• Apply interimAs a workaround, you can respawn the MMON process by next methods:

• Restart the database instance
  
  - OR -

• Set the instance to "restricted session" mode and then bring it back to normal mode using following commands as SYSDBA:
    

alter system enable restricted session;
alter system disable restricted session;