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 vote268 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote261 views1 answer
How to select even id in sql
SQL
0 vote242 views1 answer
Postgresql get current user name
SQL
0 vote254 views1 answer
Oracle flush Shared Pool
SQL
1 vote265 views1 answer
Mysql tables max count
SQL
0 vote278 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
4 votes241 views2 answers
How to count items with same name in sql
SQL
6 votes268 views6 answers
Count mysql
SQL
11 votes276 views2 answers
Insert date sql
SQL
0 vote272 views1 answer
Report in database
SQL