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

0 vote149 views1 answer
Sql delete dastabase
SQL
11 votes145 views2 answers
Oracle saurce code
SQL
1 vote129 views1 answer
How refresh navicat tables to see new tables
SQL
3 votes130 views1 answer
Oracle list user grants
SQL
0 vote139 views2 answers
Psql commande \gset
SQL
5 votes147 views3 answers
Bash: mysql: command not found
SQL
0 vote145 views1 answer
Plpgsql if statement
SQL
0 vote144 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote158 views1 answer
Hierarchal database table
SQL
3 votes157 views1 answer
Oracle sql commit example
SQL