Oracle archivemode

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 vote230 views1 answer
Mysql query to select the highest value
SQL
1 vote209 views1 answer
Mysql find tables with column name
SQL
0 vote216 views1 answer
Oracle execute package dblink
SQL
0 vote182 views1 answer
Console output pl sql
SQL
-1 vote206 views1 answer
Module operator in oracle sql
SQL
1 vote192 views2 answers
Sql convert datetime to year month
SQL
6 votes241 views2 answers
What is non relational database
SQL
2 votes214 views1 answer
Oracle trace file
SQL
0 vote202 views1 answer
Postgresql replace html tags from string
SQL
8 votes170 views1 answer
Oracle current date plus 1 month
SQL