Close a Database (303)

When you close a database, Oracle writes all database data and recovery data in the
SGA to the datafiles and redo log files, respectively. Next, Oracle closes all online
datafiles and redo log files. (Any offline datafiles of any offline tablespaces have been
closed already. If you subsequently reopen the database, any tablespace that was
offline and its datafiles remain offline and closed, respectively.) At this point, the
database is closed and inaccessible for normal operations. The control files remain
open after a database is closed but still mounted.

關閉資料庫
1. 關閉資料庫時，Oracle 將 SGA 內的資料庫資料及恢復資料分別寫入資料檔案和重做日誌檔案
2. 接下來 , Oracle 關閉所有聯機的資料檔案及重做日誌檔案
3. 在資料庫已經關閉但仍舊裝載時，控制檔案還是處於開啟狀態

[@more@]