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

8 votes205 views2 answers
Update sql server from another table
SQL
13 votes223 views2 answers
Oracle inner join
SQL
10 votes275 views1 answer
Oracle all_dependencies
SQL
8 votes191 views1 answer
Oracle find text in functions
SQL
0 vote200 views1 answer
Drop all triggers oracle
SQL
0 vote214 views1 answer
Mysql begin statement
SQL
21 votes199 views6 answers
Docker run mysql
SQL
16 votes217 views5 answers
Select last row in sql
SQL
2 votes157 views4 answers
Mysql change database character set to utf8mb4
SQL
1 vote201 views1 answer
Add constraint sql
SQL