10 Replies Latest reply on Aug 1, 2012 6:56 PM by damorgan

    Flash Recovery ->SYSTEM.DBF

    953121
      Hi!

      How can I repair the C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF file?

      Drumboy


      sqlplus

      SQL*Plus: Release 11.2.0.2.0 Beta on K. J˙l. 31 18:43:26 2012
      Copyright (c) 1982, 2010, Oracle. All rights reserved.
      Enter user-name: /as sysdba

      Connected to:
      Oracle Database 11g Express Edition Release 11.2.0.2.0 - Beta

      SQL> startup;
      ORACLE instance started.

      Total System Global Area 577511424 bytes
      Fixed Size 1385040 bytes
      Variable Size 369102256 bytes
      Database Buffers 201326592 bytes
      Redo Buffers 5697536 bytes
      Database mounted.
      ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


      SQL> alter database open RESETLOGS;
      alter database open RESETLOGS
      *
      ERROR at line 1:
      ORA-01113: file 1 needs media recovery
      ORA-01110: data file 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'


      SQL> recover database until cancel using backup controlfile;
      ORA-00279: change 14038427 generated at 07/31/2012 11:20:36 needed for thread 1
      ORA-00289: suggestion :
      C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\RDBMS\ARC0000000450_0773153579.0001

      ORA-00280: change 14038427 for thread 1 is in sequence #450

      Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

      SQL> select l.status, member
      *2 from v$logfile inner join v$log l using (group#);*

      STATUS MEMBER
      ---------------- ----------------------------------------
      UNUSED C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AR
      EA\XE\ONLINELOG\O1_MF_1_7KO9RW0Z_.LOG

      CURRENT C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AR
      EA\XE\ONLINELOG\O1_MF_2_7KO9RWX9_.LOG
        • 1. Re: Flash Recovery ->SYSTEM.DBF
          damorgan
          Before I give any advice please answer a couple of questions.

          1. What did you do, or what happened, that you are where you are ... give a detailed explanation.
          2. Why not drop it and just do a reinstall?
          3. Please post the relevant sections of the alert log for us to review (and if you do not know how to format a listing read the FAQ ... don't just past it into the forum).
          • 2. Re: Flash Recovery ->SYSTEM.DBF
            953121
            1. This database has worked without error for 6 months. This morning didn't start.
            2. Because there are a lot of recorsd in database
            3. [url http://www.drumboy.hu/alert.log] alert.log 
            • 3. Re: Flash Recovery ->SYSTEM.DBF
              Aman....
              950118 wrote:
              1. This database has worked without error for 6 months. This morning didn't start.
              2. Because there are a lot of recorsd in database
              3. [url http://www.drumboy.hu/alert.log] alert.log
              Nope, it doesn't make sense. You have told us the outcome of something that you have done because of some error that you had got earlier. This is the last output which you have posted. Questions for you, do you have a valid backup and is your db is in the archivelog mode? Post all the details what you have done so far.

              Aman....
              • 4. Re: Flash Recovery ->SYSTEM.DBF
                Hemant K Chitale
                Was the database in BACKUP mode at the time it crashed ?


                The alert.log shows that instance recovery has been done.

                If the database was in BACKUP mode when it crashed issue an "ALTER DATABASE END BACKUP" before you attempt to OPEN it.


                Hemant K Chitale

                PS: Why is your subjec line "Flash Recovery" ? Were you testing database flashback ?

                Edited by: Hemant K Chitale on Aug 1, 2012 2:02 PM
                • 5. Re: Flash Recovery ->SYSTEM.DBF
                  953121
                  ORACLE instance shut down.
                  SQL> startup mount;
                  ORACLE instance started.

                  Total System Global Area 577511424 bytes
                  Fixed Size 1385040 bytes
                  Variable Size 369102256 bytes
                  Database Buffers 201326592 bytes
                  Redo Buffers 5697536 bytes
                  Database mounted.
                  SQL> alter database end backup;
                  alter database end backup
                  *
                  ERROR at line 1:
                  ORA-01142: cannot end online backup - none of the files are in backup
                  • 6. Re: Flash Recovery ->SYSTEM.DBF
                    Aman....
                    And what did you before this error came to you?

                    Aman....
                    • 7. Re: Flash Recovery ->SYSTEM.DBF
                      953121
                      Dear Aman!

                      I do not have enough time so I have to reinstall an oracle (11g Express Edition)
                      and imported from a dump file (I made an export on march).
                      I don't know what happened.

                      Drumboy

                      PS:
                      It is possible to export only users.dbf file after mount before open?
                      • 8. Re: Flash Recovery ->SYSTEM.DBF
                        Aman....
                        >
                        It is possible to export only users.dbf file after mount before open?
                        Export is meant for exporting the objects of a complete tablespace. Its a logical backup not a physical backup of a single file.

                        Aman....
                        • 9. Re: Flash Recovery ->SYSTEM.DBF
                          EdStevens
                          950118 wrote:
                          Dear Aman!

                          I do not have enough time so I have to reinstall an oracle (11g Express Edition)
                          and imported from a dump file (I made an export on march).
                          I don't know what happened.

                          Drumboy

                          PS:
                          It is possible to export only users.dbf file after mount before open?
                          You don't export files, you export schemas. And you have to have an open database to do it.
                          • 10. Re: Flash Recovery ->SYSTEM.DBF
                            damorgan
                            Sorry to be blunt here but this is total nonsense.

                            When a database doesn't start you do not start a recovery process. Likely any real damage done you did in your attempt to fix the problem.

                            Go to the alert log, find the portion of the log that corresponds with your attempt to start it when it, the very first time, didn't start ... and post it.
                            I've looked at what you linked and it does not support the proposition that there are any issues you did not create.

                            Without the log portion that shows the issue it is unsafe for anyone to recommend anything to you.