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

0 vote239 views1 answer
Postgres set default schema
SQL
2 votes225 views1 answer
Anonymous block plsql
SQL
-1 vote228 views5 answers
Online sql to linq generator
SQL
1 vote254 views1 answer
Insert pg result of select
SQL
0 vote223 views1 answer
Get null value in sql
SQL
0 vote209 views1 answer
What are the aggregate function in sql
SQL
1 vote281 views1 answer
Hangfire clear all jobs
SQL
2 votes225 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
11 votes244 views1 answer
Creating tables in sql with python
SQL
6 votes216 views5 answers
Get current date sql
SQL