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

18 votes136 views4 answers
Mysql current date between two dates
SQL
2 votes185 views1 answer
How to create sql database
SQL
1 vote136 views1 answer
Sql bitwise operators
SQL
6 votes153 views2 answers
Return columns from table sql
SQL
0 vote145 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote145 views1 answer
Sql update subtract value
SQL
5 votes163 views1 answer
Oracle columns in all_tables
SQL
0 vote141 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
-1 vote168 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote132 views1 answer
Sql delete where x or y or z
SQL