Determining change and sequence for incomplete recovery
From: Vladimir Barac <vbarac_at_Alghanim.com>
Date: Thu, 18 Mar 2010 23:19:46 +0300
Message-ID: <C85D70C785B07043A485C8AE85E8F67119F2C95C6C_at_ALGMB.Alghanim.com>
Hi
Date: Thu, 18 Mar 2010 23:19:46 +0300
Message-ID: <C85D70C785B07043A485C8AE85E8F67119F2C95C6C_at_ALGMB.Alghanim.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 18 2010 - 15:19:46 CDT