生成awr报告的过程中,发生awr报告没有快照,并返回ORA-20200错误。 查看dba_hist_active_session_history发现有数据,判断mmon和mmnl后台进程的问题,故需要重新启动mmon和mmnl后台进程 方法一: 重启数据库 方法二: 启用restricted模式,再立马禁用: alter system enable restricted session; alter system disable restricted...
In above output is easy identify what SNAP_ID to use without keep trying and getting ORA-20200 or by reading a huge list of snaps. The above query is NOT valid to get SNAP_ID to generate AWR Global RAC Report. Soon as possible I will post a Query to generate same output to easy ou...
Oracle Database Backup Service - Version N/A and later: Executing Statpack Report SQL Scripts Returns "ORA-20200: Database/Instance / does not exist in DBA_HIST_DATA
ERROR at line 1: ORA-20200: Database/Instance 1253224498/1 does not exist in STATS$DATABASE_INSTANCE ORA-06512: at line 23 Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real...
Oracle Database - Enterprise Edition - Version 12.2.0.1 and later: ORA-20200 Error When Generating AWR or ADDM Report as a PDB DBA User From a 12.2.0.1 and higher CD