使用上述方法,却提示数据库验证失败,如何解决?C:\Documents and Settings\Administrator>sqlplus /nolog SQL*Plus: Release 9.0.1.0.1 - Production on 星期四 3月 25 14:00:55 2004 (c) Copyright 2001 Oracle Corporation. All rights reserved. SQL> connect / as sysdba 已连接。 SQL> shutdown abort ORACLE 例程已经关闭。 SQL> startup ORACLE 例程已经启动。 Total System Global Area 118255568 bytes Fixed Size 282576 bytes Variable Size 83886080 bytes Database Buffers 33554432 bytes Redo Buffers 532480 bytes 数据库装载完毕。 ORA-01122: 数据库文件 8 验证失败 ORA-01110: 数据文件 8: 'F:\ORACLE\ORADATA\SKY\USERS01.DBF' ORA-01200: 462720的实际文件大小小于463360块的正确大小
ORA-01200 actual file size of string is smaller than correct size of string blocksCause: The size of the file as returned by the operating system is smaller than the size of the file as indicated in the file header and the control file. Somehow the file has been truncated. Maybe it is the result of a half completed copy.Action: Restore a good copy of the datafile and do recovery as needed.还原一个好的数据文件拷贝,然后恢复。 希望你有一个数据文件备分
sql>recover database如果USERS01.DBF不重要,丢弃它。 sql>alter database datafile 8 offline drop
SQL*Plus: Release 9.0.1.0.1 - Production on 星期四 3月 25 14:00:55 2004
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SQL> connect / as sysdba
已连接。
SQL> shutdown abort
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
数据库装载完毕。
ORA-01122: 数据库文件 8 验证失败
ORA-01110: 数据文件 8: 'F:\ORACLE\ORADATA\SKY\USERS01.DBF'
ORA-01200: 462720的实际文件大小小于463360块的正确大小
希望你有一个数据文件备分
sql>alter database datafile 8 offline drop
正如楼上所说:
sql>alter database datafile 'F:\ORACLE\ORADATA\SKY\USERS01.DBF' offline drop;
sql>alter database open
以后的事情就马上要备份了,ok!