Java認證如何查看ControlFile中保存的內容,由於Control File是二進位文件,用普通的方法很難知道其中到底保存了什麼內容,但Oracle提供了一個SQL*PLUS命令來將Control File的內容dump到文本文件中. 方法如下: 以SYSDBA身份登入SQL*PLUS SQL> oradebug setmypid SQL> oradebug dump controlf 3 將把control file dump到USER_DUMP_DEST初始化參數指定的目錄下. 其中3為dump level. level的詳細解釋如下: 1 :only the file header 2 :just the file header, the database info record, and checkpoint progress records 3 :all record types, but just the earliest and latest records for circular reuse record types 4 :as above, but includes the 4 most recent records for circular reuse record types 5 :as above, but the number of circular reuse records included doubles with each leve