When starting one of the databases we received the ORA-00353 error. It indicates that archiver process couldn’t archive one of the redo logs due to corruption. Oracle tried to read both the logmembers from the same group but they both were corrupted and instance crashes when trying to open it. ARC0: STARTING ARCH PROCESSES COMPLETE ARCH: Log corruption near block 88727 change 12629319 time ? … Continue reading ORA-00353: during startup of instance from archiver process
Below are the steps on how to add a new online redo-group. It could be of the same size as other groups or different size. 1) List log groups, their archive status, activity status and size SQL> SELECT GROUP#, ARCHIVED, STATUS, BYTES FROM V$LOG; GROUP# ARC STATUS BYTES ———- — —————- ———– 1 NO ACTIVE 104857600 2 NO CURRENT 104857600 3 NO INACTIVE 104857600 2) … Continue reading How to add or drop online-redo logs?
If for some reason the online redo log were lost or when cloning the copy of shutdown database you don’t have the on-line redo logs, you would need to open the database with “RESETLOGS” option which will create the online redo logs. Example: SQL> startup nomount; ORACLE instance started. Total System Global Area 521936896 bytes Fixed Size 2177328 bytes Variable Size 356517584 bytes Database Buffers … Continue reading How to fix issue when the online redo logs are missing?
Today, due to a network issue the host (Solaries) lost contact with the NetApp filer and it corrupted some datafiles and redo log files. The solution was to recreate all indexes from the corrupted datafile in a new tablespace and drop the corrupted tablespace. The archived log process hung because it could not archive the log 464704 which got corrupted, the solution was to clear … Continue reading How to fix Online redo log corruption?