Oracle Proces Archive logs

[Filosofo]

Hello,
I' have another questio about oracle this time.
In ours db script we monitori ora_arcX_DB oracle proces.
This proces is always up, or there iare some time where the processes are stop?

Thanks for all your helps.

Filo

[Steven E. Protter]

Hello Filo,

I've taken a look at my servers which run 8.1.7.4.0 or oracle, 64 bit HP-UX 11.11

Those processes are always up, but sleeping. They wake up when logs are being cut.

Hope this answers your question.

SEP

[Duncan Edmonstone]

SEPs right, these processes are always up, on an automatically archived database.

HOWEVER if log archiving isn't automatic, the arcX process won't be present. SO on a database which isn't in archive log mode, or one where the archive logging is done manually (such as through cron), there won't be an arcX process.

You can test this by doing the following (NOT on a production database!):

$ sqlplus "/ as sysdba"

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Sep 15 15:18:18 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

SQL> !ps -ef | grep [o]ra_arc
oracle 6994 1 0 15:16:12 ? 0:00 ora_arc0_openview

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /all/oracle/admin/openview/arch
Oldest online log sequence 705
Next log sequence to archive 707
Current log sequence 707
SQL> alter system archive log stop;

System altered.

SQL> !ps -ef | grep [o]ra_arc

SQL> archive log list
Database log mode Archive Mode
Automatic archival Disabled
Archive destination /all/oracle/admin/openview/arch
Oldest online log sequence 705
Next log sequence to archive 707
Current log sequence 707
SQL> alter system archive log start;

System altered.

SQL> !ps -ef | grep [o]ra_arc
oracle 7144 1 0 15:19:37 ? 0:00 ora_arc0_openview


HTH

Duncan