Re: Archive Processes

sushil wrote:

> Thanks David....but i guess the real problem lies somewhere else as i
> dont think the number and size of the logs are too small.Its a banking
> system with a total of 8 redo log groups each of 500 MB.At peak load
> the time to fill a log file is hardly 2 minutes.So i intended to ask
> whether there is a hidden parameter somewhere to define the local and
> remote archive log processes so that both dont interfere with each
> other.something like
>
> _log_archive_proccess_LOCAL=2
> _log_archive_proccess_REMOTE=2
>
> The local arch process quitely archives its own logs and the remote
> arch process communicates with RFS in writing to standby.
>
> sushil
>

You have already received some good advice, so I won't repeat it, even though you keep on rejecting it.

However, I will point out an alternative. Revert to user-managed (manual) transport and application of archived redo logs. The rsync command (for gap resolution) in conjunction with one or two well-written Perl scripts (for file compression, host and directory specification, security, error handling, logging, etc) can accomplish this in an efficient, reliable way, I have used it on multiple Unix platforms and different production systems for years with no problems. I'm not claiming this is "better", merely one supported way to resolve (what you think is) your problem.

-Mark Bole Received on Thu Sep 01 2005 - 12:05:15 CDT