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-01200: actual file size of 44841 is smaller than correct size of 64000blocks 数据文件的大小都不正确了 有备份没?
用数据文件备分还原,然后恢复
数据文件的大小都不正确了
有备份没?
如果是存放数据的文件,没有备份,没有archive log文件,估计就不能恢复了。
c:\svrmgrl
svrmgrl>connect internal
svrmgrl>startup mount
svrmgrl>alter database datafile 'C:\ORACLE\ORADATA\ORA9I2\tmp1orc1.ora' offline drop;
svrmgrl>alter database open;这个时候数据库打开了,首先EXP然后手工删除'C:\ORACLE\ORADATA\ORA9I2\tmp1orc1.ora'
然后在 ALTER TABLESPACE 。。 ADD DATAFILE 'C:\ORACLE\ORADATA\ORA9I2\tmp1orc1.ora' SIZE