Oracle DBA

Architecture & Internals for Administrators

Question

Instance versus database: what persists across an instance restart?

Answer

An instance is memory structures and background processes, so it ends at shutdown. A database is physical files containing persistent data and metadata. Diagnose startup separately from file recovery; use database files for durability.

This is 1 of 23 free samples for Oracle DBA.

More Oracle DBA topic samples