ORA-01122 database file string failed verification checkCause: The information in this file is inconsistent with information from the control file. See accompanying message for reason.Action: Make certain that the database files and control files are the correct files for this database
ORA-01111 name for data file string is unknown - rename to correct fileCause: The datafile was missing from a CREATE CONTROLFILE command or BACKUP CONTROLFILE RECOVERY was done with a control file that was saved before the file was created.Action: Rename the MISSING file to the name of the real file.
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.
ORA-01111 name for data file string is unknown - rename to correct fileCause: The datafile was missing from a CREATE CONTROLFILE command or BACKUP CONTROLFILE RECOVERY was done with a control file that was saved before the file was created.Action: Rename the MISSING file to the name of the real file.
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.
解决方案 »
- 多次update 合并成一个
- JDBC??
- oracle查询格式转换
- 关于数据文件自动扩展功能(oracle10g)
- oracle中脏数据以及脏块是怎么来的,有啥区别啊?我都搞混了!
- 求一个关于分组计算的SQL语句,小弟没多少分,在线等,希望朋友们解围,多谢
- SQL like的小问题。急!!!
- 数据迁移,出现数据库连接数量问题
- oracle安装问题
- Administration Assistant for Windows NT中“Oracle NT服务”有什么用?
- windows2000 server 下oracle9i安装不了,望高手指点!
- 请教SQL Server中SQL语句在Oracle中的写法
实在没办法,ALTER DATABASE DATAFILE OFFLINE DROP,然后总是可以打开数据库的。