Operating System - HP-UX
1748022 Members
5007 Online
108757 Solutions
New Discussion юеВ

Re: Oracle Redo logs processes

 
SOLVED
Go to solution
Sanjay Verma
Super Advisor

Oracle Redo logs processes

Hi Friends,
I've noticed that my system has redo log processes running as below:

$: ps -ef | grep -i rc
oracle 27956 1 0 Jun 1 ? 5:01 ora_arc0_DB1
oracle 4688 1 0 Jul 10 ? 0:00 ora_arc1_DB1

As I understand, the processes are spawned automatically but in this case, I can see that the active time for the second process is "0.00" always. Is that a runaway process or normal to the system?
Co-operation - The biggest chain reaction
23 REPLIES 23
Steven E. Protter
Exalted Contributor
Solution

Re: Oracle Redo logs processes

These are archive log proceses.

If you have the database in archive log mode, there should be some activity.

If archive log mode is on and they are being created, there is nothing to worry about. If you let the database run long enough, you'll eventually get some cpu time.

I suspect the database is not in archive log mode.

Lets check it.

su - oracle # the user that owns the database binaries.

sqlplus internal
select * from v$database;

It indicates the mode the database is in.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
malay boy
Trusted Contributor

Re: Oracle Redo logs processes

Hi,

This is not redolog process but achiver process.

I guest you set the log_archive_max_process=2 in oracle init.ora file.

It means that oracle will start two archiver upon instance start even though you only need one(due to low activity).

And this is not a running process.

regards
mB
There are three person in my team-Me ,myself and I.
malay boy
Trusted Contributor

Re: Oracle Redo logs processes

Hi,

This is not redolog process but achiver process.

I guest you set the log_archive_max_process=2 in oracle init.ora file.

It means that oracle will start two archiver upon instance start even though you only need one(due to low activity).

And this is not a running process.

regards
mB
There are three person in my team-Me ,myself and I.
malay boy
Trusted Contributor

Re: Oracle Redo logs processes

Hi,

This is not redolog process but achiver process.

I guest you set the log_archive_max_process=2 in oracle init.ora file.

It means that oracle will start two archiver upon instance start even though you only need one(due to low activity).

And this is not a running process.

regards
mB
There are three person in my team-Me ,myself and I.
malay boy
Trusted Contributor

Re: Oracle Redo logs processes

Hi,

This is not redolog process but achiver process.

I guest you set the log_archive_max_process=2 in oracle init.ora file.

It means that oracle will start two archiver upon instance start even though you only need one(due to low activity).

And this is not a running process.

regards
mB
There are three person in my team-Me ,myself and I.
malay boy
Trusted Contributor

Re: Oracle Redo logs processes

Hi,

This is not redolog process but achiver process.

I guest you set the log_archive_max_process=2 in oracle init.ora file.

It means that oracle will start two archiver upon instance start even though you only need one(due to low activity).

And this is not a running process.

regards
mB
There are three person in my team-Me ,myself and I.
malay boy
Trusted Contributor

Re: Oracle Redo logs processes

Hi,

This is not redolog process but achiver process.

I guest you set the log_archive_max_process=2 in oracle init.ora file.

It means that oracle will start two archiver upon instance start even though you only need one(due to low activity).

And this is not a running process.

regards
mB
There are three person in my team-Me ,myself and I.
malay boy
Trusted Contributor

Re: Oracle Redo logs processes

Hi,

This is not redolog process but achiver process.

I guest you set the log_archive_max_process=2 in oracle init.ora file.

It means that oracle will start two archiver upon instance start even though you only need one(due to low activity).

And this is not a running process.

regards
mB
There are three person in my team-Me ,myself and I.
malay boy
Trusted Contributor

Re: Oracle Redo logs processes

Hi,

This is not redolog process but achiver process.

I guest you set the log_archive_max_process=2 in oracle init.ora file.

It means that oracle will start two archiver upon instance start even though you only need one(due to low activity).

And this is not a running process.

regards
mB
There are three person in my team-Me ,myself and I.