RE: Stanby Database- Archive Transfer Problem

[Szecsy Tamas]

Title: 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-----
From: Hussain Ahmed Qadri [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Subject: Stanby Database- Archive Transfer Problem

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
[EMAIL PROTECTED]
www.shaukatkhanum.org.pk