On 16 mar, 02:40, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:
Not that I really like the overall idea, but if you want to limit the
polling overhead inside Oracle, you might want to code a system script
that would check the switch events by reading the alert.log (sort of
tail -f | grep). The overhead would be limited.

Ana C. Dent wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Ana C. Dent wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Ana C. Dent wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Ana C. Dent wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Mar 15, 6:40*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:
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

On Mar 15, 6:40*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:
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

On Mar 15, 6:40*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:
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

On Mar 15, 6:40*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:
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