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 vote146 views1 answer
Minecraft duping allowed servers
SQL
8 votes175 views2 answers
How to fetch data from database without last column
SQL
0 vote162 views2 answers
How to display enum value sql server
SQL
1 vote153 views1 answer
Delete row mssql
SQL
2 votes150 views1 answer
Postgresql update sequence next value
SQL
6 votes190 views1 answer
How to get the size of the database in postgresql
SQL
0 vote162 views1 answer
Mysql random number between 1 and 100
SQL
4 votes163 views1 answer
Mysql ip address data type
SQL
7 votes157 views1 answer
Oracle pagination query offset
SQL
0 vote169 views3 answers
Sql drop all tables
SQL