RMAN error in incomplete recovery - ORA-00312, ORA-00314
995751May 7 2013 — edited May 9 2013Hi,
I had earlier performed complete recovery of oracle 10g R2 ASM database.
After that I want to recover my database to an earlier point.
So I performed point in time(incomplete) recovery using RMAN. commands.
But incomplete recovery failed with this error:
ORA-00314: log 2 of thread 1, expected sequence# 9 doesn't match 12
ORA-00312: online log 2 thread 1: '+ORACLEDB_CTRL/oracledb/onlinelog/group_2.257.813936363'
My doubts
1. Can I recover my database to earlier point (incomplete recovery) after performing complete recovery ? Are there any limitations ?
2. From the error message, RMAN is trying to apply archive logs during recovery. What is meaning of 'ORA-00312: online log 2 thread 1', why is RMAN looking for online redo logs ? My understanding is that it should only apply the archive logs.