Re: activate standy without turning off primary

From: Howard Latham <howard.latham_at_gmail.com>
Date: Fri, 28 Aug 2009 14:19:04 +0100
Message-ID: <713d96d10908280619l51d65057p6b1dc8968e45fca3_at_mail.gmail.com>

Yes we have a licence - are you saying just connect to the standby and do ALTER DATABASE OPEN READ WRITE? 2009/8/28 <TESTAJ3_at_nationwide.com>

>
> If you pay for the license, Oracle Active Data Guard, you can have the
> changes applied while open read only.
>
> If you want to be able to write to it for testing and then erasing all of
> the changes, enable flashback on primary and standby, open for read-write,
> change all you want and flash it back to make it a standby again.
>
> I just did those 2 things in a presentation for my office.
>
> joe
>
> _______________________________________
> Joe Testa, Oracle Certified Professional
> Systems Engineering & Administration Lead
> (Work) 614-677-1668
> (Cell) 614-312-6715
>
> Interested in helping out your marriage?
> Ask me about "Weekend to Remember"
> Dec 11-13, 2009 here in Columbus.
>
>
>
> From: Howard Latham <howard.latham_at_gmail.com> To: ORACLE-L <
> oracle-l_at_freelists.org> Date: 08/28/2009 09:10 AM Subject: activate standy
> without turning off primary Sent by: oracle-l-bounce_at_freelists.org
> ------------------------------
>
>
>
> Oracle 11g Redhat Linux 64Bit
>
> I've got a lot on otherwise I would trawl the manuals
>
> How do I Activate a standby ?- for test purposes without affecting the
> primary - so I get twow orking dbs on different boxes
>
> --
> Howard A. Latham
>
>
>
>

-- 
Howard A. Latham

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

Received on Fri Aug 28 2009 - 08:19:04 CDT