Last year I was asked to "fix" Oracle Advanced Replication between two
databases. Apparently, the application in question had been coded with
a FAILOVER button that users could press when they wished to enter
"failover mode", presumably when they perceived some kind of system
problem. What happened then is that the application reconnected from
database A to database B, or from B->A. The complaint was that
Oracle Advanced Replication was not propagating fast enough between
A->B and B->A, so that when the users hit the FAILOVER button,
they found that it took time for many of the transactions to show up in
the failed-over database.
I asked, "How often do users press the FAILOVER button?", and was told
that it was "several times per week", which was *very* interesting, as
both databases A and B had been up, open, and operational continuously
for the past year. No downtime at all. There had not been any outage
or loss of service on the databases, but the users were still pressing
the FAILOVER button several times a week, failing back and forth
between the two databases. I then had a conversation with the
developer about the FAILOVER button which felt eerily like the
conversation between Marty DiBergi (Rob Reiner) and Nigel Tufnel
(Christopher Guest) in the 1984 movie "This Is Spinal Tap", as they
were discussing the band's specially-modified amplifiers...
Nigel
Tufnel:
The numbers all go to eleven. Look, right across the board, eleven,
eleven, eleven and...
Marty DiBergi:
Oh, I see. And most amplifiers go up to ten?
Nigel Tufnel:
Exactly.
Marty DiBergi:
Does that mean it's louder? Is it any louder?
Nigel Tufnel:
Well, it's one louder, isn't it? It's not ten. You see, most blokes,
you know, will be playing at ten. You're on ten here, all the way up,
all the way up, all the way up, you're on ten on your guitar. Where
can
you go from there? Where?
Marty DiBergi:
I don't know.
Nigel Tufnel:
Nowhere. Exactly. What we do is, if we need that extra push over the
cliff, you know what we do?
Marty DiBergi:
Put it up to eleven.
Nigel Tufnel:
Eleven. Exactly. One louder.
Marty DiBergi:
Why don't you just make ten louder and make ten be the top number and
make that a little louder?
Nigel Tufnel:
[long pause] These go to eleven.
Sometimes, it's all about what makes people feel empowered...
Tim Gorman
consultant -> Evergreen Database Technologies, Inc.
postal => P.O. Box 630791, Highlands Ranch CO 80163-0791
website => http://www.EvDBT.com/
email => Tim@xxxxxxxxx
mobile => +1-303-885-4526
fax => +1-303-484-3608
Lost Data? => http://www.ora600.be/ for DUDE recovery tool
Christopher Boyle wrote:
Just
curious, about how much $$ per hour did Xxxx charge for recreating
the wheel?
All,
I'm going
to start a new thread away from the
Undo tablespace link because, well this is just dumb & I'm
wondering how
many others have heard similar things. BTW I've changed names to
protect
the guilty.
Hello
all,
we had a meeting with Xxxx today about commit and rollback operation.
Xxxx advices us to not use the default Oracle commit/rollback, but to
use
instead these two procedures :
- FWD_LID.TRANSACTION_COMMIT
- FWD_LIB.TRANSACION_ROLLBACK
Goals
of this procedure is to store in TRANSACTION_LOG table records about
transaction
performed.
These
records will be used when synchronisation will be performed between XXX
online
and XXX offline. It enables mechanism used to manage the
synchronisation to
prevent lost of data on long running synchronisation.
So,
now, each time a script that modified data must be executed, we must
too use
these two procedures to commit or rollback.
Feel
free to forward to other people that deals with transaction somewhere
in
development/database administration/...
Dick Goulet
Senior
Oracle
DBA/NA Team Lead
PAREXEL
International
900
Chelmsford
St, Suite 310
Lowell,
MA
01821
978.614.2857
Richard.Goulet@xxxxxxxxxxx
The information transmitted in this communication is intended
only for
the person or entity to which it is addressed and may contain
confidential
and/or privileged material. Any review, retransmission, dissemination
or other
use of, or taking of any action in reliance upon, this information by
persons
or entities other than the intended recipient is prohibited. If you
received
this in error, please destroy any copies, contact the sender and delete
the
material from any computer.
--
//www.freelists.org/webpage/oracle-l
|
