[askdba] Re: Standby Database question
- From: Nisar Tareen <ntareen@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx, dba Group <dba_gurus@xxxxxxxxxxxxxxx>
- Date: Wed, 31 Aug 2005 12:17:13 -0700 (PDT)
Rick,
The following statement restores the database to normal operation:
ALTER SYSTEM UNQUIESCE;
But my general comment is that ...... every 20 seconds replication time is a
very small window, Due to the network load or any other load on any machine in
US or Tiwan you can have a que and than only the system command will work that
is to finish the replication, check the locks and increased the Replication
time.
Ask questions like,
How many transaction per second you folks are processing.
How fast the data has to be across the ocean.
Tune the Network parameters and increase or monitor the network / replication
related parameters, involved the network crew to monitor the delay on the
network / switches etc.
Nisar Tareen
Rick_Cale@xxxxxxxxxxxxxx wrote:
One of our customers has a problem
Here's the gist of it:
1. Oracle 8 on a server running in the US with the database
replicated to a server in Taiwan.
2. Synchronization takes place every 20 seconds
3. Activity on the US server caused the US database to go into a
"quiesced" state. This in turn caused the Taiwan database to go into the
same state.
4. Subsequent actions brought the US database back to a "normal" state,
but the Taiwan database refuses to come out of the quiesced state.
5. QUESTION: What actions need to be taken to get the Taiwan database
back to a "normal" state
Any help is appreciated
Rick Cale
Database Administrator
Team Health, Inc.
865-293-5425
Rick_Cale@xxxxxxxxxxxxxx
.....................................................................................
The information contained in this e-mail message may be privileged and
confidential. If the reader of this transmission is not the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If you have received
this communication in error or are not sure whether it is privileged,
please immediately notify us by return e-mail and delete or destroy any
copies, electronic, paper or otherwise, which you may have of this
communication and any attachments.
.....................................................................................
---------------------------------
Start your day with Yahoo! - make it your home page
Other related posts:
