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

1 vote215 views1 answer
Media sql
SQL
0 vote231 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
2 votes220 views2 answers
Change varchar length mysql
SQL
0 vote250 views3 answers
Select top 10 rows in sql
SQL
0 vote213 views1 answer
Mssql check if date is greater than today
SQL
3 votes226 views1 answer
Define REGEXP?
SQL
0 vote210 views1 answer
Uncomment listen_address=localhost
SQL
10 votes226 views2 answers
Oracle alter sequence nextval
SQL
6 votes211 views2 answers
Sql display max value
SQL
27 votes226 views3 answers
Mysql show tables in database
SQL