RE: Determining the "fuzziness" of a datafile
- From: "Wittenmyer Joel - CO" <WITTENMYERJ@xxxxxxxx>
- To: <Adam.Donahue@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 14 Dec 2006 13:43:55 -0600
Is there an easy way to determine exactly the "fuzziness" of a datafile
....
Dump the datafile header and look at the status. Fuzzy statuses are:
0x01 hotbackup in progress on file
0x04 online fuzzy - it was online and the db was open
0x10 media recovery fuzzy - file is in media recovery
0x40 absolutely fuzzy - fuzzyness from file scan
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Donahue, Adam
Sent: Thursday, December 14, 2006 11:03 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Determining the "fuzziness" of a datafile
Folks,
Is there an easy way to determine exactly the "fuzziness" of a datafile
that's been restored from an RMAN back up as part of a clone operation
(meaning with a backup controlfile), without having to look at the
backup catalog itself?
That is, as far as I can tell, when a backup at time 0 is started and
completes at time 100, the blocks of the files backed up in that period
could reflect anything from 0 to 100 depending on when they were read.
And of course we need to redo containing those changes. But v$datafile
(and v$datafile_header), as well as v$database, don't give an indication
of exactly how much redo is needed to bring the database back to a
consistent state. Is there a way to say "What's your max (or min) SCN?"
or is this a lower-level operation that would require tracing. I figure
it must be somewhere - but I didn't see the SCN noted anywhere upon a
cursory glance.
Adam
________________________________
This message may contain confidential, proprietary, or legally
privileged information. No confidentiality or privilege is waived by any
transmission to an unintended recipient. If you are not an intended
recipient, please notify the sender and delete this message immediately.
Any views expressed in this message are those of the sender, not those
of any entity within the KBC Financial Products group of companies
(together referred to as "KBC FP").
This message does not create any obligation, contractual or otherwise,
on the part of KBC FP. It is not an offer (or solicitation of an offer)
of, or a recommendation to buy or sell, any financial product. Any
prices or other values included in this message are indicative only, and
do not necessarily represent current market prices, prices at which KBC
FP would enter into a transaction, or prices at which similar
transactions may be carried on KBC FP's own books. The information
contained in this message is provided "as is", without representations
or warranties, express or implied, of any kind. Past performance is not
indicative of future returns.
Other related posts:
