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
