What is the necessary and sufficient list of dirs need to be volumed for the db instance to be fully persistent?

[catostrophe]

The container should correctly survive restarts.

What are exact locations of data files, control files, redo logs, alert logs, traces, archive logs, etc.?

[gvenzl]

Hi @catostrophe,

Thanks a lot for using these images!

All database-related files are in /opt/oracle/oradata
Archive log mode is not being used in these images.
Trace files can be found in /opt/oracle/diag

Hope this helps!

[catostrophe]

Thanks. I already use them as volumes. I also thought about adding spfile location in case I need to do ALTER SYSTEM. WDYT?

[gvenzl]

The spfile is already persisted in a subfolder called dbconfig/<ORACLE_SID>