暂无图片
分享
2019-03-02
oracle12C


2节点RAC,请帮忙分析一下日志错误。谢谢

当前巡检会话    INST_ID:1,【976,13634,13216】
数据库服务器名称及IP地址    Public IP:rac1:10.150.1.98 ,Private IP:【1:enp4s0f0:1,169.254.39.215】
数据库服务器配置情况    【Inst_id 1: CPUs:56 Cores:28 Sockets:2 Memory:188.26G】,【Inst_id 2: CPUs:56 Cores:28 Sockets:2 Memory:188.26G】
操作系统信息    Linux x86 64-bit / 13
数据库名称    ORCL
数据库全局名    ORCL
当前实例名    ORCL1
所有实例名    ORCL1
数据库版本    12.2.0.1.0
数据库ID(DBID)    22463820
是否RAC集群及其节点数    TRUE : 2
是否CDB及其PDB个数    CDB,pdb有6个
数据库创建时间    2018-10-25 21:19:57
实例启动时间    【INST_ID 1:2018-10-26 18:31:17】

ORACLE_HOME    /u01/app/oracle/product/12.2.1/db_1
ORACLE_SID    ORCL1
TNS_ADMIN    /u01/app/oracle/product/12.2.1/db_1/network/admin
数据库归档模式    ARCHIVELOG
数据库闪回状态    NO
数据库字符集    ZHS16GBK
数据库块大小    8192
强制日志            NO
数据库角色    PRIMARY
是否有DG             NO
是否有OGG         NO
db time zone    26
回收站情况    状态:on,占用空间:M,共0个对象
特殊表空间情况(G)    SYSAUX:3/3,SYSTEM:1/1,TEMP:0/0,UNDOTBS1:7/9,UNDOTBS2:9/12
数据库大小    All TS Info:【ts_size:25.65G , Used_Size:19.14G , Used_per:74.63% , MAX_Size:192G】

收藏
分享
6条回答
默认
最新

2节点RAC

  ==================================================1===============================================
2019-02-22 23:03:23  Thread 1 advanced to log sequence 1653 (LGWR switch)
2019-02-22 23:03:23    Current log# 1 seq# 1653 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-22 23:03:23    Current log# 1 seq# 1653 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-22 23:03:23  Archived Log entry 3429 added for T-1.S-1652 ID 0x85e56dfd LAD:1
2019-02-22 23:04:00  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_2623.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13659" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-22 23:13:54  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_9292.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13661" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-22 23:23:56  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_15567.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13663" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-22 23:33:57  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_22199.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13665" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-22 23:43:58  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j004_28417.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13667" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-22 23:54:07  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_34805.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13669" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 00:04:04  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_40405.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13671" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 00:14:02  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_46362.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13673" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 00:24:04  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_51857.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13675" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 00:34:06  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_14689.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13677" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 00:44:06  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j004_20609.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13699" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 00:53:33  Thread 1 advanced to log sequence 1654 (LGWR switch)
2019-02-23 00:53:33    Current log# 2 seq# 1654 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-23 00:53:33    Current log# 2 seq# 1654 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-23 00:53:33  Archived Log entry 3433 added for T-1.S-1653 ID 0x85e56dfd LAD:1
2019-02-23 00:54:09  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_26465.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13701" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 01:04:15  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_32269.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13703" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 01:14:10  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_39248.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13705" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 01:24:12  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_45371.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13707" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 01:34:13  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_51251.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13709" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 01:55:26  Closing Resource Manager plan via scheduler window
2019-02-23 01:55:26  Clearing Resource Manager CDB plan via parameter
2019-02-23 05:55:26  Setting Resource Manager CDB plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-23 05:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-23 05:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-23 05:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-23 05:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-23 05:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-23 06:55:55  Thread 1 advanced to log sequence 1655 (LGWR switch)
2019-02-23 06:55:55    Current log# 1 seq# 1655 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-23 06:55:55    Current log# 1 seq# 1655 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-23 06:55:55  Archived Log entry 3436 added for T-1.S-1654 ID 0x85e56dfd LAD:1
2019-02-23 07:25:09  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_3784.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13711" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 07:55:20  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_22900.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13713" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 08:09:38  Thread 1 advanced to log sequence 1656 (LGWR switch)
2019-02-23 08:09:38    Current log# 2 seq# 1656 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-23 08:09:38    Current log# 2 seq# 1656 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-23 08:09:38  Archived Log entry 3440 added for T-1.S-1655 ID 0x85e56dfd LAD:1
2019-02-23 08:25:13  *****************************************************************
2019-02-23 08:25:13  An internal routine has requested a dump of selected redo.
2019-02-23 08:25:13  This usually happens following a specific internal error, when
2019-02-23 08:25:13  analysis of the redo logs will help Oracle Support with the
2019-02-23 08:25:13  diagnosis.
2019-02-23 08:25:13  It is recommended that you retain all the redo logs generated (by
2019-02-23 08:25:13  all the instances) during the past 12 hours, in case additional
2019-02-23 08:25:13  redo dumps are required to help with the diagnosis.
2019-02-23 08:25:13  *****************************************************************
2019-02-23 08:25:24  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_42522.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13715" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 08:55:27  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_3921.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13717" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 09:15:24  Thread 1 advanced to log sequence 1657 (LGWR switch)
2019-02-23 09:15:24    Current log# 1 seq# 1657 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-23 09:15:24    Current log# 1 seq# 1657 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-23 09:15:24  Archived Log entry 3443 added for T-1.S-1656 ID 0x85e56dfd LAD:1
2019-02-23 09:25:30  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_23562.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13739" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 09:55:26  Closing Resource Manager plan via scheduler window
2019-02-23 09:55:26  Clearing Resource Manager plan via parameter
2019-02-23 09:55:26  Closing Resource Manager plan via scheduler window
2019-02-23 09:55:26  Clearing Resource Manager plan via parameter
2019-02-23 09:55:26  Closing Resource Manager plan via scheduler window
2019-02-23 09:55:26  Clearing Resource Manager plan via parameter
2019-02-23 09:55:26  Closing Resource Manager plan via scheduler window
2019-02-23 09:55:26  Clearing Resource Manager plan via parameter
2019-02-23 09:55:26  Closing Resource Manager plan via scheduler window
2019-02-23 09:55:26  Clearing Resource Manager plan via parameter
2019-02-23 10:05:30  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_48725.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13741" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 10:15:30  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_55124.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13743" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 10:25:25  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_4392.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13745" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 10:35:26  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_10828.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13747" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 10:45:28  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_16991.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13749" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 10:55:36  Errors in file /u01/app/oracle/diag/rdbms/ORCL/JSZXOR
CL1/trace/ORCL1_j000_23317.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13751" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 11:05:30  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_30018.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13753" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 11:15:32  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_36501.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13755" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 11:25:33  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_42886.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13757" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 11:35:35  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_49065.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13779" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 11:45:42  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_54882.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13781" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 11:55:38  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_4178.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13783" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 12:05:38  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_10304.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13785" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 12:15:17  Thread 1 advanced to log sequence 1658 (LGWR switch)
2019-02-23 12:15:17    Current log# 2 seq# 1658 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-23 12:15:17    Current log# 2 seq# 1658 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-23 12:15:17  Archived Log entry 3447 added for T-1.S-1657 ID 0x85e56dfd LAD:1
2019-02-23 12:15:40  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_17435.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13787" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 12:25:42  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_23818.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13789" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 12:35:42  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_44693.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13791" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 12:45:44  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_50942.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13793" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 12:55:46  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_57035.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13795" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 13:05:48  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_5593.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13797" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 13:15:48  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_11907.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13819" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 13:25:49  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_17686.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13821" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 13:35:50  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_22992.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13823" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 13:45:58  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_28908.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13825" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 13:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-23 13:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-23 13:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-23 13:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-23 13:55:27  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-23 14:06:04  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_40654.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13827" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 14:26:03  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_53524.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13830" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 14:36:05  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_2522.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13832" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 14:56:05  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_15248.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13835" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 14:56:17  Thread 1 advanced to log sequence 1659 (LGWR switch)
2019-02-23 14:56:17    Current log# 1 seq# 1659 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-23 14:56:17    Current log# 1 seq# 1659 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-23 14:56:17  Archived Log entry 3449 added for T-1.S-1658 ID 0x85e56dfd LAD:1
2019-02-23 15:06:07  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_21671.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13837" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 15:26:11  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_35200.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13859" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 15:26:17  *****************************************************************
2019-02-23 15:26:17  An internal routine has requested a dump of selected redo.
2019-02-23 15:26:17  This usually happens following a specific internal error, when
2019-02-23 15:26:17  analysis of the redo logs will help Oracle Support with the
2019-02-23 15:26:17  diagnosis.
2019-02-23 15:26:17  It is recommended that you retain all the redo logs generated (by
2019-02-23 15:26:17  all the instances) during the past 12 hours, in case additional
2019-02-23 15:26:17  redo dumps are required to help with the diagnosis.
2019-02-23 15:26:17  *****************************************************************
2019-02-23 15:56:12  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_53269.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13861" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 16:26:31  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_15814.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13863" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 16:41:20  Thread 1 advanced to log sequence 1660 (LGWR switch)
2019-02-23 16:41:20    Current log# 2 seq# 1660 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-23 16:41:20    Current log# 2 seq# 1660 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-23 16:41:20  Archived Log entry 3452 added for T-1.S-1659 ID 0x85e56dfd LAD:1
2019-02-23 16:56:32  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_35034.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13865" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 17:26:34  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_54074.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13867" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 17:46:34  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_9841.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13869" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 18:06:34  Thread 1 advanced to log sequence 1661 (LGWR switch)
2019-02-23 18:06:34    Current log# 1 seq# 1661 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-23 18:06:34    Current log# 1 seq# 1661 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-23 18:06:34  Archived Log entry 3454 added for T-1.S-1660 ID 0x85e56dfd LAD:1
2019-02-23 18:06:44  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_22538.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13871" 出错
ORA-20001: Statistics Advisor: Invalid task name for the curren
t user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 18:36:50  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_56349.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13873" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 19:51:51  Thread 1 advanced to log sequence 1662 (LGWR switch)
2019-02-23 19:51:51    Current log# 2 seq# 1662 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-23 19:51:51    Current log# 2 seq# 1662 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-23 19:51:51  Archived Log entry 3456 added for T-1.S-1661 ID 0x85e56dfd LAD:1
2019-02-23 20:07:01  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_55762.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13877" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 20:47:07  *****************************************************************
2019-02-23 20:47:07  An internal routine has requested a dump of selected redo.
2019-02-23 20:47:07  This usually happens following a specific internal error, when
2019-02-23 20:47:07  analysis of the redo logs will help Oracle Support with the
2019-02-23 20:47:07  diagnosis.
2019-02-23 20:47:07  It is recommended that you retain all the redo logs generated (by
2019-02-23 20:47:07  all the instances) during the past 12 hours, in case additional
2019-02-23 20:47:07  redo dumps are required to help with the diagnosis.
2019-02-23 20:47:07  *****************************************************************
2019-02-23 21:57:12  Thread 1 advanced to log sequence 1663 (LGWR switch)
2019-02-23 21:57:12    Current log# 1 seq# 1663 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-23 21:57:12    Current log# 1 seq# 1663 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-23 21:57:12  Archived Log entry 3458 added for T-1.S-1662 ID 0x85e56dfd LAD:1
2019-02-23 21:57:19  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_7927.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13900" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 22:37:29  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_34195.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13902" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 23:07:31  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j002_52877.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13904" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-23 23:12:22  Thread 1 advanced to log sequence 1664 (LGWR switch)
2019-02-23 23:12:22    Current log# 2 seq# 1664 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-23 23:12:22    Current log# 2 seq# 1664 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-23 23:12:22  Archived Log entry 3460 added for T-1.S-1663 ID 0x85e56dfd LAD:1
2019-02-24 00:07:22  *****************************************************************
2019-02-24 00:07:22  An internal routine has requested a dump of selected redo.
2019-02-24 00:07:22  This usually happens following a specific internal error, when
2019-02-24 00:07:22  analysis of the redo logs will help Oracle Support with the
2019-02-24 00:07:22  diagnosis.
2019-02-24 00:07:22  It is recommended that you retain all the redo logs generated (by
2019-02-24 00:07:22  all the instances) during the past 12 hours, in case additional
2019-02-24 00:07:22  redo dumps are required to help with the diagnosis.
2019-02-24 00:07:22  *****************************************************************
2019-02-24 00:07:22  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P1992 (43519) VALUES LESS THAN (TO_DATE(' 2019-02-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-24 00:07:22  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P1995 (43519) VALUES LESS THAN (TO_DATE(' 2019-02-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-24 00:27:28  *****************************************************************
2019-02-24 00:27:28  An internal routine has requested a dump of selected redo.
2019-02-24 00:27:28  This usually happens following a specific internal error, when
2019-02-24 00:27:28  analysis of the redo logs will help Oracle Support with the
2019-02-24 00:27:28  diagnosis.
2019-02-24 00:27:28  It is recommended that you retain all the redo logs generated (by
2019-02-24 00:27:28  all the instances) during the past 12 hours, in case additional
2019-02-24 00:27:28  redo dumps are required to help with the diagnosis.
2019-02-24 00:27:28  *****************************************************************
2019-02-24 00:27:34  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P1992 (43519) VALUES LESS THAN (TO_DATE(' 2019-02-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-24 00:27:34  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P1995 (43519) VALUES LESS THAN (TO_DATE(' 2019-02-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-24 00:27:35  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_47031.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13907" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 00:37:33  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P1880 (43519) VALUES LESS THAN (TO_DATE(' 2019-02-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-24 00:37:33  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P1883 (43519) VALUES LESS THAN (TO_DATE(' 2019-02-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-24 00:47:37  Thread 1 advanced to log sequence 1665 (LGWR switch)
2019-02-24 00:47:37    Current log# 1 seq# 1665 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-24 00:47:37    Current log# 1 seq# 1665 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-24 00:47:37  Archived Log entry 3463 added for T-1.S-1664 ID 0x85e56dfd LAD:1
2019-02-24 00:47:39  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_17245.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13909" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 01:27:52  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_43166.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13911" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 01:37:43  Thread 1 advanced to log sequence 1666 (LGWR switch)
2019-02-24 01:37:43    Current log# 2 seq# 1666 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-24 01:37:43    Current log# 2 seq# 1666 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-24 01:37:43  Archived Log entry 3464 added for T-1.S-1665 ID 0x85e56dfd LAD:1
2019-02-24 01:55:26  Closing Resource Manager plan via scheduler window
2019-02-24 01:55:26  Clearing Resource Manager CDB plan via parameter
2019-02-24 03:38:01  Thread 1 advanced to log sequence 1667 (LGWR switch)
2019-02-24 03:38:01    Current log# 1 seq# 1667 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-24 03:38:01    Current log# 1 seq# 1667 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-24 03:38:02  Archived Log entry 3466 added for T-1.S-1666 ID 0x85e56dfd LAD:1
2019-02-24 05:08:10  *****************************************************************
2019-02-24 05:08:10  An internal routine has requested a dump of selected redo.
2019-02-24 05:08:10  This usually happens following a specific internal error, when
2019-02-24 05:08:10  analysis of the redo logs will help Oracle Support with the
2019-02-24 05:08:10  diagnosis.
2019-02-24 05:08:10  It is recommended that you retain all the redo logs generated (by
2019-02-24 05:08:10  all the instances) during the past 12 hours, in case additional
2019-02-24 05:08:10  redo dumps are required to help with the diagnosis.
2019-02-24 05:08:10  *****************************************************************
2019-02-24 05:18:09  Thread 1 advanced to log sequence 1668 (LGWR switch)
2019-02-24 05:18:09    Current log# 2 seq# 1668 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-24 05:18:09    Current log# 2 seq# 1668 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-24 05:18:09  Archived Log entry 3467 added for T-1.S-1667 ID 0x85e56dfd LAD:1
2019-02-24 05:55:25  Setting Resource Manager CDB plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-24 06:28:29  Thread 1 advanced to log sequence 1669 (LGWR switch)
2019-02-24 06:28:29    Current log# 1 seq# 1669 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-24 06:28:29    Current log# 1 seq# 1669 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-24 06:28:29  Archived Log entry 3470 added for T-1.S-1668 ID 0x85e56dfd LAD:1
2019-02-24 07:28:39  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_2677.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13939" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 07:38:39  Thread 1 advanced to log sequence 1670 (LGWR switch)
2019-02-24 07:38:39    Current log# 2 seq# 1670 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-24 07:38:39    Current log# 2 seq# 1670 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-24 07:38:39  Archived Log entry 3472 added for T-1.S-1669 ID 0x85e56dfd LAD:1
2019-02-24 07:48:40  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_15020.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13941" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 08:28:48  Thread 1 advanced to log sequence 1671 (LGWR switch)
2019-02-24 08:28:48    Current log# 1 seq# 1671 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-24 08:28:48    Current log# 1 seq# 1671 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-24 08:28:49  Archived Log entry 3475 added for T-1.S-1670 ID 0x85e56dfd LAD:1
2019-02-24 08:29:25  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_41345.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13943" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 08:48:52  Thread 1 advanced to log sequence 1672 (LGWR switch)
2019-02-24 08:48:52    Current log# 2 seq# 1672 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-24 08:48:52    Current log# 2 seq# 1672 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-24 08:48:53  Archived Log entry 3476 added for T-1.S-1671 ID 0x85e56dfd LAD:1
2019-02-24 08:48:54  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_53463.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13945" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 09:28:56  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_23765.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13947" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 09:38:49  *****************************************************************
2019-02-24 09:38:49  An internal routine has requested a dump of selected redo.
2019-02-24 09:38:49  This usually happens following a specific internal error, when
2019-02-24 09:38:49  analysis of the redo logs will help Oracle Support with the
2019-02-24 09:38:49  diagnosis.
2019-02-24 09:38:49  It is recommended that you retain all the redo logs generated (by
2019-02-24 09:38:49  all the instances) during the past 12 hours, in case additional
2019-02-24 09:38:49  redo dumps are required to help with the diagnosis.
2019-02-24 09:38:49  *****************************************************************
2019-02-24 09:48:49  Thread 1 advanced to log sequence 1673 (LGWR switch)
2019-02-24 09:48:49    Current log# 1 seq# 1673 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-24 09:48:49    Current log# 1 seq# 1673 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-24 09:48:49  Archived Log entry 3478 added for T-1.S-1672 ID 0x85e56dfd LAD:1
2019-02-24 09:48:51  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_36374.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13949" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 09:55:25  Closing Resource Manager plan via scheduler window
2019-02-24 09:55:25  Clearing Resource Manager plan via parameter
2019-02-24 09:55:25  Closing Resource Manager plan via scheduler window
2019-02-24 09
:55:25  Clearing Resource Manager plan via parameter
2019-02-24 09:55:25  Closing Resource Manager plan via scheduler window
2019-02-24 09:55:25  Clearing Resource Manager plan via parameter
2019-02-24 09:55:25  Closing Resource Manager plan via scheduler window
2019-02-24 09:55:25  Clearing Resource Manager plan via parameter
2019-02-24 09:55:25  Closing Resource Manager plan via scheduler window
2019-02-24 09:55:25  Clearing Resource Manager plan via parameter
2019-02-24 09:58:54  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_42664.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13951" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 10:08:47  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_48883.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13953" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 10:18:49  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_55317.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13955" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 10:28:50  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_4514.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13957" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 10:38:51  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_10946.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_13999" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 10:48:53  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_17187.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14001" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 10:59:00  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_23535.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14003" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 11:08:56  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_30178.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14005" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 11:18:58  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_36722.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14007" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 11:29:00  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_43018.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14009" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 11:39:01  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_48851.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14011" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 11:49:03  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_55070.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14013" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 11:55:50  Thread 1 advanced to log sequence 1674 (LGWR switch)
2019-02-24 11:55:50    Current log# 2 seq# 1674 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-24 11:55:50    Current log# 2 seq# 1674 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-24 11:55:51  Archived Log entry 3481 added for T-1.S-1673 ID 0x85e56dfd LAD:1
2019-02-24 11:59:09  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_4371.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14015" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 12:09:05  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_10539.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14017" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 12:19:08  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_17721.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14039" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 12:29:13  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_24107.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14041" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 12:39:10  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_44908.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14043" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 12:49:12  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_51223.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14045" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 12:59:18  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_57317.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14047" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 13:09:15  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_6392.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14049" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 13:19:18  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_13506.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14051" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 13:19:18  Thread 1 advanced to log sequence 1675 (LGWR switch)
2019-02-24 13:19:18    Current log# 1 seq# 1675 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-24 13:19:18    Current log# 1 seq# 1675 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-24 13:19:18  Archived Log entry 3482 added for T-1.S-1674 ID 0x85e56dfd LAD:1
2019-02-24 13:29:18  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_20093.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14053" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 13:39:20  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_26237.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14055" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 13:49:41  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_32701.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14057" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 13:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-24 13:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-24 13:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-24 13:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-24 13:55:26  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-24 13:59:26  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_39032.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14079" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 14:39:33  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_6865.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14081" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 15:09:38  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_25265.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14083" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 15:39:41  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_42562.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14085" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 15:44:46  Thread 1 advanced to log sequence 1676 (LGWR switch)
2019-02-24 15:44:46    Current log# 2 seq# 1676 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-24 15:44:46    Current log# 2 seq# 1676 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-24 15:44:47  Archived Log entry 3485 added for T-1.S-1675 ID 0x85e56dfd LAD:1
2019-02-24 16:09:51  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_2993.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14087" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 16:39:51  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_22717.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14089" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 17:09:58  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_41816.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14091" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 4720
7
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 17:10:04  Thread 1 advanced to log sequence 1677 (LGWR switch)
2019-02-24 17:10:04    Current log# 1 seq# 1677 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-24 17:10:04    Current log# 1 seq# 1677 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-24 17:10:04  Archived Log entry 3488 added for T-1.S-1676 ID 0x85e56dfd LAD:1
2019-02-24 17:40:02  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_3670.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14093" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 18:10:00  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_22838.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14095" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 18:40:12  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_56623.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14097" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 18:40:20  Thread 1 advanced to log sequence 1678 (LGWR switch)
2019-02-24 18:40:20    Current log# 2 seq# 1678 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-24 18:40:20    Current log# 2 seq# 1678 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-24 18:40:20  Archived Log entry 3489 added for T-1.S-1677 ID 0x85e56dfd LAD:1
2019-02-24 19:10:10  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_18965.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14139" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 19:40:23  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_38520.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14141" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 19:56:14  Thread 1 advanced to log sequence 1679 (LGWR switch)
2019-02-24 19:56:14    Current log# 1 seq# 1679 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-24 19:56:14    Current log# 1 seq# 1679 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-24 19:56:15  Archived Log entry 3492 added for T-1.S-1678 ID 0x85e56dfd LAD:1
2019-02-24 20:10:17  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_531.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14143" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 20:40:26  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_19739.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14145" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 20:50:29  *****************************************************************
2019-02-24 20:50:29  An internal routine has requested a dump of selected redo.
2019-02-24 20:50:29  This usually happens following a specific internal error, when
2019-02-24 20:50:29  analysis of the redo logs will help Oracle Support with the
2019-02-24 20:50:29  diagnosis.
2019-02-24 20:50:29  It is recommended that you retain all the redo logs generated (by
2019-02-24 20:50:29  all the instances) during the past 12 hours, in case additional
2019-02-24 20:50:29  redo dumps are required to help with the diagnosis.
2019-02-24 20:50:29  *****************************************************************
2019-02-24 21:10:25  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_39371.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14147" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 21:40:43  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_612.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14149" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 21:50:35  Thread 1 advanced to log sequence 1680 (LGWR switch)
2019-02-24 21:50:35    Current log# 2 seq# 1680 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-24 21:50:35    Current log# 2 seq# 1680 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-24 21:50:35  Archived Log entry 3494 added for T-1.S-1679 ID 0x85e56dfd LAD:1
2019-02-24 21:50:37  *****************************************************************
2019-02-24 21:50:37  An internal routine has requested a dump of selected redo.
2019-02-24 21:50:37  This usually happens following a specific internal error, when
2019-02-24 21:50:37  analysis of the redo logs will help Oracle Support with the
2019-02-24 21:50:37  diagnosis.
2019-02-24 21:50:37  It is recommended that you retain all the redo logs generated (by
2019-02-24 21:50:37  all the instances) during the past 12 hours, in case additional
2019-02-24 21:50:37  redo dumps are required to help with the diagnosis.
2019-02-24 21:50:37  *****************************************************************
2019-02-24 22:10:39  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_19297.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14151" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 22:40:49  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_35866.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14153" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 23:10:49  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_53563.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14155" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-24 23:40:56  Thread 1 advanced to log sequence 1681 (LGWR switch)
2019-02-24 23:40:56    Current log# 1 seq# 1681 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-24 23:40:56    Current log# 1 seq# 1681 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-24 23:40:56  Archived Log entry 3497 added for T-1.S-1680 ID 0x85e56dfd LAD:1
2019-02-24 23:41:04  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_15248.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14157" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-25 00:00:52  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P1884 (43520) VALUES LESS THAN (TO_DATE(' 2019-02-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-25 00:00:52  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P1887 (43520) VALUES LESS THAN (TO_DATE(' 2019-02-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-25 00:00:56  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2012 (43520) VALUES LESS THAN (TO_DATE(' 2019-02-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-25 00:00:56  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2015 (43520) VALUES LESS THAN (TO_DATE(' 2019-02-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-25 00:10:59  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_35346.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14179" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-25 00:11:00  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P1996 (43520) VALUES LESS THAN (TO_DATE(' 2019-02-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-25 00:11:00  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P1999 (43520) VALUES LESS THAN (TO_DATE(' 2019-02-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-25 00:41:00  Thread 1 advanced to log sequence 1682 (LGWR switch)
2019-02-25 00:41:00    Current log# 2 seq# 1682 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-25 00:41:00    Current log# 2 seq# 1682 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-25 00:41:01  Archived Log entry 3499 added for T-1.S-1681 ID 0x85e56dfd LAD:1
2019-02-25 00:41:10  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_11577.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14181" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-25 01:11:09  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_31429.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14183" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-25 01:41:18  Thread 1 advanced to log sequence 1683 (LGWR switch)
2019-02-25 01:41:18    Current log# 1 seq# 1683 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-25 01:41:18    Current log# 1 seq# 1683 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-25 01:41:19  Archived Log entry 3501 added for T-1.S-1682 ID 0x85e56dfd LAD:1
2019-02-25 01:41:21  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_49995.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14185" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-25 01:55:26  Closing Resource Manager plan via scheduler window
2019-02-25 01:55:26  Clearing Resource Manager CDB plan via parameter
2019-02-25 03:01:28  Thread 1 advanced to log sequence 1684 (LGWR switch)
2019-02-25 03:01:28    Current log# 2 seq# 1684 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-25 03:01:28    Current log# 2 seq# 1684 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-25 03:01:29  Archived Log entry 3503 added for T-1.S-1683 ID 0x85e56dfd LAD:1
2019-02-25 04:01:31  *****************************************************************
2019-02-25 04:01:31  An internal routine has requested a dump of selected redo.
2019-02-25 04:01:31  This usually happens following a specific internal error, when
2019-02-25 04:01:31  analysis of the redo logs will help Oracle Support with the
2019-02-25 04:01:31  diagnosis.
2019-02-25 04:01:31  It is recommended that you retain all the redo logs generated (by
2019-02-25 04:01:31  all the instances) during the past 12 hours, in case additional
2019-02-25 04:01:31  redo dumps are required to help with the diagnosis.
2019-02-25 04:01:31  *****************************************************************
2019-02-25 05:01:40  *****************************************************************
2019-02-25 05:01:40  An internal routine has requested a dump of selected redo.
2019-02-25 05:01:40  This usually happens following a specific internal error, when
2019-02-25 05:01:40  analysis of the redo logs will help Oracle Support with the
2019-02-25 05:01:40  diagnosis.
2019-02-25 05:01:40  It is recommended that you retain all the redo logs generated (by
2019-02-25 05:01:40  all the instances) during the past 12 hours, in case additional
2019-02-25 05:01:40  redo dumps are required to help with the diagnosis.
2019-02-25 05:01:40  *****************************************************************
2019-02-25 05:21:42  Thread 1 advanced to log sequence 1685 (LGWR switch)
2019-02-25 05:21:42    Current log# 1 seq# 1685 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-25 05:21:42    Current log# 1 seq# 1685 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-25 05:21:42  Archived Log entry 3505 added for T-1.S-1684 ID 0x85e56dfd LAD:1
2019-02-25 07:01:58  Thread 1 advanced to log sequence 1686 (LGWR switch)
2019-02-25 07:01:58    Current log# 2 seq# 1686 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-25 07:01:58    Current log# 2 seq# 1686 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-25 07:01:59  Archived Log entry 3507 added for T-1.S-1685 ID 0x85e56dfd LAD:1
2019-02-25 08:37:52  Thread 1 advanced to log sequence 1687 (LGWR switch)
2019-02-25 08:37:52    Current log# 1 seq# 1687 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-25 08:37:52    Current log# 1 seq# 1687 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-25 08:37:53  Archived Log entry 3510 added for T-1.S-1686 ID 0x85e56dfd LAD:1
2019-02-25 09:55:2
6  Closing Resource Manager plan via scheduler window
2019-02-25 09:55:26  Clearing Resource Manager plan via parameter
2019-02-25 09:55:26  Closing Resource Manager plan via scheduler window
2019-02-25 09:55:26  Clearing Resource Manager plan via parameter
2019-02-25 09:55:26  Closing Resource Manager plan via scheduler window
2019-02-25 09:55:26  Clearing Resource Manager plan via parameter
2019-02-25 09:55:26  Closing Resource Manager plan via scheduler window
2019-02-25 09:55:26  Clearing Resource Manager plan via parameter
2019-02-25 09:55:26  Closing Resource Manager plan via scheduler window
2019-02-25 09:55:26  Clearing Resource Manager plan via parameter
2019-02-25 10:29:23  Thread 1 advanced to log sequence 1688 (LGWR switch)
2019-02-25 10:29:23    Current log# 2 seq# 1688 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-25 10:29:23    Current log# 2 seq# 1688 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-25 10:29:24  Archived Log entry 3512 added for T-1.S-1687 ID 0x85e56dfd LAD:1
2019-02-25 15:48:14  Thread 1 advanced to log sequence 1689 (LGWR switch)
2019-02-25 15:48:14    Current log# 1 seq# 1689 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-25 15:48:14    Current log# 1 seq# 1689 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-25 15:48:14  Archived Log entry 3514 added for T-1.S-1688 ID 0x85e56dfd LAD:1
2019-02-25 17:05:32  Reconfiguration started (old inc 24, new inc 26)
2019-02-25 17:05:32  List of instances (total 1) :
2019-02-25 17:05:32   1
2019-02-25 17:05:32  Dead instances (total 1) :
2019-02-25 17:05:32   2
2019-02-25 17:05:32  My inst 1   
2019-02-25 17:05:32  publish big name space -  dead or down/up instance detected, invalidate domain 0
2019-02-25 17:05:32   Global Resource Directory frozen
2019-02-25 17:05:32  * dead instance detected - domain 0 invalid = TRUE
2019-02-25 17:05:32  * dead instance detected - domain 2 invalid = TRUE, need cdb-level instance recovery
2019-02-25 17:05:32  * dead instance detected - domain 3 invalid = TRUE, need cdb-level instance recovery
2019-02-25 17:05:32  * dead instance detected - domain 4 invalid = TRUE, need cdb-level instance recovery
2019-02-25 17:05:32  * dead instance detected - domain 5 invalid = TRUE, need cdb-level instance recovery
2019-02-25 17:05:32  * dead instance detected - domain 6 invalid = TRUE, need cdb-level instance recovery
2019-02-25 17:05:32  * dead instance detected - domain 7 invalid = TRUE, need cdb-level instance recovery
2019-02-25 17:05:32   Communication channels reestablished
2019-02-25 17:05:32  IPC Send timeout to 2.1 inc 24 for msg type 44 from opid 24
2019-02-25 17:05:32  IPC Send timeout to 2.1 inc 24 for msg type 73 from opid 24
2019-02-25 17:05:32   Master broadcasted resource hash value bitmaps
2019-02-25 17:05:33   Non-local Process blocks cleaned out
2019-02-25 17:05:33   LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived, skipped 0
2019-02-25 17:05:33   LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived, skipped 0
2019-02-25 17:05:33   LMS 2: 1 GCS shadows cancelled, 0 closed, 0 Xw survived, skipped 0
2019-02-25 17:05:33   Set master node info
2019-02-25 17:05:33   Submitted all remote-enqueue requests
2019-02-25 17:05:33   Dwn-cvts replayed, VALBLKs dubious
2019-02-25 17:05:33   All grantable enqueues granted
2019-02-25 17:05:33   Post SMON to start 1st pass IR
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x10 (domain enable 5)
2019-02-25 17:05:33  Instance recovery: looking for dead threads
2019-02-25 17:05:33  attach called for domid 2 (domuid: 0x408a4062, options: 0x1, pid: 24708)
2019-02-25 17:05:33  start recovery: pdb 2, passed in flags x10 (domain enable 5)
2019-02-25 17:05:33  attach called for domid 3 (domuid: 0x8915dd77, options: 0x1, pid: 24708)
2019-02-25 17:05:33  start recovery: pdb 3, passed in flags x10 (domain enable 5)
2019-02-25 17:05:33  attach called for domid 4 (domuid: 0xb1f8fac5, options: 0x1, pid: 24708)
2019-02-25 17:05:33  start recovery: pdb 4, passed in flags x10 (domain enable 5)
2019-02-25 17:05:33  attach called for domid 5 (domuid: 0x9ac4e006, options: 0x1, pid: 24708)
2019-02-25 17:05:33  start recovery: pdb 5, passed in flags x10 (domain enable 5)
2019-02-25 17:05:33  attach called for domid 6 (domuid: 0x8d12f429, options: 0x1, pid: 24708)
2019-02-25 17:05:33  start recovery: pdb 6, passed in flags x10 (domain enable 5)
2019-02-25 17:05:33  attach called for domid 7 (domuid: 0x6934fd4a, options: 0x1, pid: 24708)
2019-02-25 17:05:33  start recovery: pdb 7, passed in flags x10 (domain enable 5)
2019-02-25 17:05:33  Beginning instance recovery of 1 threads
2019-02-25 17:05:33   parallel recovery started with 32 processes
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  start recovery: pdb 0, passed in flags x11 (domain enable 5)
2019-02-25 17:05:33  Started redo scan
2019-02-25 17:05:33   Submitted all GCS remote-cache requests
2019-02-25 17:05:33   Fix write in gcs resources
2019-02-25 17:05:33  Completed redo scan
2019-02-25 17:05:33   read 1077 KB redo, 205 data blocks need recovery
2019-02-25 17:05:33  Reconfiguration complete (total time 0.9 secs)
2019-02-25 17:05:33  validate pdb 0, flags x10, valid 0, pdb flags x84
2019-02-25 17:05:33  * validated domain 0, flags = 0x80
2019-02-25 17:05:33  * validated domain 2, flags = 0x80
2019-02-25 17:05:33  * validated domain 3, flags = 0x80
2019-02-25 17:05:33  * validated domain 4, flags = 0x80
2019-02-25 17:05:33  * validated domain 5, flags = 0x80
2019-02-25 17:05:33  * validated domain 6, flags = 0x80
2019-02-25 17:05:33  * validated domain 7, flags = 0x80
2019-02-25 17:05:33  Started redo application at
2019-02-25 17:05:33   Thread 2: logseq 1830, block 81191, offset 0
2019-02-25 17:05:33  Recovery of Online Redo Log: Thread 2 Group 4 Seq 1830 Reading mem 0
2019-02-25 17:05:33    Mem# 0: +DATA/ORCL/ONLINELOG/group_4.271.990480273
2019-02-25 17:05:33    Mem# 1: +FIR/ORCL/ONLINELOG/group_4.260.990480275
2019-02-25 17:05:33  Completed redo application of 0.56MB
2019-02-25 17:05:33  Completed instance recovery at
2019-02-25 17:05:33  minact-scn: master detected reconf/inst-rec stop us-scan old-inc#:24 new-inc#:26
2019-02-25 17:05:33   Thread 2: RBA 1830.83345.16, nab 83345, scn 0x0000000005fcddf4
2019-02-25 17:05:33  minact-scn: master detected reconf/inst-rec stop us-scan old-inc#:26 new-inc#:26
2019-02-25 17:05:33  minact-scn: master detected reconf/inst-rec stop us-scan old-inc#:26 new-inc#:26
2019-02-25 17:05:33  minact-scn: master detected reconf/inst-rec stop us-scan old-inc#:26 new-inc#:26
2019-02-25 17:05:33  minact-scn: master detected reconf/inst-rec stop us-scan old-inc#:26 new-inc#:26
2019-02-25 17:05:33  minact-scn: master detected reconf/inst-rec stop us-scan old-inc#:26 new-inc#:26
2019-02-25 17:05:33   150 data blocks read, 219 data blocks written, 1077 redo k-bytes read
2019-02-25 17:05:34  Thread 2 advanced to log sequence 1831 (thread recovery)
2019-02-25 17:05:34  Redo thread 2 internally disabled at seq 1831 (SMON)
2019-02-25 17:05:34  Archived Log entry 3515 added for T-2.S-1830 ID 0x85e56dfd LAD:1
2019-02-25 17:05:34  CDB instance recovery complete: pdb 2 valid 1 (flags x10, pdb flags x80)
2019-02-25 17:05:34  CDB instance recovery complete: pdb 3 valid 1 (flags x10, pdb flags x80)
2019-02-25 17:05:34  CDB instance recovery complete: pdb 4 valid 1 (flags x10, pdb flags x80)
2019-02-25 17:05:34  CDB instance recovery complete: pdb 5 valid 1 (flags x10, pdb flags x80)
2019-02-25 17:05:34  CDB instance recovery complete: pdb 6 valid 1 (flags x10, pdb flags x80)
2019-02-25 17:05:34  CDB instance recovery complete: pdb 7 valid 1 (flags x10, pdb flags x80)
2019-02-25 17:05:34  CDB instance recovery complete: pdb 0 valid 1 (flags x10, pdb flags x80)
2019-02-25 17:05:35  ARC3: Archiving disabled T-2.S-1831
2019-02-25 17:05:35  Archived Log entry 3516 added for T-2.S-1831 ID 0x85e56dfd LAD:1
2019-02-25 17:06:25  minact-scn: master continuing after IR
2019-02-25 17:06:25  minact-scn: master continuing after IR
2019-02-25 17:06:25  minact-scn: master continuing after IR
2019-02-25 17:06:25  minact-scn: master continuing after IR
2019-02-25 17:06:25  minact-scn: master continuing after IR
2019-02-25 17:06:34  Decreasing number of high priority LMS from 3 to 0
2019-02-25 21:25:54  Thread 1 advanced to log sequence 1690 (LGWR switch)
2019-02-25 21:25:54    Current log# 2 seq# 1690 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-25 21:25:54    Current log# 2 seq# 1690 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-25 21:25:54  Archived Log entry 3517 added for T-1.S-1689 ID 0x85e56dfd LAD:1
2019-02-25 22:00:00  Setting Resource Manager plan SCHEDULER[0x4AC3]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-25 22:00:00  Setting Resource Manager CDB plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-25 22:00:03  Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
2019-02-25 22:00:15  End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
2019-02-25 22:01:06  Thread 1 advanced to log sequence 1691 (LGWR switch)
2019-02-25 22:01:06    Current log# 1 seq# 1691 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-25 22:01:06    Current log# 1 seq# 1691 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-25 22:01:07  Archived Log entry 3518 added for T-1.S-1690 ID 0x85e56dfd LAD:1
2019-02-25 22:01:20  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_25456.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14219" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-25 23:04:17  Thread 1 advanced to log sequence 1692 (LGWR switch)
2019-02-25 23:04:17    Current log# 2 seq# 1692 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-25 23:04:17    Current log# 2 seq# 1692 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-25 23:04:17  Archived Log entry 3519 added for T-1.S-1691 ID 0x85e56dfd LAD:1
2019-02-25 23:04:20  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_39220.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14222" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-25 23:14:20  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_50143.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14224" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-25 23:24:15  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_4059.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14226" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-25 23:34:17  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_15207.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14228" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-25 23:44:18  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_26403.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_14230"
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: at "SYS.DBMS_STATS", line 47207
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: at "SYS.DBMS_STATS", line 47197
2019-02-25 23:54:19  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_37390.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14232" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 00:04:18  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2757 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 00:04:18  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2760 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 00:04:22  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_47864.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14234" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_
STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 00:14:21  Thread 1 advanced to log sequence 1693 (LGWR switch)
2019-02-26 00:14:21    Current log# 1 seq# 1693 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-26 00:14:21    Current log# 1 seq# 1693 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-26 00:14:21  Archived Log entry 3520 added for T-1.S-1692 ID 0x85e56dfd LAD:1
2019-02-26 00:14:23  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_2537.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14236" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 00:24:25  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_12715.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14238" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 00:34:30  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_37103.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14240" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 00:44:31  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_47468.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_14242"
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: at "SYS.DBMS_STATS", line 47207
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: at "SYS.DBMS_STATS", line 47197
2019-02-26 00:46:41  TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P2761 (3343) VALUES LESS THAN (TO_DATE(' 2019-02-26 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 00:54:29  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_848.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14244" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 01:00:41  Thread 1 advanced to log sequence 1694 (LGWR switch)
2019-02-26 01:00:41    Current log# 2 seq# 1694 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-26 01:00:41    Current log# 2 seq# 1694 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-26 01:00:41  Archived Log entry 3521 added for T-1.S-1693 ID 0x85e56dfd LAD:1
2019-02-26 01:04:34  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_11383.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14246" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 01:14:33  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_22783.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14248" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 01:24:34  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_32917.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14250" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 01:34:35  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_43110.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14252" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 01:44:39  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_52593.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_14254"
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: at "SYS.DBMS_STATS", line 47207
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: at "SYS.DBMS_STATS", line 47197
2019-02-26 01:46:51  TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P2762 (3344) VALUES LESS THAN (TO_DATE(' 2019-02-27 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 01:46:51  TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P2763 (3344) VALUES LESS THAN (TO_DATE(' 2019-02-27 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 02:00:00  Closing scheduler window
2019-02-26 02:00:00  Closing Resource Manager plan via scheduler window
2019-02-26 02:00:00  Clearing Resource Manager CDB plan via parameter
2019-02-26 03:55:39  Thread 1 advanced to log sequence 1695 (LGWR switch)
2019-02-26 03:55:39    Current log# 1 seq# 1695 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-26 03:55:39    Current log# 1 seq# 1695 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-26 03:55:39  Archived Log entry 3522 added for T-1.S-1694 ID 0x85e56dfd LAD:1
2019-02-26 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABD]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-26 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-26 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABD]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-26 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-26 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABD]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-26 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-26 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABD]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-26 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-26 06:00:01  Setting Resource Manager plan SCHEDULER[0x4ABD]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-26 06:00:01  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-26 06:00:04  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2135 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 06:00:04  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2138 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 06:00:11  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2000 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 06:00:11  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2003 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 06:05:24  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2252 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 06:05:24  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2255 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 06:05:27  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P1932 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 06:05:27  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P1935 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 06:05:39  Thread 1 advanced to log sequence 1696 (LGWR switch)
2019-02-26 06:05:39    Current log# 2 seq# 1696 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-26 06:05:39    Current log# 2 seq# 1696 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-26 06:05:39  Archived Log entry 3523 added for T-1.S-1695 ID 0x85e56dfd LAD:1
2019-02-26 06:15:25  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2032 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 06:15:25  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2035 (43521) VALUES LESS THAN (TO_DATE(' 2019-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-26 07:15:33  Thread 1 advanced to log sequence 1697 (LGWR switch)
2019-02-26 07:15:33    Current log# 1 seq# 1697 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-26 07:15:33    Current log# 1 seq# 1697 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-26 07:15:34  Archived Log entry 3524 added for T-1.S-1696 ID 0x85e56dfd LAD:1
2019-02-26 08:15:43  Thread 1 advanced to log sequence 1698 (LGWR switch)
2019-02-26 08:15:43    Current log# 2 seq# 1698 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-26 08:15:43    Current log# 2 seq# 1698 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-26 08:15:43  Archived Log entry 3525 added for T-1.S-1697 ID 0x85e56dfd LAD:1
2019-02-26 08:21:22  Thread 1 advanced to log sequence 1699 (LGWR switch)
2019-02-26 08:21:22    Current log# 1 seq# 1699 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-26 08:21:22    Current log# 1 seq# 1699 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-26 08:21:22  Archived Log entry 3526 added for T-1.S-1698 ID 0x85e56dfd LAD:1
2019-02-26 08:45:51  Thread 1 advanced to log sequence 1700 (LGWR switch)
2019-02-26 08:45:51    Current log# 2 seq# 1700 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-26 08:45:51    Current log# 2 seq# 1700 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-26 08:45:51  Archived Log entry 3527 added for T-1.S-1699 ID 0x85e56dfd LAD:1
2019-02-26 10:00:00  Closing scheduler window
2019-02-26 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-26 10:00:00  Clearing Resource Manager plan via parameter
2019-02-26 10:00:00  Closing scheduler window
2019-02-26 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-26 10:00:00  Clearing Resource Manager plan via parameter
2019-02-26 10:00:00  Closing scheduler window
2019-02-26 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-26 10:00:00  Clearing Resource Manager plan via parameter
2019-02-26 10:00:00  Closing scheduler window
2019-02-26 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-26 10:00:00  Clearing Resource Manager plan via parameter
2019-02-26 10:00:00  Closing scheduler window
2019-02-26 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-26 10:00:00  Clearing Resource Manager plan via parameter
2019-02-26 10:18:02  Thread 1 advanced to log sequence 1701 (LGWR switch)
2019-02-26 10:18:02    Current log# 1 seq# 1701 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-26 10:18:02    Current log# 1 seq# 1701 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-26 10:18:02  Archived Log entry 3528 added for T-1.S-1700 ID 0x85e56dfd LAD:1
2019-02-26 12:41:07  Thread 1 advanced to log sequence 1702 (LGWR switch)
2019-02-26 12:41:07    Current log# 2 seq# 1702 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-26 12:41:07    Current log# 2 seq# 1702 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-26 12:41:07  Archived Log entry 3529 added for T-1.S-1701 ID 0x85e56dfd LAD:1
2019-02-26 12:41:09  Thread 1 cannot allocate new log, sequence 1703
2019-02-26 12:41:09  Checkpoint not complete
2019-02-26 12:41:09    Current log# 2 seq# 1702 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-26 12:41:09    Current log# 2 seq# 1702 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-26 12:41:09  Thread 1 advanced to log sequence 1703 (LGWR switch)
2019-02-26 12:41:09    Current log# 1 seq# 1703 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-26 12:41:09    Current log# 1 seq# 1703 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-26 12:41:10  Archived Log entry 3530 added for T-1.S-1702 ID 0x85e56dfd LAD:1
2019-02-26 13:00:37  Thread 1 advanced to log sequence 1704 (LGWR switch)
2019-02-26 13:00:37    Current log# 2 seq# 1704 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-26 13:00:37    Current log# 2 seq# 1704 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-26 13:00:37  Archived Log entry 3531 added for T-1.S-1703 ID 0x85e56dfd LAD:1
2019-02-26 18:10:32  Thread 1 advanced to log sequence 1705 (LGWR switch)
2019-02-26 18:10:32    Current log# 1 seq# 1705 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-26 18:10:32    Current log# 1 seq# 1705 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-26 18:10:32  Archived Log entry 3532 added for T-1.S-1704 ID 0x85e56dfd LAD:1
2019-02-26 18:41:08  Thread 1 advanced to log sequence 1706 (LGWR switch)
2019-02-26 18:41:08    Current log# 2 seq# 1706 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-26 18:41:08    Current log# 2 seq# 1706 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-26 18:41:09  Archived Log entry 3533 added for T-1.S-1705 ID 0x85e56dfd LAD:1
2019-02-26 18:41:13  Thread 1 cannot allocate new log, sequence 1707
2019-02-26 18:41:13  Checkpoint not complete
2019-02-26 18:41:13    Current log# 2 seq# 1706 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-26 18:41:13    Current log# 2 seq# 1706 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-26 18:41:14  Thread 1 advanced to log sequence 1707 (LGWR switch)
2019-02-26 18:41:14    Current log# 1 seq# 1707 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-26 18:41:14    Current log# 1 seq# 1707 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-26 18:41:14  Archived Log entry 3534 added for T-1.S-1706 ID 0x85e56dfd LAD:1
2019-02-26 19:00:33  Thread 1 advanced to log sequence 1708 (LGWR switch)
2019-02-26 19:00:33    Current log# 2 seq# 1708 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-26 19:00:33    Current log# 2 seq# 1708 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-26 19:00:33  Archived Log entry 3535 added for T-1.S-1707 ID 0x85e56dfd LAD:1
2019-02-26 22:00:00  Setting Resource Manager plan SCHEDULER[0x4AC4]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-26 22:00:00  Setting Resource
 Manager CDB plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-26 22:00:03  Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
2019-02-26 22:00:05  End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
2019-02-26 22:00:24  Thread 1 advanced to log sequence 1709 (LGWR switch)
2019-02-26 22:00:24    Current log# 1 seq# 1709 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-26 22:00:24    Current log# 1 seq# 1709 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-26 22:00:24  Archived Log entry 3536 added for T-1.S-1708 ID 0x85e56dfd LAD:1
2019-02-26 22:01:20  Thread 1 cannot allocate new log, sequence 1710
2019-02-26 22:01:20  Checkpoint not complete
2019-02-26 22:01:20    Current log# 1 seq# 1709 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-26 22:01:20    Current log# 1 seq# 1709 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-26 22:01:21  Thread 1 advanced to log sequence 1710 (LGWR switch)
2019-02-26 22:01:21    Current log# 2 seq# 1710 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-26 22:01:21    Current log# 2 seq# 1710 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-26 22:01:21  Archived Log entry 3537 added for T-1.S-1709 ID 0x85e56dfd LAD:1
2019-02-26 22:01:22  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_53246.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14256" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 23:08:07  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_12622.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14259" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 23:18:04  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_23458.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14261" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 23:28:03  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_34762.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14263" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 23:38:04  Thread 1 advanced to log sequence 1711 (LGWR switch)
2019-02-26 23:38:04    Current log# 1 seq# 1711 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-26 23:38:04    Current log# 1 seq# 1711 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-26 23:38:04  Archived Log entry 3538 added for T-1.S-1710 ID 0x85e56dfd LAD:1
2019-02-26 23:38:06  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_45813.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14265" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 23:48:07  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_56808.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14267" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-26 23:58:09  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_10594.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14269" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 00:00:22  TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P2766 (3344) VALUES LESS THAN (TO_DATE(' 2019-02-27 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 00:08:08  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2767 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 00:08:08  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2770 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 00:08:14  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_22236.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14271" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 00:18:15  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_34276.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14273" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 00:28:13  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_45420.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14275" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 00:38:23  Thread 1 advanced to log sequence 1712 (LGWR switch)
2019-02-27 00:38:23    Current log# 2 seq# 1712 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-27 00:38:23    Current log# 2 seq# 1712 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-27 00:38:23  Archived Log entry 3539 added for T-1.S-1711 ID 0x85e56dfd LAD:1
2019-02-27 00:38:25  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_12739.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14277" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 00:48:18  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_24224.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14279" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 00:58:19  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_35638.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14281" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 01:00:32  TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P2771 (3345) VALUES LESS THAN (TO_DATE(' 2019-02-28 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 01:00:32  TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P2772 (3345) VALUES LESS THAN (TO_DATE(' 2019-02-28 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 01:08:26  Thread 1 advanced to log sequence 1713 (LGWR switch)
2019-02-27 01:08:26    Current log# 1 seq# 1713 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 01:08:26    Current log# 1 seq# 1713 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 01:08:26  Archived Log entry 3540 added for T-1.S-1712 ID 0x85e56dfd LAD:1
2019-02-27 01:08:27  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_46113.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14283" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 01:18:23  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_543.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14285" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 01:28:23  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_11938.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14287" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 01:38:27  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_22704.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14289" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 02:00:00  Closing scheduler window
2019-02-27 02:00:00  Closing Resource Manager plan via scheduler window
2019-02-27 02:00:00  Clearing Resource Manager CDB plan via parameter
2019-02-27 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABE]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-27 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-27 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABE]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-27 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-27 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABE]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-27 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-27 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABE]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-27 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-27 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABE]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-27 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-27 06:00:11  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2155 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 06:00:11  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2158 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 06:00:11  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2256 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 06:00:11  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2259 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 06:00:14  Thread 1 advanced to log sequence 1714 (LGWR switch)
2019-02-27 06:00:14    Current log# 2 seq# 1714 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-27 06:00:14    Current log# 2 seq# 1714 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-27 06:00:14  Archived Log entry 3541 added for T-1.S-1713 ID 0x85e56dfd LAD:1
2019-02-27 06:09:13  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P1952 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 06:09:13  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P1955 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 06:09:16  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2036 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 06:09:16  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2039 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 06:09:17  Thread 1 advanced to log sequence 1715 (LGWR switch)
2019-02-27 06:09:17    Current log# 1 seq# 1715 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 06:09:17    Current log# 1 seq# 1715 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 06:09:17  Archived Log entry 3542 added for T-1.S-1714 ID 0x85e56dfd LAD:1
2019-02-27 06:19:15  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2012 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 06:19:15  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2015 (43522) VALUES LESS THAN (TO_DATE(' 2019-02-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-27 06:19:18  Thread 1 advanced to log sequence 1716 (LGWR switch)
2019-02-27 06:19:18    Current log# 2 seq# 1716 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-27 06:19:18    Current log# 2 seq# 1716 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-27 06:19:19  Archived Log entry 3543 added for T-1.S-1715 ID 0x85e56dfd LAD:1
2019-02-27 06:49:53  Thread 1 advanced to log sequence 1717 (LGWR switch)
2019-02-27 06:49:53    Current log# 1 seq# 1717 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 06:49:53    Current log# 1 seq# 1717 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 06:49:53  Archived Log entry 3544 added for T-1.S-1716 ID 0x85e56dfd LAD:1
2019-02-27 07:49:23  Thread 1 advanced to log sequence 1718 (LGWR switch)
2019-02-27 07:49:23    Current log# 2 seq# 1718 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-27 07:49:23    Current log# 2 seq#
1718 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-27 07:49:23  Archived Log entry 3545 added for T-1.S-1717 ID 0x85e56dfd LAD:1
2019-02-27 08:22:44  Thread 1 advanced to log sequence 1719 (LGWR switch)
2019-02-27 08:22:44    Current log# 1 seq# 1719 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 08:22:44    Current log# 1 seq# 1719 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 08:22:45  Archived Log entry 3546 added for T-1.S-1718 ID 0x85e56dfd LAD:1
2019-02-27 08:27:52  Thread 1 advanced to log sequence 1720 (LGWR switch)
2019-02-27 08:27:52    Current log# 2 seq# 1720 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-27 08:27:52    Current log# 2 seq# 1720 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-27 08:27:52  Archived Log entry 3547 added for T-1.S-1719 ID 0x85e56dfd LAD:1
2019-02-27 09:19:45  Thread 1 advanced to log sequence 1721 (LGWR switch)
2019-02-27 09:19:45    Current log# 1 seq# 1721 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 09:19:45    Current log# 1 seq# 1721 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 09:19:45  Archived Log entry 3548 added for T-1.S-1720 ID 0x85e56dfd LAD:1
2019-02-27 10:00:00  Closing scheduler window
2019-02-27 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-27 10:00:00  Clearing Resource Manager plan via parameter
2019-02-27 10:00:00  Closing scheduler window
2019-02-27 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-27 10:00:00  Clearing Resource Manager plan via parameter
2019-02-27 10:00:00  Closing scheduler window
2019-02-27 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-27 10:00:00  Clearing Resource Manager plan via parameter
2019-02-27 10:00:00  Closing scheduler window
2019-02-27 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-27 10:00:00  Clearing Resource Manager plan via parameter
2019-02-27 10:00:00  Closing scheduler window
2019-02-27 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-27 10:00:00  Clearing Resource Manager plan via parameter
2019-02-27 12:41:11  Thread 1 advanced to log sequence 1722 (LGWR switch)
2019-02-27 12:41:11    Current log# 2 seq# 1722 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-27 12:41:11    Current log# 2 seq# 1722 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-27 12:41:12  Archived Log entry 3549 added for T-1.S-1721 ID 0x85e56dfd LAD:1
2019-02-27 12:41:14  Thread 1 cannot allocate new log, sequence 1723
2019-02-27 12:41:14  Checkpoint not complete
2019-02-27 12:41:14    Current log# 2 seq# 1722 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-27 12:41:14    Current log# 2 seq# 1722 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-27 12:41:15  Thread 1 advanced to log sequence 1723 (LGWR switch)
2019-02-27 12:41:15    Current log# 1 seq# 1723 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 12:41:15    Current log# 1 seq# 1723 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 12:41:15  Archived Log entry 3550 added for T-1.S-1722 ID 0x85e56dfd LAD:1
2019-02-27 12:41:18  Thread 1 cannot allocate new log, sequence 1724
2019-02-27 12:41:18  Checkpoint not complete
2019-02-27 12:41:18    Current log# 1 seq# 1723 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 12:41:18    Current log# 1 seq# 1723 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 12:41:18  Thread 1 advanced to log sequence 1724 (LGWR switch)
2019-02-27 12:41:18    Current log# 2 seq# 1724 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-27 12:41:18    Current log# 2 seq# 1724 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-27 12:41:18  Archived Log entry 3551 added for T-1.S-1723 ID 0x85e56dfd LAD:1
2019-02-27 14:38:15  Thread 1 advanced to log sequence 1725 (LGWR switch)
2019-02-27 14:38:15    Current log# 1 seq# 1725 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 14:38:15    Current log# 1 seq# 1725 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 14:38:16  Archived Log entry 3552 added for T-1.S-1724 ID 0x85e56dfd LAD:1
2019-02-27 18:41:15  Thread 1 advanced to log sequence 1726 (LGWR switch)
2019-02-27 18:41:15    Current log# 2 seq# 1726 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-27 18:41:15    Current log# 2 seq# 1726 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-27 18:41:15  Archived Log entry 3553 added for T-1.S-1725 ID 0x85e56dfd LAD:1
2019-02-27 18:41:18  Thread 1 cannot allocate new log, sequence 1727
2019-02-27 18:41:18  Checkpoint not complete
2019-02-27 18:41:18    Current log# 2 seq# 1726 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-27 18:41:18    Current log# 2 seq# 1726 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-27 18:41:18  Thread 1 advanced to log sequence 1727 (LGWR switch)
2019-02-27 18:41:18    Current log# 1 seq# 1727 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 18:41:18    Current log# 1 seq# 1727 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 18:41:18  Archived Log entry 3554 added for T-1.S-1726 ID 0x85e56dfd LAD:1
2019-02-27 18:41:22  Thread 1 cannot allocate new log, sequence 1728
2019-02-27 18:41:22  Checkpoint not complete
2019-02-27 18:41:22    Current log# 1 seq# 1727 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 18:41:22    Current log# 1 seq# 1727 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 18:41:23  Thread 1 advanced to log sequence 1728 (LGWR switch)
2019-02-27 18:41:23    Current log# 2 seq# 1728 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-27 18:41:23    Current log# 2 seq# 1728 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-27 18:41:24  Archived Log entry 3555 added for T-1.S-1727 ID 0x85e56dfd LAD:1
2019-02-27 22:00:00  Setting Resource Manager plan SCHEDULER[0x4AC5]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-27 22:00:00  Setting Resource Manager CDB plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-27 22:00:03  Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
2019-02-27 22:00:05  End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
2019-02-27 22:00:15  Thread 1 advanced to log sequence 1729 (LGWR switch)
2019-02-27 22:00:15    Current log# 1 seq# 1729 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 22:00:15    Current log# 1 seq# 1729 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 22:00:15  Archived Log entry 3556 added for T-1.S-1728 ID 0x85e56dfd LAD:1
2019-02-27 22:00:52  Thread 1 cannot allocate new log, sequence 1730
2019-02-27 22:00:52  Checkpoint not complete
2019-02-27 22:00:52    Current log# 1 seq# 1729 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 22:00:52    Current log# 1 seq# 1729 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 22:00:52  Thread 1 advanced to log sequence 1730 (LGWR switch)
2019-02-27 22:00:52    Current log# 2 seq# 1730 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-27 22:00:52    Current log# 2 seq# 1730 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-27 22:00:52  Archived Log entry 3557 added for T-1.S-1729 ID 0x85e56dfd LAD:1
2019-02-27 22:00:56  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_41201.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14291" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 23:01:48  Thread 1 advanced to log sequence 1731 (LGWR switch)
2019-02-27 23:01:48    Current log# 1 seq# 1731 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-27 23:01:48    Current log# 1 seq# 1731 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-27 23:01:49  Archived Log entry 3558 added for T-1.S-1730 ID 0x85e56dfd LAD:1
2019-02-27 23:01:57  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_49873.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14294" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 23:11:53  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_3036.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14296" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 23:21:55  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_14081.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14298" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 23:31:53  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_24162.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14300" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 23:41:54  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_34885.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14302" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-27 23:51:57  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_45482.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14304" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 00:00:08  ALTER SYSTEM ARCHIVE LOG
2019-02-28 00:00:08  Thread 1 advanced to log sequence 1732 (LGWR switch)
2019-02-28 00:00:08    Current log# 2 seq# 1732 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-28 00:00:08    Current log# 2 seq# 1732 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-28 00:00:08  Archived Log entry 3559 added for T-1.S-1731 ID 0x85e56dfd LAD:1
2019-02-28 00:00:08  ALTER SYSTEM ARCHIVE LOG
2019-02-28 00:00:08  Thread 1 cannot allocate new log, sequence 1733
2019-02-28 00:00:08  Checkpoint not complete
2019-02-28 00:00:08    Current log# 2 seq# 1732 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-28 00:00:08    Current log# 2 seq# 1732 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-28 00:00:10  Thread 1 advanced to log sequence 1733 (LGWR switch)
2019-02-28 00:00:10    Current log# 1 seq# 1733 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-28 00:00:10    Current log# 1 seq# 1733 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-28 00:00:10  Archived Log entry 3560 added for T-1.S-1732 ID 0x85e56dfd LAD:1
2019-02-28 00:01:55  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2775 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 00:01:55  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2778 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 00:01:59  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_56588.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14306" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 00:12:01  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_8209.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14308" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 00:22:02  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_18816.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14310" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 00:24:24  ALTER SYSTEM ARCHIVE LOG
2019-02-28 00:24:24  Thread 1 advanced to log sequence 1734 (LGWR switch)
2019-02-28 00:24:24    Current log# 2 seq# 1734 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-28 00:24:24    Current log# 2 seq# 1734 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-28 00:24:24  Archived Log entry 3561 added for T-1.S-1733 ID 0x85e56dfd LAD:1
2019-02-28 00:24:25  Starting control autobackup
2019-02-28 00:24:27  Control autobackup written to DISK device
2019-02-28 00:24:27  handle '+FIR/ORCL/AUTOBACKUP/2019_02_28/s_1001377465.4071.1001377467'
2019-02-28 00:32:07  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_34345.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14312" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 00:42:22  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_52765.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14314" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 00:43:18  TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P2779 (3345) VALUES LESS THAN (TO_DATE(' 2019-02-28 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 00:52:06  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_6009.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14316" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 01:00:18  Thread 1 advanced to log sequence 1735 (LGWR
 switch)
2019-02-28 01:00:18    Current log# 1 seq# 1735 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-28 01:00:18    Current log# 1 seq# 1735 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-28 01:00:18  Archived Log entry 3562 added for T-1.S-1734 ID 0x85e56dfd LAD:1
2019-02-28 01:02:10  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_17086.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14318" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 01:12:10  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_28364.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14320" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 01:22:13  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_40374.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14322" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 01:32:13  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_51173.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14324" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 01:42:14  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_4668.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14326" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 01:52:30  TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P2780 (3346) VALUES LESS THAN (TO_DATE(' 2019-03-01 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 01:52:30  TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P2781 (3346) VALUES LESS THAN (TO_DATE(' 2019-03-01 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 02:00:00  Closing scheduler window
2019-02-28 02:00:00  Closing Resource Manager plan via scheduler window
2019-02-28 02:00:00  Clearing Resource Manager CDB plan via parameter
2019-02-28 03:00:38  Thread 1 advanced to log sequence 1736 (LGWR switch)
2019-02-28 03:00:38    Current log# 2 seq# 1736 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-28 03:00:38    Current log# 2 seq# 1736 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-28 03:00:38  Archived Log entry 3563 added for T-1.S-1735 ID 0x85e56dfd LAD:1
2019-02-28 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABF]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-28 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-28 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABF]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-28 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-28 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABF]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-28 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-28 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABF]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-28 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-28 06:00:00  Setting Resource Manager plan SCHEDULER[0x4ABF]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-28 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-28 06:00:10  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2032 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 06:00:10  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2035 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 06:00:11  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2175 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 06:00:11  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2178 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 06:00:18  Thread 1 advanced to log sequence 1737 (LGWR switch)
2019-02-28 06:00:18    Current log# 1 seq# 1737 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-28 06:00:18    Current log# 1 seq# 1737 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-28 06:00:19  Archived Log entry 3564 added for T-1.S-1736 ID 0x85e56dfd LAD:1
2019-02-28 06:03:01  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2040 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 06:03:01  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2043 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 06:03:05  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2260 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 06:03:05  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2263 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 06:13:03  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P1972 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 06:13:03  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P1975 (43523) VALUES LESS THAN (TO_DATE(' 2019-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-02-28 06:13:10  Thread 1 advanced to log sequence 1738 (LGWR switch)
2019-02-28 06:13:10    Current log# 2 seq# 1738 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-28 06:13:10    Current log# 2 seq# 1738 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-28 06:13:10  Archived Log entry 3565 added for T-1.S-1737 ID 0x85e56dfd LAD:1
2019-02-28 07:13:13  Thread 1 advanced to log sequence 1739 (LGWR switch)
2019-02-28 07:13:13    Current log# 1 seq# 1739 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-28 07:13:13    Current log# 1 seq# 1739 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-28 07:13:13  Archived Log entry 3566 added for T-1.S-1738 ID 0x85e56dfd LAD:1
2019-02-28 08:03:16  Thread 1 advanced to log sequence 1740 (LGWR switch)
2019-02-28 08:03:16    Current log# 2 seq# 1740 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-28 08:03:16    Current log# 2 seq# 1740 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-28 08:03:16  Archived Log entry 3567 added for T-1.S-1739 ID 0x85e56dfd LAD:1
2019-02-28 08:24:10  Thread 1 advanced to log sequence 1741 (LGWR switch)
2019-02-28 08:24:10    Current log# 1 seq# 1741 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-28 08:24:10    Current log# 1 seq# 1741 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-28 08:24:10  Archived Log entry 3568 added for T-1.S-1740 ID 0x85e56dfd LAD:1
2019-02-28 08:53:29  Thread 1 advanced to log sequence 1742 (LGWR switch)
2019-02-28 08:53:29    Current log# 2 seq# 1742 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-28 08:53:29    Current log# 2 seq# 1742 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-28 08:53:30  Archived Log entry 3569 added for T-1.S-1741 ID 0x85e56dfd LAD:1
2019-02-28 10:00:00  Closing scheduler window
2019-02-28 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-28 10:00:00  Clearing Resource Manager plan via parameter
2019-02-28 10:00:00  Closing scheduler window
2019-02-28 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-28 10:00:00  Clearing Resource Manager plan via parameter
2019-02-28 10:00:00  Closing scheduler window
2019-02-28 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-28 10:00:00  Clearing Resource Manager plan via parameter
2019-02-28 10:00:00  Closing scheduler window
2019-02-28 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-28 10:00:00  Clearing Resource Manager plan via parameter
2019-02-28 10:00:00  Closing scheduler window
2019-02-28 10:00:00  Closing Resource Manager plan via scheduler window
2019-02-28 10:00:00  Clearing Resource Manager plan via parameter
2019-02-28 10:00:45  Thread 1 advanced to log sequence 1743 (LGWR switch)
2019-02-28 10:00:45    Current log# 1 seq# 1743 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-28 10:00:45    Current log# 1 seq# 1743 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-28 10:00:46  Archived Log entry 3570 added for T-1.S-1742 ID 0x85e56dfd LAD:1
2019-02-28 14:29:23  Thread 1 advanced to log sequence 1744 (LGWR switch)
2019-02-28 14:29:23    Current log# 2 seq# 1744 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-28 14:29:23    Current log# 2 seq# 1744 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-28 14:29:24  Archived Log entry 3571 added for T-1.S-1743 ID 0x85e56dfd LAD:1
2019-02-28 19:30:12  Thread 1 advanced to log sequence 1745 (LGWR switch)
2019-02-28 19:30:12    Current log# 1 seq# 1745 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-28 19:30:12    Current log# 1 seq# 1745 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-28 19:30:12  Archived Log entry 3572 added for T-1.S-1744 ID 0x85e56dfd LAD:1
2019-02-28 22:00:00  Setting Resource Manager plan SCHEDULER[0x4AC6]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-02-28 22:00:00  Setting Resource Manager CDB plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-02-28 22:00:03  Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
2019-02-28 22:00:07  End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
2019-02-28 22:00:32  Thread 1 advanced to log sequence 1746 (LGWR switch)
2019-02-28 22:00:32    Current log# 2 seq# 1746 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-28 22:00:32    Current log# 2 seq# 1746 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-28 22:00:32  Archived Log entry 3573 added for T-1.S-1745 ID 0x85e56dfd LAD:1
2019-02-28 22:00:52  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j001_23228.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14328" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 23:00:47  Thread 1 advanced to log sequence 1747 (LGWR switch)
2019-02-28 23:00:47    Current log# 1 seq# 1747 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-02-28 23:00:47    Current log# 1 seq# 1747 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-02-28 23:00:48  Archived Log entry 3574 added for T-1.S-1746 ID 0x85e56dfd LAD:1
2019-02-28 23:05:42  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_39721.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14331" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 23:15:40  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_51184.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14333" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 23:25:41  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_4488.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14335" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 23:30:52  Thread 1 advanced to log sequence 1748 (LGWR switch)
2019-02-28 23:30:52    Current log# 2 seq# 1748 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-02-28 23:30:52    Current log# 2 seq# 1748 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-02-28 23:30:52  Archived Log entry 3575 added for T-1.S-1747 ID 0x85e56dfd LAD:1
2019-02-28 23:35:43  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_15081.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14337" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 23:45:45  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_26087.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14339" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-02-28 23:55:46  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_37255.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14341" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-03-01 00:05:45  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2784 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 00:05:45  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2787 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 00:05:50  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_48248.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14343" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS
_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-03-01 00:15:49  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_2353.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14345" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-03-01 00:25:51  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_12926.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14347" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-03-01 00:35:54  Thread 1 advanced to log sequence 1749 (LGWR switch)
2019-03-01 00:35:54    Current log# 1 seq# 1749 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-03-01 00:35:54    Current log# 1 seq# 1749 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-03-01 00:35:54  Archived Log entry 3576 added for T-1.S-1748 ID 0x85e56dfd LAD:1
2019-03-01 00:35:56  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_36810.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14349" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-03-01 00:46:02  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_47886.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14351" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-03-01 00:47:08  TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P2788 (3346) VALUES LESS THAN (TO_DATE(' 2019-03-01 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 00:55:56  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_1085.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14353" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-03-01 01:05:58  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_11712.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14355" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-03-01 01:06:11  TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P2789 (3347) VALUES LESS THAN (TO_DATE(' 2019-03-02 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 01:06:11  TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P2790 (3347) VALUES LESS THAN (TO_DATE(' 2019-03-02 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 01:15:59  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_21719.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14357" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-03-01 01:26:01  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_32031.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14359" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-03-01 01:36:02  Errors in file /u01/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_j000_41754.trc:
ORA-12012: 自动执行作业 "SYS"."ORA$AT_OS_OPT_SY_14361" 出错
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: 在 "SYS.DBMS_STATS", line 47207
ORA-06512: 在 "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 20059
ORA-06512: 在 "SYS.DBMS_STATS_INTERNAL", line 22201
ORA-06512: 在 "SYS.DBMS_STATS", line 47197
2019-03-01 02:00:00  Closing scheduler window
2019-03-01 02:00:00  Closing Resource Manager plan via scheduler window
2019-03-01 02:00:00  Clearing Resource Manager CDB plan via parameter
2019-03-01 02:00:16  Thread 1 advanced to log sequence 1750 (LGWR switch)
2019-03-01 02:00:16    Current log# 2 seq# 1750 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-03-01 02:00:16    Current log# 2 seq# 1750 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-03-01 02:00:16  Archived Log entry 3577 added for T-1.S-1749 ID 0x85e56dfd LAD:1
2019-03-01 06:00:00  Setting Resource Manager plan SCHEDULER[0x4AC0]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-03-01 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-03-01 06:00:00  Setting Resource Manager plan SCHEDULER[0x4AC0]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-03-01 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-03-01 06:00:00  Setting Resource Manager plan SCHEDULER[0x4AC0]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-03-01 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-03-01 06:00:00  Setting Resource Manager plan SCHEDULER[0x4AC0]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-03-01 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-03-01 06:00:00  Setting Resource Manager plan SCHEDULER[0x4AC0]:DEFAULT_MAINTENANCE_PLAN via scheduler window
2019-03-01 06:00:00  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
2019-03-01 06:00:09  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2052 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 06:00:09  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2055 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 06:00:09  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2195 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 06:00:09  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2198 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 06:06:51  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2264 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 06:06:51  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2267 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 06:06:54  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P1992 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 06:06:54  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P1995 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 06:06:56  Thread 1 advanced to log sequence 1751 (LGWR switch)
2019-03-01 06:06:56    Current log# 1 seq# 1751 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-03-01 06:06:56    Current log# 1 seq# 1751 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-03-01 06:06:57  Archived Log entry 3578 added for T-1.S-1750 ID 0x85e56dfd LAD:1
2019-03-01 06:16:52  TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P2044 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 06:16:52  TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P2047 (43524) VALUES LESS THAN (TO_DATE(' 2019-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2019-03-01 07:26:59  Thread 1 advanced to log sequence 1752 (LGWR switch)
2019-03-01 07:26:59    Current log# 2 seq# 1752 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-03-01 07:26:59    Current log# 2 seq# 1752 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-03-01 07:27:00  Archived Log entry 3579 added for T-1.S-1751 ID 0x85e56dfd LAD:1
2019-03-01 08:25:34  Thread 1 advanced to log sequence 1753 (LGWR switch)
2019-03-01 08:25:34    Current log# 1 seq# 1753 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-03-01 08:25:34    Current log# 1 seq# 1753 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-03-01 08:25:34  Archived Log entry 3580 added for T-1.S-1752 ID 0x85e56dfd LAD:1
2019-03-01 08:25:35  Thread 1 cannot allocate new log, sequence 1754
2019-03-01 08:25:35  Checkpoint not complete
2019-03-01 08:25:35    Current log# 1 seq# 1753 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-03-01 08:25:35    Current log# 1 seq# 1753 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-03-01 08:25:36  Thread 1 advanced to log sequence 1754 (LGWR switch)
2019-03-01 08:25:36    Current log# 2 seq# 1754 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-03-01 08:25:36    Current log# 2 seq# 1754 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-03-01 08:25:36  Archived Log entry 3581 added for T-1.S-1753 ID 0x85e56dfd LAD:1
2019-03-01 09:17:23  Thread 1 advanced to log sequence 1755 (LGWR switch)
2019-03-01 09:17:23    Current log# 1 seq# 1755 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.990479999
2019-03-01 09:17:23    Current log# 1 seq# 1755 mem# 1: +FIR/ORCL/ONLINELOG/group_1.257.990480001
2019-03-01 09:17:23  Archived Log entry 3582 added for T-1.S-1754 ID 0x85e56dfd LAD:1
2019-03-01 10:00:00  Closing scheduler window
2019-03-01 10:00:00  Closing Resource Manager plan via scheduler window
2019-03-01 10:00:00  Clearing Resource Manager plan via parameter
2019-03-01 10:00:00  Closing scheduler window
2019-03-01 10:00:00  Closing Resource Manager plan via scheduler window
2019-03-01 10:00:00  Clearing Resource Manager plan via parameter
2019-03-01 10:00:00  Closing scheduler window
2019-03-01 10:00:00  Closing Resource Manager plan via scheduler window
2019-03-01 10:00:00  Clearing Resource Manager plan via parameter
2019-03-01 10:00:00  Closing scheduler window
2019-03-01 10:00:00  Closing Resource Manager plan via scheduler window
2019-03-01 10:00:00  Clearing Resource Manager plan via parameter
2019-03-01 10:00:00  Closing scheduler window
2019-03-01 10:00:00  Closing Resource Manager plan via scheduler window
2019-03-01 10:00:00  Clearing Resource Manager plan via parameter
2019-03-01 12:41:24  Thread 1 advanced to log sequence 1756 (LGWR switch)
2019-03-01 12:41:24    Current log# 2 seq# 1756 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.990479999
2019-03-01 12:41:24    Current log# 2 seq# 1756 mem# 1: +FIR/ORCL/ONLINELOG/group_2.258.990480001
2019-03-01 12:41:24  Archived Log entry 3583 added for T-1.S-1755 ID 0x85e56dfd LAD:1
2019-03-01 14:37:40  TABLE AUDSYS.AUD$UNIFIED: ADDED INTERVAL PARTITION SYS_P2793 (57) VALUES LESS THAN (TIMESTAMP' 2019-04-01 00:00:00')

暂无图片 评论
暂无图片 有用 0
章芋文

这是oracle的一个bug,可通过sysdba登陆执行如下命令解决:

EXEC dbms_stats.init_package()
EXEC dbms_stats.set_advisor_task_parameter('AUTO_STATS_ADVISOR_TASK', 
'DAYS_TO_EXPIRE', 'UNLIMITED');
EXEC dbms_stats.set_advisor_task_parameter('AUTO_STATS_ADVISOR_TASK', 
'EXECUTION_DAYS_TO_EXPIRE', 30);
EXEC dbms_stats.set_advisor_task_parameter('INDIVIDUAL_STATS_ADVISOR_TASK','DAYS_TO
_EXPIRE', 'UNLIMITED');
EXEC dbms_stats.set_advisor_task_parameter('INDIVIDUAL_STATS_ADVISOR_TASK','EXECUTI
ON_DAYS_TO_EXPIRE', 30);

暂无图片 评论
暂无图片 有用 0
章芋文

第一句后面的分号去掉了,请注意:

EXEC dbms_stats.init_package();
暂无图片 评论
暂无图片 有用 0

 

SQL> EXEC dbms_stats.init_package();

PL/SQL procedure successfully completed.

SQL> EXEC dbms_stats.set_advisor_task_parameter('AUTO_STATS_ADVISOR_TASK','DAYS_TO_EXPIRE','UNLIMITED');
BEGIN dbms_stats.set_advisor_task_parameter('AUTO_STATS_ADVISOR_TASK','DAYS_TO_EXPIRE','UNLIMITED'); END;

*
ERROR at line 1:
ORA-20001: Statistics Advisor: Invalid parameter to set: parameter DAYS_TO_EXPIRE does not exist for statistics advisor
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 4598
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 4591
ORA-06512: at "SYS.DBMS_STATS", line 53460
ORA-06512: at line 1

暂无图片 评论
暂无图片 有用 0
章芋文

第一个执行成功后可先观察下报错是否还存在。

暂无图片 评论
暂无图片 有用 0
章芋文
问题已关闭: 问题过期
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏