6 Replies Latest reply on Jul 18, 2014 3:18 PM by $phinx19

    check validation of a archive log using log miner

    $phinx19

      Hi

       

      Os hp Unix

      Db 11gr2

       

      I need to check if there is any sort of corruption in a archive log. Can I check the same using logminer utility and if not is there any other way to check the same.

       

      Regards

        • 1. Re: check validation of a archive log using log miner
          sb92075

          $phinx19 wrote:

           

          Hi

           

          Os hp Unix

          Db 11gr2

           

          I need to check if there is any sort of corruption in a archive log. Can I check the same using logminer utility and if not is there any other way to check the same.

           

          Regards

          $phinx19 wrote:

           

          Hi

           

          Os hp Unix

          Db 11gr2

           

          I need to check if there is any sort of corruption in a archive log. Can I check the same using logminer utility and if not is there any other way to check the same.

           

          Regards

           

           

          [oracle@localhost ~]$ dbv

           

           

          DBVERIFY: Release 11.2.0.2.0 - Production on Fri Jul 18 07:24:25 2014

           

           

          Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

           

           

          Keyword     Description                    (Default)

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

          FILE        File to Verify                 (NONE)

          START       Start Block                    (First Block of File)

          END         End Block                      (Last Block of File)

          BLOCKSIZE   Logical Block Size             (8192)

          LOGFILE     Output Log                     (NONE)

          FEEDBACK    Display Progress               (0)

          PARFILE     Parameter File                 (NONE)

          USERID      Username/Password              (NONE)

          SEGMENT_ID  Segment ID (tsn.relfile.block) (NONE)

          HIGH_SCN    Highest Block SCN To Verify    (NONE)

                      (scn_wrap.scn_base OR scn)          

          [oracle@localhost ~]$

          • 2. Re: check validation of a archive log using log miner
            $phinx19

            Thanks SB,

             

            Can you please let me know if there is any way to check the corruption using Logminer, I have went the oracle docs for Logminer but I did not find any.

            Just need to confirm the same if it is possible to validate a archive log using Log miner.

             

            Regards,

            Sphinx

            • 3. Re: check validation of a archive log using log miner
              sb92075

              why are you concerned about corruption in REDO?

              why are you fixated on LOGMINER?

              no error implies no corruption.

              What error do you see doing what operation?

              • 4. Re: check validation of a archive log using log miner
                $phinx19

                Oracle team has suggested to use logminer to detect the corruption in one of the archive log files, for this only I am fixated on Logminer.

                 

                Regards,

                Sphinx

                • 5. Re: check validation of a archive log using log miner
                  sb92075

                  post what you have done so far using DBMS_LOGMNR where you have an issue

                  • 6. Re: check validation of a archive log using log miner
                    $phinx19

                    I am able to see use the DBMS_LOGMNR package successfully  and I have also queried the v$logmnr_contents view. But from this view I am not able to see any column which says that the data is corrupt or not.

                     

                    Anyhow, I dug deep into Oracle support and found the doc Doc ID 1268590.1, which says that if you are able to query the view v$logmnr_contents then the archive log file is free of corruption.

                     

                    Thanks a lot for your time.