Search notes:

Oracle database: archiving mode

archive log mode, or
noarchive log mode.

The current mode can be determined with

select
   name,
   dbid,
   log_mode
from
   gv$database

Put database into archivelog mode

sqlplus / as sysdba
SQL> shutdown immediate

Make a development/databases/Oracle/adminstration/backup-recovery/backup[backup].

sqlplus / as sysdba
SQL> alter database archivelog;
SQL> alter database open;

Change initialization parameters log_archive_dest_n.

sqlplus / as sysdba
SQL> shutdown immediate

Make another development/databases/Oracle/adminstration/backup-recovery/backup[backup].

Queries

select * from gv$archive_dest;
select * from v$parameter where name like 'log_archive_dest%';
select * from gv$archive_processes;

ORA-00257 Archiver error. Connect AS SYSDBA only until resolved

Solution: make sure that

log_archive_dest_n point to a valid and writable destination
Make sure that log_archive_start is true

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758198865, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/architecture/database/archiving-mode/index(78): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78