Does killing arch process crash the database instance?

What happen if you kill the archiver background process in oracle database? Does it kill the database or there is no impact for database? Great! Lets research

It is always good to practically test a theoritical question which are sceptical

[oracle@orcl12x ~]$ ps -ef|grep arc
oracle    3829     1  0 05:55 ?        00:00:00 ora_arc0_orcl12x
oracle    3831     1  0 05:55 ?        00:00:00 ora_arc1_orcl12x
oracle    3833     1  0 05:55 ?        00:00:00 ora_arc2_orcl12x
oracle    3835     1  0 05:55 ?        00:00:00 ora_arc3_orcl12x
oracle    3980  3361  0 05:56 pts/0    00:00:00 grep arc

I have killed all the archive process running in background.There is no archiver process running.

[oracle@orcl12x ~]$ kill -9 3829
[oracle@orcl12x ~]$ kill -9 3833
[oracle@orcl12x ~]$ kill -9 3835
[oracle@orcl12x ~]$ kill -9 3831

[oracle@orcl12x ~]$ ps -ef|grep arc
oracle    4036  3361  0 05:56 pts/0    00:00:00 grep arc

Lets check the database status

There is no impact for database on killing arch process as the process gets restart automatically once killed

[oracle@orcl12x ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 1 05:56:58 2021

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select status from v$instance;

STATUS
------------
OPEN

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