1 Reply Latest reply: Apr 15, 2013 1:48 AM by Mahir M. Quluzade RSS

    ORA-00339: archived log does not contain any redo

    923928
      Hi All,

      recently we faced 'ORA-00339: archived log does not contain any redo' issue at standby side,

      after searching on Google and from Metalink (note 30866.1 and 7197445.8 ) I find out that this is the known issue for 10g and below versions, our's is 11.2.0.3,

      Error in Alert Log :
      "
      Errors in file /oracle/ora_home/diag/diag/rdbms/dwprd/DWPRD/trace/DWPRD_pr0a_48412.trc:
      ORA-00339: archived log does not contain any redo
      ORA-00334: archived log: '/redolog2/redo/redolog3a.log'
      Errors in file /oracle/ora_home/diag/diag/rdbms/dwprd/DWPRD/trace/DWPRD_pr0a_48412.trc (incident=190009):
      ORA-00600: internal error code, arguments: [kdBlkCheckError], [1], [56702], [6114], [], [], [], [], [], [], [], []
      Incident details in: /oracle/ora_home/diag/diag/rdbms/dwprd/DWPRD/incident/incdir_190009/DWPRD_pr0a_48412_i190009.trc
      Use ADRCI or Support Workbench to package the incident.
      See Note 411.1 at My Oracle Support for error and packaging details.
      Slave exiting with ORA-10562 exception
      Errors in file /oracle/ora_home/diag/diag/rdbms/dwprd/DWPRD/trace/DWPRD_pr0a_48412.trc:
      ORA-10562: Error occurred while applying redo to data block (file# 1, block# 56702)
      ORA-10564: tablespace SYSTEM
      ORA-01110: data file 1: '/oradata1/database/DATAFILES/system01.dbf'
      ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 2
      ORA-00600: internal error code, arguments: [kdBlkCheckError], [1], [56702], [6114], [], [], [], [], [], [], [], []
      Mon Apr 15 11:34:12 2013
      Dumping diagnostic data in directory=[cdmp_20130415113412], requested by (instance=1, osid=48412 (PR0A)), summary=[incident=190009].

      "


      Thanks
        • 1. Re: ORA-00339: archived log does not contain any redo
          Mahir M. Quluzade
          Hi,

          "The archived log is not the correct log.
          It is a copy of a log file that has never been used for redo generation, or was an online log being prepared to be the current log."

          "Restore the correct log file."


          Can you say, what is last changes on your database, On log files?
          Did you copies your '/redolog2/redo/redolog3a.log' log file from other ?


          Regards
          Mahir M. Quluzade