Oracle 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

16 votes176 views1 answer
CTE statement sql server
SQL
0 vote198 views1 answer
How to locate pg_hba.conf file
SQL
0 vote182 views1 answer
How to login to mysql in homestead
SQL
0 vote165 views1 answer
Create table employees oracle
SQL
0 vote223 views2 answers
Postgres isnull
SQL
1 vote168 views1 answer
Oracle grant on all tables in schema
SQL
0 vote222 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote203 views1 answer
Get the next column of a table in mysql
SQL
2 votes169 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
38 votes182 views4 answers
Count sql
SQL