Oracle控制文件control file（2）查看控制文件内容的三中方法

导读
本文介绍如何查看控制文件的内容

可以通过下面两种方法查看控制文件的内容

• 使用strings命令查看
• 使用视图v$controlfile_record_session查看
• 转储控制文件到一个文本文件，然后查看文本文件的内容

1、使用strings命令查看控制文件内容

strings <控制文件名>

[oracle@db11g ~]$ strings /u01/app/oracle/oradata/PROD11G/control01.ctl
}|{z
PROD11G
BPROD11G
BPROD11G
PROD11G
m*EE
PROD11G
m*EE7N.
m*EE
IL9E
m*EE7N.
m*EE~
m*EE
m*EE
m*EE
m*EE
m*EE
m*EEl
m*EEl
m*EEl
m*EEl
m*EEl
m*EEl
m*EE"
/u01/app/oracle/oradata/PROD11G/redo03.log
/u01/app/oracle/oradata/PROD11G/redo02.log
/u01/app/oracle/oradata/PROD11G/redo01.log
/u01/app/oracle/oradata/PROD11G/users01.dbf
/u01/app/oracle/oradata/PROD11G/undotbs01.dbf
/u01/app/oracle/oradata/PROD11G/sysaux01.dbf
/u01/app/oracle/oradata/PROD11G/system01.dbf
/u01/app/oracle/oradata/PROD11G/temp01.dbf
/u01/app/oracle/oradata/PROD11G/example01.dbf
/u01/app/oracle/oradata/PROD11G/users02.dbf
/u01/app/oracle/oradata/PROD11G/system02.dbf
/u01/app/oracle/oradata/PROD11G/sysaux02.dbf
/u01/app/oracle/oradata/PROD11G/undotbs02.dbf
/u01/app/oracle/oradata/PROD11G/lzy01.dbf
/u01/app/oracle/oradata/PROD11G/lzy02.dbf
/u01/app/oracle/oradata/PROD11G/redo03.log
/u01/app/oracle/oradata/PROD11G/redo02.log
/u01/app/oracle/oradata/PROD11G/redo01.log
/u01/app/oracle/oradata/PROD11G/users01.dbf
/u01/app/oracle/oradata/PROD11G/undotbs01.dbf
/u01/app/oracle/oradata/PROD11G/sysaux01.dbf
/u01/app/oracle/oradata/PROD11G/system01.dbf
/u01/app/oracle/oradata/PROD11G/temp01.dbf
/u01/app/oracle/oradata/PROD11G/example01.dbf
/u01/app/oracle/oradata/PROD11G/users02.dbf
/u01/app/oracle/oradata/PROD11G/system02.dbf
/u01/app/oracle/oradata/PROD11G/sysaux02.dbf
/u01/app/oracle/oradata/PROD11G/undotbs02.dbf
/u01/app/oracle/oradata/PROD11G/lzy01.dbf
/u01/app/oracle/oradata/PROD11G/lzy02.dbf
/u01/app/oracle/oradata/PROD11G/cbo01.dbf
SYSTEM
SYSAUX
UNDOTBS1
USERS
TEMP
EXAMPLE
SYSTEM
SYSAUX
UNDOTBS1
USERS
TEMP
EXAMPLE
Bg]$
B"u3
C8EC
"CnwL
;CPPY
mpUC
mpUCh
C5`f
C)bi
-E*D
/3.D
-E*D
/3.D
5D`q
bY=D
bY=D
'{ZD
'{ZD
pbbD
pbbDqQ
eDK!
        {mD
        {mD
{U}D
zU}Dt5;
DRWX
DH!{
IL9E
3E7N.
IL9E
m*EE
Bg]$
B"u3
C8EC
"CnwL
;CPPY
mpUC
mpUCh
C5`f
C)bi
-E*D
/3.D
-E*D
/3.D
5D`q
bY=D
bY=D
'{ZD
'{ZD
pbbD
pbbDqQ
eDK!
        {mD
        {mD
{U}D
zU}Dt5;
DRWX
DH!{
IL9E
3E7N.
IL9E
m*EE
m*EE~
u01/app/oracle/oradata/PROD11G/example01.dbf
/u01/app/oracle/oradata/PROD11G/example01.dbf
PROD11G
PROD11G
PROD11G
UNNAMED_INSTANCE_2
UNNAMED_INSTANCE_3
UNNAMED_INSTANCE_4
UNNAMED_INSTANCE_5
UNNAMED_INSTANCE_6
UNNAMED_INSTANCE_7
UNNAMED_INSTANCE_8
PROD11G
UNNAMED_INSTANCE_2
UNNAMED_INSTANCE_3
UNNAMED_INSTANCE_4
UNNA