4 Replies Latest reply on Feb 11, 2016 7:18 AM by hassanksa

    DBF file corruption -- Please help

    hassanksa

      Dear All Hello,

       

      I am facing an issue, i have two dbf files which are corrupt, please tell me  what to do next

      Although database is working fine if i shutdown or start up the database no issues are face and no alerts are recorded in the alert file.

      How i came to know about this issue is that i was cloning the environment it was giving me this error and Unfortunately the DB is not in archive log mode.

       

       

      ORA-01503: CREATE CONTROLFILE failed

      ORA-01565: error in identifying file '/Oracle/UAT/db/apps_st/data/system02.dbf'

      ORA-27048: skgfifi: file header information is invalid

       

       

      My environment details are as

      DB 11G : 11.1.0.7

      APPS : 12.1.3

      OS : OEL 5.5

       

       

      Then i used this dbv to find out that these two files  are  having  issue, please help

       

       

      dbv file=/Oracle/PROD/db/apps_st/data/system02.dbf

      DBVERIFY: Release 11.1.0.7.0 - Production on Wed Feb 10 18:41:28 2016

      Copyright (c) 1982, 2007, Oracle.  All rights reserved.

      DBV-00107: Unknown header format (141) (4864)

       

      dbv file=/Oracle/PROD/db/apps_st/data/undo01.dbf

      DBVERIFY: Release 11.1.0.7.0 - Production on Wed Feb 10 18:41:36 2016

      Copyright (c) 1982, 2007, Oracle.  All rights reserved.

      DBV-00107: Unknown header format (11) (3072)

       

      This sql gave me below output

       

      select checkpoint_change#,foreign_dbid,block1_offset,name

      from v$datafile

      order by block1_offset desc

       

      checkpoint_change   foreign_dbid                block1_offset     name

      5966377798488       0                                   4294967295      /Oracle/PROD/db/apps_st/data/system02.dbf

      5966377798488      0                                    4294967295      /Oracle/PROD/db/apps_st/data/undo01.dbf

        • 1. Re: DBF file corruption -- Please help
          Ariz - Apps DBA

          Hi

          Can you post the last 50 lines from alert.log file?

           

          Regards

          Ariz

          • 2. Re: DBF file corruption -- Please help
            hassanksa

            Below are the last 50 line from the log

             

            Thanks

             

             

            Incremental checkpoint up to RBA [0x28d.390c3.0], current log tail at RBA [0x28d.3bec1.0]

            Wed Feb 10 17:06:05 2016

            Incremental checkpoint up to RBA [0x28d.4150f.0], current log tail at RBA [0x28d.429b1.0]

            Wed Feb 10 17:45:42 2016

            Incremental checkpoint up to RBA [0x28d.4dc2b.0], current log tail at RBA [0x28d.53b2d.0]

            Wed Feb 10 18:05:43 2016

            Incremental checkpoint up to RBA [0x28d.5c409.0], current log tail at RBA [0x28d.5e009.0]

            Wed Feb 10 18:25:44 2016

            Incremental checkpoint up to RBA [0x28d.63839.0], current log tail at RBA [0x28d.649f4.0]

            Wed Feb 10 18:45:45 2016

            Incremental checkpoint up to RBA [0x28d.70139.0], current log tail at RBA [0x28d.71192.0]

            Wed Feb 10 18:55:20 2016

            Starting background process CJQ0

            Wed Feb 10 18:55:20 2016

            CJQ0 started with pid=82, OS id=16544

            Wed Feb 10 19:05:45 2016

            Incremental checkpoint up to RBA [0x28d.755c6.0], current log tail at RBA [0x28d.763a9.0]

            Wed Feb 10 19:25:46 2016

            Incremental checkpoint up to RBA [0x28d.77ea5.0], current log tail at RBA [0x28d.78df4.0]

            Wed Feb 10 19:37:38 2016

            Beginning log switch checkpoint up to RBA [0x28e.2.10], SCN: 5966378131991

            Thread 1 advanced to log sequence 654 (LGWR switch)

              Current log# 2 seq# 654 mem# 0: /Oracle/PROD/db/apps_st/data/log02a.dbf

              Current log# 2 seq# 654 mem# 1: /Oracle/PROD/db/apps_st/data/log02b.dbf

            Wed Feb 10 19:37:48 2016

            Completed checkpoint up to RBA [0x28e.2.10], SCN: 5966378131991

            Wed Feb 10 19:45:33 2016

            Beginning log switch checkpoint up to RBA [0x28f.2.10], SCN: 5966378291817

            Thread 1 advanced to log sequence 655 (LGWR switch)

              Current log# 1 seq# 655 mem# 0: /Oracle/PROD/db/apps_st/data/log01a.dbf

              Current log# 1 seq# 655 mem# 1: /Oracle/PROD/db/apps_st/data/log01b.dbf

            Wed Feb 10 19:45:43 2016

            Completed checkpoint up to RBA [0x28f.2.10], SCN: 5966378291817

            Incremental checkpoint up to RBA [0x28f.4f7a.0], current log tail at RBA [0x28f.1dc7a.0]

            Wed Feb 10 20:05:48 2016

            Incremental checkpoint up to RBA [0x28f.1ca294.0], current log tail at RBA [0x28f.1ccf7e.0]

            Wed Feb 10 20:10:49 2016

            Stopping background process CJQ0

            Wed Feb 10 20:25:48 2016

            Incremental checkpoint up to RBA [0x28f.1d19f2.0], current log tail at RBA [0x28f.1d24e6.0]

            Wed Feb 10 20:34:09 2016

            Incremental checkpoint up to RBA [0x28f.1d5e59.0], current log tail at RBA [0x28f.1d7029.0]

            Wed Feb 10 21:05:50 2016

            Incremental checkpoint up to RBA [0x28f.1db6bb.0], current log tail at RBA [0x28f.1dc3dd.0]

            Wed Feb 10 21:25:51 2016

            Incremental checkpoint up to RBA [0x28f.1df51b.0], current log tail at RBA [0x28f.1dfda3.0]

            Wed Feb 10 21:45:52 2016

            Incremental checkpoint up to RBA [0x28f.1e1702.0], current log tail at RBA [0x28f.1e2272.0]

            • 3. Re: DBF file corruption -- Please help
              VishnuVinnakota

              If its a small database, you can take a backup of files in a different location just as a caution and try recreating controlfile. Use RMAN "recover database" to just recover and try open resetlogs. This will work fine for sure if you didn't have any redo log switch since the data files have been corrupted.

              • 4. Re: DBF file corruption -- Please help
                hassanksa

                The problem got solved after following the below note, thanks for every ones input

                 

                How to detect and fix a corruption in the datafile OS header/Block Zero – ORA-27047 (Doc ID 360032.1)