WHICH PROCESS IS RESPONSIBLE TO START ARCH PROCESS ?

Check the archive log processes running on database

[oracle@exdbadm01 ~]$ ps -ef|grep arc
oracle    7655     1  0 17:27 ?        00:00:00 ora_arc0_exdbx1
oracle    7657     1  0 17:27 ?        00:00:00 ora_arc1_exdbx1
oracle    7659     1  0 17:27 ?        00:00:00 ora_arc2_exdbx1
oracle    7661     1  0 17:27 ?        00:00:00 ora_arc3_exdbx1

Kill the archiver processes

[oracle@exdbadm01 ~]$ kill -9 7655 7657 7659 7661

After kill of process , we switch the logfile if there are no DML transactions on database

kish@exdbx<>alter system switch logfile;

System altered.

LGWR is the process responsible for launching the archiver process

LGWR: Detected ARCH process failure
LGWR: Detected ARCH process failure
LGWR: Detected ARCH process failure
LGWR: Detected ARCH process failure
LGWR: STARTING ARCH PROCESSES
Fri Jun 11 17:27:12 2021
ARC0 started with pid=38, OS id=7655
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 advanced to log sequence 369 (LGWR switch)
  Current log# 2 seq# 369 mem# 0: +DATA/exdbx/onlinelog/group_2.262.1068909751
  Current log# 2 seq# 369 mem# 1: +FRA/exdbx/onlinelog/group_2.258.1068909759
ARC0: STARTING ARCH PROCESSES
Fri Jun 11 17:27:12 2021
ARC1 started with pid=39, OS id=7657
Fri Jun 11 17:27:12 2021
ARC2 started with pid=40, OS id=7659
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Fri Jun 11 17:27:12 2021
ARC3 started with pid=41, OS id=7661
ARC2: Becoming the heartbeat ARCH
Archived Log entry 528 added for thread 1 sequence 368 ID 0x226e639f dest 1:
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s