Oracle query 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

2 votes191 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote180 views1 answer
Order by ip address sql
SQL
0 vote194 views4 answers
Mysql desactivar trigger
SQL
1 vote191 views1 answer
What is a Database?
SQL
0 vote183 views1 answer
Query archive mode
SQL
4 votes144 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote175 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
2 votes172 views1 answer
Insert from table tsql
SQL
8 votes217 views4 answers
Reset SQL auto increment
SQL
4 votes173 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL