Re: Flashback Query/Transaction/Table in *cloned* environment

From: Kevin Jernigan <kevin.jernigan_at_oracle.com>
Date: Thu, 23 Jan 2014 16:30:39 +0900
Message-Id: <38F6345F-860C-4070-9F14-57B29871A67C_at_oracle.com>

I don't know the direct answers to your question, but I am duty bound (as Product Manager at Oracle for Flashback Data Archive (FDA) ) to suggest that maybe you enable FDA on the tables you care about the most, and then you can use Flashback Query on production or the standby to see what the data looked like at any point in time in the past going back to the time you first enabled FDA on that table.

Note that you can use FDA in 11.2.0.4+ at no additional charge, in both EE and SE, with the one exception that you can't use "optimization" (i.e. compression) on the FDA history tables without licensing Advanced Compression...

-KJ

Sent from my iPhone

> On Jan 23, 2014, at 2:10 PM, "Chitale, Hemant K" <Hemant-K.Chitale_at_sc.com> wrote:
>
> 10g and 11g environments.
>
> Let’s say that a Hot Backup of the Database runs from 9pm to 1130pm.
>
> We then, beginning at midnight, clone the database (from the backup) to another server. The clone runs till 330am. The clone is then OPENed with RESETLOGS.
>
> We realise that we need to “undo” some transactions executed in the source database at 10pm --- but the “undo” (i.e. flashback query or flashback transaction or flashback table) is to be done only in the clone.
>
> Assume that undo_retention is 3hours.
>
> Can we use flashback query/transaction/table in the cloned environment after the resetlogs ?
>
> Can we be sure that Oracle doesn’t “expire” the undo extents (as significant time has elapsed between 10pm and 330am) ?
>
> What if undo_retention is 8hours ?
>
> What if the clone to the new server was done 12 hours later (in both undo_retention 3hours and 8hours scenarios) ?
>
> Hemant K Chitale
>
> Senior Product Specialist
>
> GTO - TSD - Group Functions (Finance)
>
> Standard Chartered Bank
>
> 7 Changi Business Park Crescent
>
> Singapore 486028
>
>
> Phone : +65-6596 3127
>
> Email : Hemant-K.Chitale_at_sc.com
>
> Fonenet : 652-63127
>
>
>
>
> This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 23 2014 - 08:30:39 CET