ORA-01200: actual file size of string is smaller than correct size of string blocks Cause: 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 data file and do recovery as needed. ORA-00265: instance recovery required, cannot set ARCHIVELOG mode Cause: The database either crashed or was shutdown with the ABORT option. Media recovery cannot be enabled because the online logs may not be sufficient to recover the current datafiles.
Action: Open the database and then enter the SHUTDOWN command with the NORMAL or IMMEDIATE option. 之前有做过什么操作? 把数据库恢复一下吧。 ------------------------------------------------------------------------------ Blog: http://blog.csdn.net/tianlesoftware 网上资源: http://tianlesoftware.download.csdn.net 相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 群:62697716(满); DBA2 群:62697977
SQL> create controlfile reuse database woody noresetlogs archivelog 2 LOGFILE 3 GROUP 1 '/u01/app/oracle/oradata/woody/redo01.log', 4 GROUP 2 '/u01/app/oracle/oradata/woody/redo02.log', 5 GROUP 3 '/u01/app/oracle/oradata/woody/redo03.log' 6 DATAFILE 7 '/u01/app/oracle/oradata/woody/sysaux01.dbf', 8 '/u01/app/oracle/oradata/woody/system01.dbf', 9 '/u01/app/oracle/oradata/woody/UNDOTBS01.dbf' 10 CHARACTER SET ZHS16GBK 11 ; Control file created.参考: Oracle 控制文件: http://blog.csdn.net/tianlesoftware/archive/2009/12/13/4974440.aspx
ORA-01200: actual file size of string is smaller than correct size of string blocks
Cause: 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 data file and do recovery as needed.
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Cause: The database either crashed or was shutdown with the ABORT option. Media recovery cannot be enabled because the online logs may not be sufficient to recover the current datafiles.
Action: Open the database and then enter the SHUTDOWN command with the NORMAL or IMMEDIATE option.
之前有做过什么操作? 把数据库恢复一下吧。
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
2 LOGFILE
3 GROUP 1 '/u01/app/oracle/oradata/woody/redo01.log',
4 GROUP 2 '/u01/app/oracle/oradata/woody/redo02.log',
5 GROUP 3 '/u01/app/oracle/oradata/woody/redo03.log'
6 DATAFILE
7 '/u01/app/oracle/oradata/woody/sysaux01.dbf',
8 '/u01/app/oracle/oradata/woody/system01.dbf',
9 '/u01/app/oracle/oradata/woody/UNDOTBS01.dbf'
10 CHARACTER SET ZHS16GBK
11 ;
Control file created.参考: Oracle 控制文件:
http://blog.csdn.net/tianlesoftware/archive/2009/12/13/4974440.aspx
2 关闭数据库
3 重启数据库到nomount状态
4 建立控制文件
create controlfile database [实例名称] noresetlogs
logfile
重做日志位置
datafile
数据文件位置
5 打开数据库。