Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-00338: log 3 of thread 1 is more recent than control file

995751May 9 2013 — edited May 16 2013

Hi,

I encountered error ORA-00338 while performing incomplete database recovery:

ORA-00283: recovery session canceled due to errors
ORA-00338: log 3 of thread 1 is more recent than control file
ORA-00312: online log 3 thread 1: '+DG_REDO/dbase/onlinelog/group_3.267.814820795'
Recovery Manager complete.

I performed this recovery on oracle 10g, ASM database.

1. What are possible causes behind this error ORA-00338 ?

2. This error occurs at the start of media recovery, while RMAN is applying archived logs. So does RMAN apply "online REDO" logs after applying "archived" logs required for recovery or before them ?

3. How does rman come to know that online log 3 is more recent than control file ? How can I get scn of online log & control file in my environment ?

Following are few details related to checkpoint scn/change# info. I found in my environment:
Before recovery:
view
v$datafile: 642935
v$datafile_header: 642935
v$database: 642935
v$log: 640956

After unsuccessful recovery (ORA 338 :( )
v$datafile: 640917
v$datafile_header: 640056
v$database: 640906
v$log: 640906

This post has been answered by Hemant K Chitale on May 14 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2013

Added on May 9 2013

#general-database-discussions

26 comments

26,538 views