In our Production Server Database we have 6 redologfiles we had set the log_archive_max_processes=1 ,because of that the archive process get queed to the standby and the sytem is hanged .so often we need to restart the whole database.
Is it advice to change the log_archive_max_processes= 2 0r 3 (since we are having 6 redo log files)
Please let me know your suggestions and feedback.
Thanks in Advance.
How many redo log groups do you have and are those groups properly sized?
Try adding one or two log groups so that archiver gets enough time to backup the log groups.
If you still have problem you can increase the log_archive_max_processes
Click Here to Expand Forum to Full Width