問題文
A DBA who has only administered single-instance databases is reviewing the file layout of a new two-node Oracle RAC database. She wants to know which structures exist once per instance instead of once for the whole database, and where those files have to live. Which statement describes the layout correctly?
選択肢
- Each instance keeps its own copy of the control file and its own server parameter file, and every file that belongs to those structures sits on the shared storage that all of the instances can read from.
- Each instance writes to its own thread of online redo log groups and uses its own undo tablespace, and every file that belongs to those structures sits on the shared storage that all of the instances of the cluster can read.
- Each instance writes to its own thread of online redo log groups and uses its own undo tablespace, and every file that belongs to those structures sits on a local disk that belongs to that one node.
- Every instance shares a single thread of online redo log groups and a single undo tablespace, and every file that belongs to those structures sits on the shared storage that all of the instances of the cluster can read.