Oracle 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

10 votes268 views4 answers
Mysql if else
SQL
1 vote145 views1 answer
Find a column in all tables postgres
SQL
0 vote166 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote151 views1 answer
Select lowest values sql
SQL
0 vote146 views1 answer
Mysql update from n to 100
SQL
0 vote138 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote151 views1 answer
Empty table sqlite
SQL
1 vote125 views1 answer
Avg mysql
SQL
12 votes150 views1 answer
Docker run mysql image
SQL
0 vote139 views1 answer
Fast sql column count
SQL