Determining change and sequence for incomplete recovery
Date: Thu, 18 Mar 2010 23:19:46 +0300
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?