Oracle database architecture is a multi-tiered structure that separates logical and physical data storage, allowing for efficient data management and retrieval. It comprises key components such as the Oracle Instance, which includes memory structures and background processes, and the Oracle Database, which stores the actual data in tablespaces and data files.