2 Replies Latest reply: Oct 31, 2012 5:06 AM by 971613 RSS

    Got ORA-604/ ORA-16211 / ORA-26808  when trying to perform sql apply

    971613
      Dears,

      I am testing a rolling upgrade from 11.2.0.1 to 11.2.0.3, but when finished the logical standby database and started to sql apply, errors occured as below:


      LOGMINER: Begin mining logfile for session 1 thread 1 sequence 170612, +DGROUP1/proddb03/onlinelog/group_10.264.797334085
      Wed Oct 31 12:22:38 2012
      LOGSTDBY: SQL Apply about to stop with ORA-604
      LOGSTDBY: SQL Apply finished logging error information
      LOGSTDBY: SQL Apply about to stop with ORA-16211
      LOGSTDBY: SQL Apply finished logging error information
      LOGSTDBY Apply process AS05 server id=5 pid=113 OS id=20244 stopped
      Wed Oct 31 12:22:40 2012
      Errors in file /oracle/app/oracle/diag/rdbms/proddb03/core01/trace/core01_lsp0_19667.trc:
      ORA-26808: Apply process AS05 died unexpectedly.
      ORA-16211: unsupported record found in the archived redo log
      Errors in file /oracle/app/oracle/diag/rdbms/proddb03/core01/trace/core01_as05_20244.trc:
      ORA-16211: unsupported record found in the archived redo log


      It's very strange , I checked the db for relavent table definition ,but couldn't find any thing special for the prerequisite of DG .

      PS:

      SQL> select * from v$version;

      BANNER
      --------------------------------------------------------------------------------
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      PL/SQL Release 11.2.0.1.0 - Production
      CORE 11.2.0.1.0 Production
      TNS for Linux: Version 11.2.0.1.0 - Production
      NLSRTL Version 11.2.0.1.0 - Production