Scheduler Not Working On Logical Standby Database-优快云博客

本文介绍了当Logical Standby数据库中DBMS_SCHEDULER无法运行已安排任务时的问题及解决方案。故障表现为手动执行GATHER_STATS_JOB任务时出现超时错误。通过调整数据库配置并启用特定跟踪事件来解决该问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

logical standby不会进行自动收集信息需要如下方式解决：

Scheduler Not Working On Logical Standby Database [ID 744856.1]

Modified 13-FEB-2012 Type PROBLEM Status PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.2.0.4 to 10.2.0.4

Symptoms

DBMS_SCHEDULER is working correctly in the primary database.

In a logical standby database, DBMS_SCHEDULER does not run the scheduled jobs.

Additionally, unable to get this statement to run manually via SQLPLUS:

execute DBMS_SCHEDULER.RUN_JOB ('GATHER_STATS_JOB', FALSE);
BEGIN DBMS_SCHEDULER.RUN_JOB ('GATHER_STATS_JOB', FALSE); END;

*
ERROR at line 1:
ORA-02800: Requests timed out
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at line 1

Cause

Logical standby database was not setup properly to handle the DBMS_SCHEDULER.

Solution

If using a pfile:

1) alter database stop logical standby apply;
2) shutdown immediate;
3) In the init.ora file set the public logical standby event:
event ' "10793 trace name context forever, level 2" '

4) Startup

5) Set up dataguard AND standby :
alter database start logical standby apply immediate;
alter database guard standby;

Alternatively, if using an spfile:

1) alter database stop logical standby apply;
2) alter system set event = '10793 trace name context forever, level 2' scope=spfile;
3) shutdown immediate;
4) startup;
5) alter database start logical standby apply immediate;
6) alter database guard standby;

7) execute DBMS_SCHEDULER.RUN_JOB ('GATHER_STATS_JOB', true);

Note: This issue is fixed in 10.2.0.5

References

BUG:6722640 - SCHEDULER DOES NOT GATHER STATISTICS ON LOGICAL STANDBY

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24849178/viewspace-733297/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24849178/viewspace-733297/