What Makes Instance Shutdown Itself
What 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
ORA-19809
How to Resolve ORA-00257: archiver error. Connect internal only, until freed.
ORA-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 Files
ORA-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