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 vote175 views1 answer
Sql anywhere create procedure
SQL
0 vote90 views1 answer
Copy table dbeaver
SQL
0 vote169 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote194 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
14 votes227 views1 answer
How to export db from mysql
SQL
0 vote169 views1 answer
Sql server pivot rows to columns
SQL
0 vote156 views1 answer
Nosql vs sql
SQL
0 vote143 views1 answer
Insert data from stored procedure into table
SQL
0 vote150 views1 answer
Vbscript connect mssql
SQL
0 vote141 views1 answer
Convert rows to columns in sql server
SQL