Re: activate standy without turning off primary
- From: steve montgomerie <stmontgo@xxxxxxxxx>
- To: howard.latham@xxxxxxxxx
- Date: Sat, 29 Aug 2009 23:00:58 -0400
enjoy.......
Subject: How To Open Physical Standby For Read Write Testing and Flashback
Doc ID: 805438.1 Type: HOWTO
Modified Date: 13-APR-2009
steve
On Fri, Aug 28, 2009 at 9:19 AM, Howard Latham <howard.latham@xxxxxxxxx>wrote:
> 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:
