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…

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…

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…

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…

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