Re: Validating Flashback Database
From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 24 Jun 2008 18:35:18 -0700
Message-ID: <1214357709.810520@bubbleator.drizzle.com>
>
> 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
Date: Tue, 24 Jun 2008 18:35:18 -0700
Message-ID: <1214357709.810520@bubbleator.drizzle.com>
mccmx_at_hotmail.com 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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Jun 24 2008 - 20:35:18 CDT