Re: activate standy without turning off primary
Date: Fri, 28 Aug 2009 09:17:22 -0400
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
Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.
Howard Latham <howard.latham_at_gmail.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 28 2009 - 08:17:22 CDT