ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Scheduler Not Working On Logical Standby Database

Scheduler Not Working On Logical Standby Database

原创 Linux操作系统 作者:g644516804 时间:2012-06-20 09:34:54 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: ORA-39062
下一篇: odu truncate table
请登录后发表评论 登录
全部评论

注册时间:2011-03-04

  • 博文量
    104
  • 访问量
    229834