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

From: Don Seiler <don_at_seiler.us>
Date: Wed, 29 Jan 2014 14:51:38 -0600
Message-ID: <CAHJZqBAsQ6cs86tbHXUu_dWCM8_RHBd2VfK44Y1g6L7AiPL0tA_at_mail.gmail.com>



Interesting question. Should be easy enough to test with a dummy DB. I'll try it out tonight if I get time.

Don.

On Wed, Jan 29, 2014 at 2:24 AM, 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
>
>
>
> 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
> .
>

-- 
Don Seiler
http://www.seiler.us

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 29 2014 - 21:51:38 CET

Original text of this message