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

-1 vote248 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
1 vote180 views1 answer
Sql Split string function
SQL
0 vote232 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote197 views1 answer
Selecting duplicates
SQL
3 votes204 views6 answers
DB::table('users')->get();
SQL
1 vote155 views1 answer
Import in mysql without a software
SQL
2 votes191 views2 answers
Get all tables using like
SQL
0 vote194 views1 answer
Convert sql server guid to varbinary
SQL
150 votes540 views10 answers
Grepper
SQL
1 vote203 views1 answer
Alter constraint in sql
SQL