DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Urgent- archive

  1. #1
    Join Date
    Nov 2000
    I temporarily stop automatic archiving in the morning while I backup the archivelogs. When I look at OEM often (and even now (my job has finished a long time ago and automatic archiving is back on), I find that there are many archiver (background processes). Can I kill them?

    Why are they still running? I checked my autmatic archiving is still on. Also someone is doing an update which is not so big, I feel this might be slowing the system down, but am concerned as to what to do.

    Please help,

  2. #2
    Join Date
    Apr 2000
    Edison, NJ
    Have you setup multiple arch processes, master or slave?? or are you using the parameter dbwr_io_slaves??

  3. #3
    Join Date
    Nov 2000
    I fixed it (well for now).

    To answer your question, not I do not have any of them set (slaves 0, archive process 1). I found a note in a forum that said that this was some sort of bug in Oracle. Though the person in the forum said 8.1.5., time was critical (and the fix looked harmless), so I did it and it is fine now.

    For anyone who is interested the fix is:

    alter system set log_archive_max_processes=10; (or some number higher than the number of processes running)

    alter system archive log stop;
    ===>> this kills the ARCH processes

    alter system set log_archive_max_processes=1;

    alter system archive log start;
    ===>> this will start back only one

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.