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 vote140 views1 answer
Sql select column names starting with
SQL
0 vote136 views1 answer
Run postgresql dump to csv
SQL
-2 votes137 views1 answer
Use of where in left join in mysql
SQL
22 votes142 views4 answers
Mysql reset auto increment id
SQL
0 vote156 views1 answer
Running percentage of total postgres
SQL
2 votes144 views1 answer
Mysql application.properties spring boot
SQL
0 vote136 views1 answer
C# datetime to sql server datetime
SQL
1 vote187 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote141 views1 answer
Database traccar
SQL
3 votes136 views1 answer
Mysql UPDate with enner join
SQL