Re: activate standy without turning off primary

From: <>
Date: Fri, 28 Aug 2009 09:17:22 -0400
Message-ID: <>

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 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.

Howard Latham <> To:
08/28/2009 09:10 AM
activate standy without turning off primary Sent by:

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

Received on Fri Aug 28 2009 - 08:17:22 CDT

Original text of this message