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

2 votes134 views1 answer
Sql select in list
SQL
0 vote208 views1 answer
Setval postgres example table id
SQL
11 votes185 views1 answer
Oracle view ddl
SQL
14 votes1.2K views1 answer
Sql value of string
SQL
0 vote195 views1 answer
Oracle search in date columns
SQL
0 vote203 views1 answer
Ver usuarios mysql
SQL
16 votes196 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote229 views1 answer
Check command
SQL
1 vote199 views1 answer
Sqlite3 read only
SQL
1 vote212 views1 answer
Oracle activate job
SQL