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

8 votes341 views1 answer
Oracle add month
SQL
0 vote352 views1 answer
MySQL get all previous date record
SQL
0 vote357 views1 answer
Sqlite explain plan
SQL
1 vote369 views1 answer
Mysql strict_trans_tables
SQL
0 vote374 views1 answer
Mysql wait_timeout
SQL
1 vote375 views1 answer
OstgreSQL version
SQL
0 vote357 views1 answer
Oracle sql count occurrences of value in column
SQL
1 vote395 views1 answer
Postgres left join
SQL
1 vote355 views1 answer
Mysql dump specific tables
SQL
8 votes370 views1 answer
Oracle add auto_increment column to existing table
SQL