Determining change and sequence for incomplete recovery
- From: Vladimir Barac <vbarac@xxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Mar 2010 23:19:46 +0300
Hi
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?
Regards,
Vladimir Barac
Other related posts:
