This discussion is archived
1 Reply Latest reply: Apr 14, 2013 11:48 PM by MahirM.Quluzade RSS

ORA-00339: archived log does not contain any redo

923928 Newbie
Currently Being Moderated
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
    MahirM.Quluzade Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points