Java认证如何查看ControlFile中保存的内容,由于Control File是二进制文件,用普通的方法很难知道其中到底保存了什么内容,但Oracle提供了一个SQL*PLUS命令来将Control File的内容dump到文本文件中。
6 C+ h0 R* V0 u 方法如下:
) A# ^# y, L6 W* H9 r: } 以SYSDBA身份登入SQL*PLUS" w, r! d* r5 x
SQL> oradebug setmypid) `- R+ E6 K' F
SQL> oradebug dump controlf 3" l8 _5 r4 I+ [; c1 ~7 t& d
将把control file dump到USER_DUMP_DEST初始化参数指定的目录下。
q' t, K- p$ O 其中3为dump level。$ k: j8 M& U7 L A) Y
level的详细解释如下:
8 z- k5 l7 B$ v, a. P+ H 1 :only the file header/ M+ o) Y$ X, J' c& P2 w
2 :just the file header, the database info record, and checkpoint progress records( p, c9 M8 V- s
3 :all record types, but just the earliest and latest records for circular reuse record types" t7 [8 h& {7 O3 a1 U [1 a
4 :as above, but includes the 4 most recent records for circular reuse record types2 [, I9 a6 }( W- ]" [8 q0 U7 c* D
5+ :as above, but the number of circular reuse records included doubles with each leve |