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

0 vote339 views1 answer
Gcloud sql list databases
SQL
0 vote302 views1 answer
Truncate a table then insert data
SQL
0 vote318 views1 answer
Sql delimiter to columns
SQL
0 vote320 views2 answers
How to take recent row without limit in mysql
SQL
0 vote287 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote329 views1 answer
Mysql random number between 1 and 100
SQL
2 votes328 views2 answers
Get all tables using like
SQL
19 votes311 views4 answers
Rename database in sql
SQL
3 votes300 views1 answer
Sql server check version
SQL
6 votes345 views3 answers
Psql show columns of table
SQL