1 2 Previous Next 19 Replies Latest reply: Jul 2, 2014 10:45 AM by 2699156 RSS

    Checksum error in redo log

    2699156

      Hello,

      I converted an virtual machine to another hosts and after that I started the virtual machine running Oracle 10.1.0B and it's not working anymore.

      It says this errors:

      http://s7.directupload.net/images/140623/fstmpok6.png

       

      so it's an error in redo log.

       

      So now, how can I resolve this? I googled and searched this forum but I just didn't find a right solution. I hope anyone can help me, thanks.

       

      Version information:

       

       

      SQL> select * from v$version;

       

       

      BANNER

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

      Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

      PL/SQL Release 10.1.0.2.0 - Production

      CORE    10.1.0.2.0      Production

      TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

      NLSRTL Version 10.1.0.2.0 - Production

        • 1. Re: Checksum error in redo log
          Thierry H.

          Hi,

           

          Did you have a clean shutdown on your original database?

          Were the redo logs check pointed and archived or are they needed for instance recovery (instance crashed or shutdown abort)?

          Can you open your database?

           

          I would suggest to check the blog of Hemant describing how to open your database with RESETLOGS option without doing a real recovery: this will then reset and clear your redo logs.... and hopefully resolve your error.

          Hemant's Oracle DBA Blog: OPEN RESETLOGS without really doing a Recovery

           

          HTH,

          Thierry

          • 2. Re: Checksum error in redo log
            Aman....

            Exactly the same thoughts given by Thierry. Try to mimic the recovery and post results.

             

            Aman....

            • 3. Re: Checksum error in redo log
              2699156

              I had a clean shutdown on my original database.
              So I guess I wouldn't need redo logs for recovery.

              Can't open and can't connect my database.

               

              Followed the blog entry:

              SQL>  startup mount

              ORACLE-Instance hochgefahren.

               

               

              Total System Global Area  209715200 bytes

              Fixed Size                   788168 bytes

              Variable Size             116390200 bytes

              Database Buffers           92274688 bytes

              Redo Buffers                 262144 bytes

              Datenbank mit MOUNT angeschlossen.

              SQL> alter database open resetlogs;

              alter database open resetlogs

              *

              FEHLER in Zeile 1:

              ORA-01139: RESETLOGS option only valid after an incomplete database recovery

               

               

               

               

              SQL> recover database;

              ORA-00283: recovery session canceled due to errors

              ORA-00368: checksum error in redo log block

              ORA-00353: log corruption near block 18944 change 314420299 time 06/11/2014

              01:28:45

              ORA-00312: online log 3 thread 1:

              'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL10B\REDO03.LOG'

               

               

               

               

               

               

               

              SQL>  recover database until cancel;

              ORA-00279: change 314414625 generated at 06/10/2014 22:09:11 needed for thread

              1

              ORA-00289: suggestion :

              E:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL10B\ARCHIVELOG\2014_06_24\O1_MF

              _1_58252_%U_.ARC

              ORA-00280: change 314414625 for thread 1 is in sequence #58252

               

               

               

               

              Log angeben: {<RET>=suggested | filename | AUTO | CANCEL}

               

               

              ORA-00308: cannot open archived log

              'E:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\ORCL10B\ARCHIVELOG\2014_06_24\O1_M

              F_1_58252_%U_.ARC'

              ORA-27041: unable to open file

              OSD-04002: unable to open file

              O/S-Error: (OS 2) Das System kann die angegebene Datei nicht finden.

               

               

               

               

              ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

              ORA-01194: file 1 needs more recovery to be consistent

              ORA-01110: data file 1: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL10B\SYSTEM01.DBF'

               

               

              SQL> alter database open resetlogs;

              alter database open resetlogs

              *

              FEHLER in Zeile 1:

              ORA-01194: file 1 needs more recovery to be consistent

              ORA-01110: data file 1: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL10B\SYSTEM01.DBF'

              • 4. Re: Checksum error in redo log
                Hemant K Chitale

                >I converted an virtual machine to another hosts

                Exactly what and how did you do this ?

                Apparently, the log file is corrupt.  What if datafiles are also corrupt ?

                 

                Hemant K Chitale

                • 5. Re: Checksum error in redo log
                  Thierry H.

                  Hi,

                   

                  As Hemant pointed out.... what if datafiles are corrupted as well?

                  I have a feeling that you might have copied/cloned your VM and/or database having the database opened... so, not in a consistent state.

                   

                  You need to now described what you did and HOW you did your "conversion" since it seems that this is where your problem started...

                   

                  And for your reference: Re: 2. How do I ask a question on the forums?

                   

                  HTH,

                  Thierry

                  • 6. Re: Checksum error in redo log
                    2699156

                    I converted from an VMWare Server 1.x machine to an vSphere/ESXi 5.0 machine.
                    I copied the vmdk files and then converted with vmkfstools so that they are running properly on ESX. 

                    • 7. Re: Checksum error in redo log
                      Hemant K Chitale

                      You should check with VMWare Support.

                       

                      Nevertheless, you haven't confirmed if the database was properly shutdown (a "clean" shutdown) when the copy was made.

                      Hemant K Chitale

                      • 8. Re: Checksum error in redo log
                        2699156

                        I am unsure what VMWare Support should be doing? VMWare Server isn't supported anymore (that's why I was moving the VM). I don't think I can get support from them for that old product.

                         

                        The database should be shutdown properly, since I stopped the VM/Windows System properly before copying. But  thanks anyway for your thought.

                        • 9. Re: Checksum error in redo log
                          Thierry H.

                          Ah!.... maybe finally an interesting input:

                          The database should be shutdown properly, since I stopped the VM/Windows System properly before copying. But  thanks anyway for your thought.

                           

                          So... did you shutdown the database first? ... probably not!

                          Depending on your system settings, the database could have been down via a shutdown abort.... since you shutdown the machine and NOT the database independently

                           

                          So... to confirm this:

                          1- Restart your original / source environment

                          2- Crosscheck and insure the validity and integrity of your database

                          3- Shut it down properly (shutdown immediate)

                          4- And carry out the other steps to migrate your Virtual host to a version to another.

                           

                          Revert with results.

                           

                          HTH,

                          Thierry

                          • 10. Re: Checksum error in redo log
                            Hemant K Chitale

                            >I am unsure what VMWare Support should be doing?

                            Helping you identify why one or more files is/are corrupt.

                             

                            Hemant K Chitale


                            • 11. Re: Checksum error in redo log
                              2699156

                              Shame on me but I can't crosscheck or restart original/source environment. At least not directly since the source machine already got re-installed with an other system. Since the VMs did start after converting I thought everything is fine and running, the problems with Oracle DB were reported later to me, when everything was changed already.

                              I now try to get the VM working again in our second VMWare server  environment, maybe this helps. I will come back later with hopefully some results.

                              • 12. Re: Checksum error in redo log
                                Hemant K Chitale

                                You could try running Oracle's "dbv" command against each of the datafiles to check for corruption.

                                 

                                Hemant K Chitale


                                • 13. Re: Checksum error in redo log
                                  Thierry H.

                                  Sounds like you have a wider challenge !!

                                  Didn't you keep the original vmdk files? .... maybe you can restore those original files under its original environment?

                                   

                                  Good luck and hopefully some else can help you further

                                   

                                  Regards,

                                  Thierry

                                  • 14. Re: Checksum error in redo log
                                    2699156

                                    I have the original vmdk files but not the original environment but a environment very close to the original one, I will try it with this one.

                                    1 2 Previous Next