select name, dbid, log_mode from gv$database
sqlplus / as sysdba SQL> shutdown immediate
sqlplus / as sysdba SQL> alter database archivelog; SQL> alter database open;
sqlplus / as sysdba SQL> shutdown immediate
select * from gv$archive_dest; select * from v$parameter where name like 'log_archive_dest%'; select * from gv$archive_processes;
log_archive_dest_n
point to a valid and writable destination
log_archive_start
is true