Re: Trigger on redo log switch?

On Mar 15, 6:40 pm, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote innews: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'd still ask why PL/SQL. If you are doing things outside of Oracle, and want to avoid polling, what are you really planning to do? Remember, it is going to take time to copy the logs, so you are going to have to figure out if you've copied an entire log before you apply it. (I've been doing this a long time in versions up to 9, I simply rely on the tendency of rcp and uncompress to allow no read on the files in progress, but it is a very manually intensive process at times. Read that as "expensive." It made sense in previous versions with nasty blowback bugs and no compression for going over an insufficient network, but does not for 10g, and you need a sufficient network).

jg

--
@home.com is bogus.
Hmmm, maybe SDGE isn't lying about the need for the new transmission
lines:  http://spectrum.ieee.org/feb08/5943