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 vote250 views1 answer
'0000-00-00' for column '
SQL
0 vote280 views1 answer
Sqlserver now
SQL
1 vote306 views2 answers
Begin transaction in sql
SQL
8 votes286 views1 answer
Oracle add month
SQL
0 vote290 views1 answer
Find most frequent value in SQL column
SQL
0 vote280 views1 answer
Mysql autoincrement valor inicial
SQL
2 votes296 views1 answer
How to get weekday from old date in sql
SQL
0 vote291 views1 answer
Syntax for changing column size in mysql
SQL
1 vote268 views2 answers
Into sql
SQL
0 vote305 views1 answer
Mariadb date equals to current_date plus days
SQL