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