Query archive mode

query to see if you are in ARCHIVELOG mode:
This can also be queried in Oracel SQL developer.

SQL> archive log list;
SQL> select log_mode from v$database;
+++++++++++++++++++++++++++++++++++++++++
You can also run this UNIX/Linux command 
to see if you are running in archivelog mode.  
If you are in ARCHIVELOG mode, 
you will see rows returned by this ps command:

$ ps -ef|grep -i _arc

Source: dba-oracle.com

Similar codes

1 vote187 views1 answer
Oracle sql listagg
SQL
0 vote208 views2 answers
How to login to mysql as normal user in ubuntu
SQL
8 votes197 views2 answers
Safe update mode in mysql
SQL
0 vote196 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
1 vote204 views1 answer
Drop primary key oracle
SQL
0 vote197 views2 answers
Close external port 3306 with iptables
SQL
0 vote276 views1 answer
DATEDIFF minute postgres
SQL
-1 vote187 views2 answers
Get day in sql
SQL
3 votes213 views1 answer
Oracle undo tablespace schema
SQL
26 votes201 views2 answers
Mysql workbench download
SQL