What Makes Instance Shutdown Itselfby Ed ChenNovember 6, 2019November 22, 2022What makes a running instance shutdown itself could be a very complicated topic to talk about, because we have to know what instance was thinking.… Read More »What Makes Instance Shutdown Itself
How to Resolve ORA-00257: archiver error. Connect internal only, until freed.by Ed ChenDecember 4, 2014December 11, 2022ORA-00257 A scheduler job which is refreshing materialized views threw an error ORA-00257 in the alert log like this: ORA-12012: error on auto execute of… Read More »How to Resolve ORA-00257: archiver error. Connect internal only, until freed.
How to Resolve ORA-19809 Limit Exceeded for Recovery Filesby Ed ChenOctober 22, 2012December 11, 202210 CommentsORA-19809 We usually watch the space usage of log archive destination very closely because the database will be suspended if the space is full. Particularly,… Read More »How to Resolve ORA-19809 Limit Exceeded for Recovery Files