log_archive_max_process parameter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: log_archive_max_process parameter

  1. #1
    Join Date
    Sep 2002
    Posts
    6
    Hi,

    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.

    Regards,
    Rangarajan.R

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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

    HTH
    Sanjay

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width