This message was in the alert log :
Wed Jun 27 03:00:40 2001
Errors in file /home/dba/oracle/admin/PROD/bdump/prod_snp0_24973.trc:
ORA-12012: error on auto execute of job 206
ORA-12008: error in snapshot refresh path
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386
ORA-06512: at "SYS.DBMS_IREFRESH", line 450
ORA-06512: at "SYS.DBMS_REFRESH", line 182
ORA-06512: at line 1
The database that this snapshot is created from is in fact shutdown at 3:00am every morning for a cold backup (as it always has been), but what I don't understand is why this snapshot even tried to refresh at this time because it isn't supposed to refresh until 7:30am!
SQL> select * from dba_jobs where job=206;
JOB LOG_USER PRIV_USER
---------- ------------------------------ ------------------------------
SCHEMA_USER LAST_DATE LAST_SEC THIS_DATE THIS_SEC NEXT_DATE
------------------------------ --------- -------- --------- -------- ---------
NEXT_SEC TOTAL_TIME B INTERVAL
-------- ---------- - -----------------------------------------------
FAILURES WHAT
---------- --------------------------------------------------
CURRENT_SESSION_LABEL
-----------------------------------------------------------------------
CLEARANCE_HI
-----------------------------------------------------------------------
CLEARANCE_LO
-----------------------------------------------------------------------
NLS_ENV
------------------------------------------------------------------------
MISC_ENV
----------------------------------------------------------------
206 CPBX CPBX
CPBX 27-JUN-01 06:27:15 28-JUN-01
07:36:00 164002 N ROUND( LEAST( NEXT_DAY( SYSDATE, 'MONDAY'), NEXT
_DAY( SYSDATE, 'TUESDAY'), NEXT_DAY( SYSDATE, 'W
EDNESDAY'), NEXT_DAY( SYSDATE, 'THURSDAY'), NE
XT_DAY( SYSDATE, 'FRIDAY'))) + 7.6/24
0 dbms_refresh.refresh('"CPBX"."CPBX_SPRADDR"');
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENC
Y='AMERICA' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-YY' NLS_DATE_LAN
GUAGE='AMERICAN' NLS_SORT='BINARY'
0102000200000000
Does anyone have any ideas on why this snapshot tried to refresh at this time, or any suggestions on other things I need to check? This snapshot has been being refreshed at 7:30am for months with no problems. And I'm stumped as to why we got this ORA- error in our alert log.
[Edited by lake612 on 06-27-2001 at 11:33 AM]
