Re: Validating Flashback Database

From: DA Morgan <>
Date: Tue, 24 Jun 2008 18:35:18 -0700
Message-ID: <> wrote:

>> I use flashback database frequently and often.
>> Not for Oracle patches ... but rather for application patching and
>> maintenance.
>> --
>> Daniel A. Morgan

> thanks for the feedback. Do you have a way of sanity checking that
> everything has been 'flashed back'. Are there any v$ views that
> contain a list of changed blocks for example.
> Do you enable flhasback logging or just rely on guaranteed restore
> points...?
> Matt

Nothing I am aware of will tell you what has been changed as you are rolling the database back in time. To me the question is not unlike the question ... after you use RMAN to clone your database how do you know it is a valid clone?

Trust but verify.

Wish I could get you something more substantive. So far it has not failed me.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Tue Jun 24 2008 - 20:35:18 CDT

Original text of this message