Re: Flashback on physical standby database in Oracle 11g

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 11 Mar 2008 09:14:22 -0700
Message-ID: <1205252063.49702@bubbleator.drizzle.com>


jackzhunj_at_gmail.com wrote:
> Hi,
>
> Here is our testing setup:
>
> Oracle 11g physical standby database with flashback is enabled on both
> primary and standby site.
>
> 1. Cut off the 'connection' between primary and standby site.
> 2. Convert standby to primary
> 3. Do all the testing (read and write) on the new primary (old
> standby)
>
> After the testing is done, can we flashback the new primary back to
> original standby status?
>
> Thanks a lot!

Yes.
http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/concepts.htm#SBYDB00010

-- 
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.org
Received on Tue Mar 11 2008 - 11:14:22 CDT

Original text of this message