日志中错误如下:
GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j001_6996.trc:
ORA-20011: Approximate NDV failed: ORA-01115: IO error reading block from file (block # )
ORA-01110: data file 5: 'D:\TABLESPACE\USERS\RUIYUAN_D01.DBF'
ORA-27070: async read/write failed
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 1) 函数不正确。求解出现问题的原因,安装版本为oracle11gR2,安装环境为windows2008 x64?
GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j001_6996.trc:
ORA-20011: Approximate NDV failed: ORA-01115: IO error reading block from file (block # )
ORA-01110: data file 5: 'D:\TABLESPACE\USERS\RUIYUAN_D01.DBF'
ORA-27070: async read/write failed
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 1) 函数不正确。求解出现问题的原因,安装版本为oracle11gR2,安装环境为windows2008 x64?
查看一下数据文件的状态:select file_name,file_id,tablespace_name,status,online_status from dba_data_files;
之前有做什么操作吗?
检查一下GATHER_STATS_JOB 这个脚本的