Oracle query archivemode

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

23 votes300 views4 answers
Uninstall postgresql ubuntu
SQL
3 votes266 views1 answer
Oracle user quota on tablespace
SQL
4 votes292 views6 answers
Sql select statement
SQL
0 vote324 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote281 views1 answer
Where name ends in SQL
SQL
2 votes312 views1 answer
Oracle Column Names of a table
SQL
-1 vote259 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote287 views1 answer
Flexible search query delete table
SQL
1 vote278 views1 answer
Delete specific row in sql
SQL
0 vote278 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL