11.2.0.4数据库中,MMON进程,有时候由于一些莫名其妙的原因挂掉,接下来AWR的快照也就无法正常自动生成.MMON进程应该自动重启,却并没有自动被启动. 那么我们有可能是遇到了bug Bug - MMON/MMNL CAN NOT BE AUTOMATICALLY RESTARTED AFTER KILLED Bug : MMON AND MMNL GETTING RESTARTED DURING THE DATABASE SHUTDOWN 解决方法就有1)打补丁patch 195655
HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node (Doc ID 415579.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and laterOracle Databa
1.手动创建Snapshots exec dbms_workload_repository.create_snapshot(); OR BEGIN DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT (); END / 2.手动删除Snapshots ,high_snap_id ,dbid ); OR BEGIN dbms_workload_repository.drop_snapshot_range(low_snap_id , high_snap_id , dbi