| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Stanby Database- Archive Transfer Problem
If you find a solution for this, I would be interested in it. We have the
same problem, same platform. Somatimes SAP starts some kind of processing
and the network load increases enormously. And the archive log transfer
fails after a while.
Tamas Szecsy
-----Original Message-----
Sent: Thursday, April 04, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.7 and WINNT4
Our Standby database was running smoothly but due to some reasons we had to
reconfigure it.
We have used the same init parameter file which we used earlier(to have the
exact parameters). The standby database was configured alright but this time
logs are not properly getting transfered to the standby database, I mean
every 3rd or 4th archived log file doesn;t get transfered and is missed.
Our 4 redo logs are 1mb and block size is 8192, Log_checkpoint_interval = 10000 (the default) and log_checkpoit_timeout = 600
Archive processes are 10(this we had increased to 5 the last time to counter the missin files on our standby database,and it worked fine,but this time we have increased from 5 to 10 and its not) and the view v$Archive_dest shows that both primary and standby database locations are valid.
Average time for log switch, under normal conditions, is roughly 12-15 mins, but for some reasons it starts getting missed after a regular transfer of 3-4 archive files.
Our network is 10Mbps and is sllow off and on.
What could be the reason for the delay.
Hussain Ahmed Qadri
Database Administrator
Shaukat Khanum Memorial Cancer Hospital & Research Centre
hussain_at_skm.org.pk
www.shaukatkhanum.org.pk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Szecsy Tamas
INET: tszecsy_at_GEOMETRIA.hu
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 04 2002 - 03:03:22 CST
 |
 |