NoLogging Corruption Woes

From: April Sims <aprilcsims_at_gmail.com>
Date: Wed, 5 Jun 2013 08:24:16 -0500
Message-ID: <CAK+cZDeUjgYkSkoGLo6C7O1UjC2D1k=GRN2G8KfWKxuHGNYSbg_at_mail.gmail.com>

Ok....need some assistance. Open SR with Oracle said to drop table, recreate and import the data. Corruption is still being reported. Ran DBV, same results.
DBV-00201: Block, DBA 28211119, marked corrupt for invalid redo application

This is a third party application so we don't have knowledge of exactly how this happened. Have turned on forced logging to prevent any in the future.

Cloning the database to another SID, removes the corruption. We can select all of the data from the underlying table, the other objects in the corruption report is the dependent indexes and PK/FK (s).

SQL> select * from V$DATABASE_BLOCK_CORRUPTION;

     FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------

         6    3044768         16         1.1019E+11 NOLOGGING
         6       2248         16         1.1012E+11 NOLOGGING
         6    3045250         46         1.1019E+11 NOLOGGING
         6    2900866         46         1.1022E+11 NOLOGGING
         6    1180371          5         1.1015E+11 NOLOGGING
         6       2368          8         1.1012E+11 NOLOGGING
         8    4106416         16         1.1019E+11 NOLOGGING
         8    4121248         16         1.1021E+11 NOLOGGING
         8    4116848         16         1.1021E+11 NOLOGGING
         8    4116784         16         1.1021E+11 NOLOGGING
         8    4096368         16         1.1017E+11 NOLOGGING

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO


---------- ---------- ---------- ------------------ ---------

         8    4085808         16         1.1016E+11 NOLOGGING
         8    4116738         14         1.1021E+11 NOLOGGING
         8    4106464         32         1.1019E+11 NOLOGGING
         8    4106336         32         1.1019E+11 NOLOGGING
         8    4106272         32         1.1019E+11 NOLOGGING
         8    4106242         14         1.1019E+11 NOLOGGING
         8    4096288         32         1.1017E+11 NOLOGGING
         8    4096258         14         1.1017E+11 NOLOGGING
         8    4085856         32         1.1016E+11 NOLOGGING
         8    2839931          5         1.1012E+11 NOLOGGING
         8    2839920          8         1.1012E+11 NOLOGGING

     FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO


---------- ---------- ---------- ------------------ ---------

         8    2839865          7         1.1012E+11 NOLOGGING
         8    2839856          8         1.1012E+11 NOLOGGING
         9      55536         16         1.1021E+11 NOLOGGING
         9      55328         32         1.1021E+11 NOLOGGING
         9      55298         14         1.1021E+11 NOLOGGING
         9      55392         32         1.1021E+11 NOLOGGING
         9      43744         32         1.1021E+11 NOLOGGING
         9      43680         32         1.1021E+11 NOLOGGING

30 rows selected.

--

April C. Sims
IOUG SELECT Journal Editor
http://aprilcsims.wordpress.com
Twitter, LinkedIn
Oracle Database 11g – Underground Advice for Database Administrators <http://www.amazon.com/Oracle-Database-Underground-Advice-Administrators/dp/1849680000/ref=sr_1_1?ie=UTF8&s=books&qid72289339&sr=8-1#noop> https://www.packtpub.com/oracle-11g-database-implementations-guide/book OCP 8i, 9i, 10g, 11g DBA
Southern Utah University
aprilcsims_at_gmail.com

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 05 2013 - 15:24:16 CEST