I'm running 8i on Solaris 2.8. One one of the instances I have started the archiving and notice there are three archiver processes running and only one seem to dump the archive files to the arch directory. I presume it was archiver process#1, b'cos arch_1_####.
Now my question is how do I know where the other two processes are dumping the files if they were supposed to, b'cos I haven't specified the dest 1-x in my init.ora file.
So what caused these other processes to start and how do I go about finding what is doing what and where?
Though my init.ora set up is
log_archive_start = true
log_archive_dest = /usr/local/oracle/app/oracle/admin/active/arch
log_archive_format = arch_%t_%s.arc
what caused the arc1 and arc2 to start and why arc1 is dumping the files in the arch destination instead of arc0.
It doesn't work that way. If you set arch processes to 3, it starts arch0, 1 and 2 upon startup of the db, irrespective of the # arch destinations. You can have 5 arch processes but only 1 arch destination, or have say, 1 arch process with 5 arch destinations.