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 vote198 views1 answer
Oracle job schedules
SQL
-1 vote198 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote226 views1 answer
Ansi sql count duplicate rows
SQL
3 votes191 views2 answers
Oracle sql drop sequence
SQL
53 votes323 views6 answers
Sql server alter column
SQL
7 votes215 views1 answer
Oracle pagination query rownum
SQL
0 vote206 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote224 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote207 views1 answer
How to check xampp mysql password
SQL
0 vote217 views1 answer
Postgres regex word boundary
SQL