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】
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
墨值悬赏

