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 vote159 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
1 vote154 views1 answer
How to put value in variable mysql
SQL
0 vote134 views1 answer
Postgresql alter column nullable
SQL
0 vote150 views1 answer
Sql query to find duplicate email address
SQL
0 vote149 views1 answer
Sql show founctions
SQL
0 vote134 views1 answer
Oarcale list objects
SQL
8 votes135 views2 answers
Mysql get first x characters
SQL
1 vote141 views1 answer
Oracle list constraints
SQL
1 vote165 views1 answer
Mysql view current queries
SQL
1 vote137 views1 answer
Sql server datetime vs datetime2
SQL