Re: activate standy without turning off primary
- From: Howard Latham <howard.latham@xxxxxxxxx>
- To: TESTAJ3@xxxxxxxxxxxxxx
- Date: Fri, 28 Aug 2009 14:19:04 +0100
Yes we have a licence - are you saying just connect to the standby and do
ALTER DATABASE OPEN READ WRITE?
2009/8/28 <TESTAJ3@xxxxxxxxxxxxxx>
>
> 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@xxxxxxxxx> To: ORACLE-L <
> oracle-l@xxxxxxxxxxxxx> Date: 08/28/2009 09:10 AM Subject: activate standy
> without turning off primary Sent by: oracle-l-bounce@xxxxxxxxxxxxx
> ------------------------------
>
>
>
> 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
Other related posts:
