Hi All,
I am seeing following error in Alert log file of Database in 12cR2 Rac+ASM RHEL 7 setup ,This error is generated while taking hot backup using backup tool.
Please could someone help me identify the issue and rca of error as follows.
======================================================================================
Errors in file /u01/app/oracle/diag/rdbms/orcl/racdb11/trace/racdb11_j000_16905.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_2809"
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
2017-07-20T01:00:40.509763-06:00
TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P740 (2758) VALUES LESS THAN (TO_DATE(' 2017-07-21 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P741 (2758) VALUES LESS THAN (TO_DATE(' 2017-07-21 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2017-07-20T01:03:57.616806-06:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/racdb11/trace/racdb11_j000_20473.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_2811"
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
2017-07-20T01:13:47.116937-06:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/racdb11/trace/racdb11_j000_23972.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_2813"
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
2017-07-20T01:23:47.304432-06:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/racdb11/trace/racdb11_j000_26863.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_2815"
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
2017-07-20T01:33:49.425011-06:00
=======================================================================================
Full Error Logs.
-----------------------------------------------------------------
2017-07-18T02:00:00.722655-06:00
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager CDB plan via parameter
2017-07-18T04:56:46.680181-06:00
ALTER SYSTEM ARCHIVE LOG
2017-07-18T04:56:46.703972-06:00
Thread 2 advanced to log sequence 62 (alter system archive log)
2017-07-18T04:56:46.770862-06:00
Archived Log entry 169 added for T-2.S-61 ID 0x57edcb78 LAD:1
2017-07-18T04:56:46.779842-06:00
Thread 1 advanced to log sequence 117 (LGWR switch)
Current log# 1 seq# 117 mem# 0: +DATA/ORCL/ONLINELOG/group_1.262.947424767
2017-07-18T04:56:47.030881-06:00
Archived Log entry 170 added for T-1.S-116 ID 0x57edcb78 LAD:1
2017-07-18T04:56:48.194063-06:00
alter database begin backup
Completed: alter database begin backup
2017-07-18T04:56:57.400811-06:00
alter database end backup
Completed: alter database end backup
2017-07-18T04:56:58.196300-06:00
ALTER SYSTEM ARCHIVE LOG
2017-07-18T04:56:58.214222-06:00
Thread 2 advanced to log sequence 63 (alter system archive log)
2017-07-18T04:56:58.266736-06:00
Archived Log entry 171 added for T-2.S-62 ID 0x57edcb78 LAD:1
2017-07-18T04:56:58.275866-06:00
Thread 1 advanced to log sequence 118 (LGWR switch)
Current log# 2 seq# 118 mem# 0: +DATA/ORCL/ONLINELOG/group_2.263.947424767
2017-07-18T04:56:58.339237-06:00
Archived Log entry 172 added for T-1.S-117 ID 0x57edcb78 LAD:1
2017-07-18T04:57:01.879355-06:00
alter database backup controlfile
to '+DATA/ORCL/CONTROLFILE/controlfile7576' reuse
Completed: alter database backup controlfile
to '+DATA/ORCL/CONTROLFILE/controlfile7576' reuse
ALTER database backup controlfile to trace
as '/tmp/ascii_controlfile7576' reuse
Completed: ALTER database backup controlfile to trace
as '/tmp/ascii_controlfile7576' reuse
2017-07-18T06:08:23.972931-06:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/racdb11/trace/racdb11_j000_16905.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_2809"
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
2017-07-20T01:00:40.509763-06:00
TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P740 (2758) VALUES LESS THAN (TO_DATE(' 2017-07-21 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P741 (2758) VALUES LESS THAN (TO_DATE(' 2017-07-21 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
2017-07-20T01:03:57.616806-06:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/racdb11/trace/racdb11_j000_20473.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_2811"
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
2017-07-20T01:13:47.116937-06:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/racdb11/trace/racdb11_j000_23972.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_2813"
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
2017-07-20T01:23:47.304432-06:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/racdb11/trace/racdb11_j000_26863.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_2815"
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
2017-07-20T01:33:49.425011-06:00
Thanks,
Mallik S