Determining change and sequence for incomplete recovery

From: Vladimir Barac <>
Date: Thu, 18 Mar 2010 23:19:46 +0300
Message-ID: <>


This is maybe a beginner's question, however - I never actually thought about it previously.

So, when we start "recover database using backup controlfile until cancel" Oracle will provide suggestion:

ORA-00289: suggestion: <some file name here> ORA-00280: change XYZ for thread 1 is in sequence #ABC

How does Oracle actually know that change XYZ is in particular sequence? If we have controlfile created from trace, where else we have this pair (change, sequence) stored?

Vladimir Barac

Received on Thu Mar 18 2010 - 15:19:46 CDT

Original text of this message