Re: Resend : Flashback Query/Transaction/Table in *cloned* environment
- From: Don Seiler <don@xxxxxxxxx>
- To: Hemant-K.Chitale@xxxxxx
- Date: Wed, 29 Jan 2014 14:51:38 -0600
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@xxxxxx>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
Other related posts:
