ORA-00353: during startup of instance from archiver process

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

How to add or drop online-redo logs?

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?

How to fix issue when the online redo logs are missing?

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?

redo log generation during unrecoverable/nologging

# Capture amount of redo logs generated when table is created in UNRECOVERABLE SQL> select vs.name, vm.value from v$mystat vm, v$statname vs where vm.statistic# = vs.statistic# and vs.name like '%redo size%'; NAME VALUE —————————————————————- ———- redo size 597736 SQL> create table test_all unrecoverable as (select * from all_objects); Table created. SQL> select vs.name, vm.value from v$mystat vm, v$statname vs where vm.statistic# = vs.statistic# and vs.name … Continue reading redo log generation during unrecoverable/nologging

How to fix Online redo log corruption?

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?

How full is the current redo log file?

SQL> SELECT le.leseq “Current log sequence No”, 100*cp.cpodr_bno/le.lesiz “Percent Full”, cp.cpodr_bno “Current Block No”, le.lesiz “Size of Log in Blocks” FROM x$kcccp cp, x$kccle le WHERE le.leseq =CP.cpodr_seq AND bitand(le.leflg,24) = 8; Current log sequence No Percent Full Current Block No Size of Log in Blocks ———————– ———— —————- ——————— 13 29.0625 29760 102400 Continue reading How full is the current redo log file?