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!
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.