2 Replies Latest reply: Feb 5, 2013 9:56 PM by Sunthar Tharmalingam RSS

    unable to open database : error , ora-03113 end of file communication

    963730
      Hi Guys ,

      I am facing a serious issue with my database

      machine Oracle Linux Tikanga 5
      database : 10.2.0.1
      Error : ora-03113

      I was trying to drop a logfile , while inserting the data ....

      I restored and tried recovering it but it recovers with message , media recover complete but doesnot allows to open the database
      gives the same error : Error : ora-03113 end of file communication

      alert_log shows
      ____________

      alter database recover if needed
      start
      Media Recovery Start
      ORA-264 signalled during: alter database recover if needed
      start
      ...
      Wed Jan 9 16:20:18 2013
      db_recovery_file_dest_size of 2048 MB is 40.79% used. This is a
      user-specified limit on the amount of space that will be used by this
      database for recovery-related files, and does not reflect the amount of
      space available in the underlying filesystem or ASM diskgroup.
      Wed Jan 9 16:22:02 2013
      alter database recover datafile list clear
      Wed Jan 9 16:22:02 2013
      Completed: alter database recover datafile list clear
      Wed Jan 9 16:22:02 2013
      alter database recover datafile list
      1 , 2 , 3 , 4 , 5
      Completed: alter database recover datafile list
      1 , 2 , 3 , 4 , 5
      Wed Jan 9 16:22:02 2013
      alter database recover if needed
      start
      Media Recovery Start
      ORA-264 signalled during: alter database recover if needed
      start
      ...
      Wed Jan 9 16:22:07 2013
      alter database open
      Wed Jan 9 16:22:07 2013
      LGWR: STARTING ARCH PROCESSES
      ARC0 started with pid=16, OS id=2049
      Wed Jan 9 16:22:07 2013
      ARC0: Archival started
      ARC1: Archival started
      LGWR: STARTING ARCH PROCESSES COMPLETE
      ARC1 started with pid=17, OS id=2051
      Wed Jan 9 16:22:07 2013
      Repairing half complete open of thread 1
      Wed Jan 9 16:22:07 2013
      Errors in file /d1/app/oracle/oradata/orcl/bdump/orcl_lgwr_1966.trc:
      ORA-00600: internal error code, arguments: [3712], [1], [1], [0], [445262], [0], [445261], []
      Wed Jan 9 16:22:08 2013
      Errors in file /d1/app/oracle/oradata/orcl/bdump/orcl_lgwr_1966.trc:
      ORA-00600: internal error code, arguments: [3712], [1], [1], [0], [445262], [0], [445261], []
      LGWR: terminating instance due to error 470
      Instance terminated by LGWR, pid = 1966

      can you please suggest on the same ..
      Thanks