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

-1 vote185 views1 answer
Window functions in sql
SQL
0 vote196 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote228 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote198 views1 answer
Oracle procedure teamplate
SQL
0 vote181 views1 answer
Mysql select last 15 minutes
SQL
0 vote184 views1 answer
Sql character index
SQL
3 votes183 views4 answers
Mysql delete duplicate rows
SQL
3 votes200 views2 answers
Host is not allowed to connect to this mysql server
SQL
1 vote189 views1 answer
Sample clause in sql
SQL
0 vote187 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL