Re: Trigger on redo log switch?

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 16 Mar 2008 11:29:04 -0700
Message-ID: <1205692143.545469@bubbleator.drizzle.com>


Ana C. Dent wrote:
> "fitzjarrell_at_cox.net" <fitzjarrell_at_cox.net> wrote in
> news:19af45f7-a98e-4905-93ff-aceea05e7da1_at_8g2000hsu.googlegroups.com:
>

>> On Mar 15, 2:15 pm, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
>>> Oracle 10GR2 -
>>>
>>> How can I get custom PL/SQL to be invoked upon every redo logfile
>>> switch? 
>> Why?
>>
>>
>> David Fitzjarrell

>
> So a manual Data Guard like implementation can be achieved
> & I'd prefer to avoid the overhead of polling.

I agree with Sybrand. It will cost you more to achieve the functionality of Data Guard than just buying it, prepackaged and fully supported, from Oracle.

There is far more to Data Guard than just shipping log files.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Mar 16 2008 - 13:29:04 CDT

Original text of this message