e
STATUSNAME
dataoradataCKDBco
trol01ctldataoradataCKDBco
trol02ctldataoradataCKDBco
trol03ctl输出结果应该有3条以上（包含3条）的记录，“STATUS”应该为空。状态为空表示控制文件状态正常。
32检查Oracle在线日志状态
SQLselectgroupstatustypememberfromvlogfile
GROUPSTATUSTYPE

3
ONLINE
2
ONLINE
1
ONLINE
4
ONLINE
5
ONLINE
6
ONLINE
MEMBER
dataoradataCKDBredo03logdataoradataCKDBredo02logdataoradataCKDBredo01logdataoradataCKDBredo04logdataoradataCKDBredo05logdataoradataCKDBredo06log
6rowsselected输出结果应该有3条以上（包含3条）记录，“STATUS”应该为非“INVALID”，非“DELETED”。注：“STATUS”显示为空表示正常。
33检查Oracle表空间的状态
SQLselecttablespace_
amestatusfromdba_tablespaces
fTABLESPACE_NAME
STATUS

SYSTEM
ONLINE
UNDOTBS1
ONLINE
SYSAUX
ONLINE
TEMP
ONLINE
USERS
ONLINE
SJ1
ONLINE
ADM_INDEX
ONLINE
HOME_DATA
ONLINE
HOME_INDEX
ONLINE
PHOTO_DATA
ONLINE
PHOTO_INDEX。。。。。。。
ONLINE
输出结果中STATUS应该都为ONLINE。
34检查Oracle所有数据文件状态
SQLselect
amestatusfromvdatafile
NAMEdataoradataCKDBsystem01dbfdataoradataCKDBu
dotbs01dbfdataoradataCKDBsysaux01dbfdataoradataCKDBusers01dbfdataoradataCKDBsjdbfdataoradataCKDBHOME_DATA1dbfdataoradataCKDBHOME_INDEX1dbfdataoradataCKDBPHOTO_DATA1dbfdataoradataCKDBPHOTO_INDEX1dbfdataoradataCKDBBLOG_DATA1dbfdataoradataCKDBBLOG_INDEX1dbfdataoradataCKDBAUDIO_DATA1dbfdataoradataCKDBAUDIO_INDEX1dbfdataoradataCKDBVIDEO_DATA1dbfdataoradataCKDBVIDEO_INDEX1dbfdataoradataCKDBSYS_DATA1dbfdataoradataCKDBSYS_INDEX1dbfdataoradataCKDBADM_DATA1dbfdataoradataCKDBADM_INDEX1dbfdataoradataCKDBperfstatdbf输出结果中“STATUS”应该都为“ONLINE”。或者：
STATUS
SYSTEMONLINEONLINEONLINEONLINE
ONLINEONLINEONLINEONLINEONLINEONLINEONLINEONLINEONLINEONLINEONLINEONLINEONLINEONLINEONLINE
fSQLselectfile_
amestatusfromdba_data_files
FILE_NAME
STATUS

dataoradataCKDBusers01dbf
AVAILABLE
dataoradataCKDBsysaux01dbf
AVAILABLE
dataoradataCKDBu
dotbs01dbf
AVAILABLE
dataoradataCKDBsystem01dbf
AVAILABLE
dataoradataCKDBsjdbf
AVAILABLE
dataoradataCKDBperfstatdbf
AVAILABLE
dataoradataCKDBHOME_DATA1dbf
AVAILABLE
dataoradataCKDBHOME_INDEX1dbf
AVAILABLE
dataoradataCKDBPHOTO_DATA1dbf
AVAILABLE
输出结果中“STATUS”应该都为“AVAILABLE”。
35检查无效对象
sr