Re: activate standy without turning off primary

From: steve montgomerie <stmontgo_at_gmail.com>
Date: Sat, 29 Aug 2009 23:00:58 -0400
Message-ID: <5d4504220908292000h67cb1ba2o1bd740fa293bca9d_at_mail.gmail.com>

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_at_gmail.com>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_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 Sat Aug 29 2009 - 22:00:58 CDT