Oracle query 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 vote135 views1 answer
Oracle search columns in schema
SQL
0 vote161 views1 answer
TSQL convert csv to table
SQL
5 votes139 views4 answers
Rollback to in sql
SQL
20 votes155 views3 answers
How to open postgresql in mac
SQL
0 vote146 views1 answer
Sql server user permissions and roles
SQL
0 vote146 views1 answer
Resullt all update knex mysql
SQL
1 vote131 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
23 votes160 views2 answers
Query to delete a database in mysql
SQL
2 votes128 views1 answer
Wait delay in sql server
SQL
0 vote162 views1 answer
Trigger stock phpmyadmin
SQL