系统shedule

告警日志里面报错

Errors in file /usr/oracle/admin/szyth/bdump/szyth_j001_22675616.trc:

ORA-12012: error on auto execute of job 8898
ORA-00376: file ORA-00376: file 15 cannot be read at this time
ORA-01110: data file 15: '/dev/rlvszsi_old01'
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1344

ORA-06512: at "SYS.DBMS_SPACE", line 1560

SQL> select job from dba_jobs;


       JOB
----------
         1
         2
        22

根本就找不到8898的job。

SQL> select job_name,state,enabled,last_start_date from dba_scheduler_jobs;

JOB_NAME                       STATE           ENABL
------------------------------ --------------- -----
LAST_START_DATE
---------------------------------------------------------------------------
PURGE_LOG                      SCHEDULED       TRUE
04-JUN-14 03.00.00.180019 AM +08:00

FGR$AUTOPURGE_JOB              DISABLED        FALSE


GATHER_STATS_JOB               SCHEDULED       TRUE
03-JUN-14 11.00.02.827817 PM +09:00


JOB_NAME                       STATE           ENABL
------------------------------ --------------- -----
LAST_START_DATE
---------------------------------------------------------------------------
<span style="color:#ff0000;">AUTO_SPACE_ADVISOR_JOB  </span>       SCHEDULED       TRUE
03-JUN-14 11.00.02.827855 PM +09:00

RLM$EVTCLEANUP                 SCHEDULED       TRUE
04-JUN-14 02.40.50.175205 PM +08:00

RLM$SCHDNEGACTION              SCHEDULED       TRUE
04-JUN-14 03.49.41.149703 PM +09:00


6 rows selected.

Automatic Segment Advisor Job

A Scheduler job AUTO_SPACE_ADVISOR_JOB is also predefined upon installation. AUTO_SPACE_ADVISOR_JOB runs the Automatic Segment Advisor, which identifies segments that have space available for reclamation, and then makes recommendations that you can view with Enterprise Manager or a set of PL/SQL package procedures.

You can run the Segment Advisor manually to obtain more up-to-the-minute recommendations or to obtain recommendations on segments that the Automatic Segment Advisor did not examine for possible space reclamation.