SQL> shutdown immediate
ORA-01507: ??????
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。 Total System Global Area 1.0435E+10 bytes
Fixed Size 2021512 bytes
Variable Size 1526728568 bytes
Database Buffers 8891924480 bytes
Redo Buffers 14753792 bytes
ORA-00205: ?????????, ??????, ??????? alert提示:
Thu Sep 10 10:22:41 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2236
Thu Sep 10 10:22:41 2009
starting up 1 shared server(s) ...
Thu Sep 10 10:22:42 2009
ALTER DATABASE MOUNT
Thu Sep 10 10:22:42 2009
ORA-00202: ????: ''E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL''
ORA-27046: ??????????????
OSD-04012: 文件大小不匹配 (OS 8437776) Thu Sep 10 10:22:42 2009
ORA-205 signalled during: ALTER DATABASE MOUNT... 要怎么解决????
跟:http://topic.csdn.net/u/20090910/10/46F1B225-2FB3-4FC0-89AC-5FA8F15FD8C0.html 问题基本一样
ORA-01507: ??????
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。 Total System Global Area 1.0435E+10 bytes
Fixed Size 2021512 bytes
Variable Size 1526728568 bytes
Database Buffers 8891924480 bytes
Redo Buffers 14753792 bytes
ORA-00205: ?????????, ??????, ??????? alert提示:
Thu Sep 10 10:22:41 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2236
Thu Sep 10 10:22:41 2009
starting up 1 shared server(s) ...
Thu Sep 10 10:22:42 2009
ALTER DATABASE MOUNT
Thu Sep 10 10:22:42 2009
ORA-00202: ????: ''E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL''
ORA-27046: ??????????????
OSD-04012: 文件大小不匹配 (OS 8437776) Thu Sep 10 10:22:42 2009
ORA-205 signalled during: ALTER DATABASE MOUNT... 要怎么解决????
跟:http://topic.csdn.net/u/20090910/10/46F1B225-2FB3-4FC0-89AC-5FA8F15FD8C0.html 问题基本一样
解决方案 »
- 虚拟机的oracle连接主机,连接不上
- 如何实现一次替换掉字符串中的 tab 符 和换行符
- 交易的连续性判断问题
- 存储过程中as 与 is 关键字的区别?
- windows的计算机名更改后,如何把ORACLE的主机名也相应更改过来?
- 如何分离oracle客户端,oracle版本为8i,操作系统为win2000?(在线)
- 一个加了判断的复杂存储过程,各位帮我看看啊~~~
- 如何在Oracle中把一个用户所拥有的全部对象付给另外一个用户?
- 如何增加/修改oracle的用户连接数
- 怎么选择语句select * from tbtest结果总是2呀????
- 求助:oracle10g冷备文件怎么恢复?
- 请教各位,用SQL语句查询包含此字段的所有表的表名,怎么写
ORA-00205: error in identifying control file, check alert log for more info
Cause: The system could not find a control file of the specified name and size.
Action: Check that ALL control files are online and that they are the same files that the system created at cold start time.
ORA-27046: file size is not a multiple of logical block size
Cause: file size as indicated by stat is not correct, additional information indicates which function encountered the error
Action: verify that the file has not been overwritten or truncated
控制文件出了问题。
ORA-00202: ????: ''E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL'' 看下pfile 参数中这个控制文件的路径是什么? log 里面怎么有两个'', 记的不太清楚了。 可以先检查一下这个参数。 启动时记得指定pfile: startup pfile=..如果修改之后启动还是不行,可以尝试一下方法。 删除CONTROL01.CTL, 复制CONTROL02.CTL,并将重命名为CONTROL01.CTL。 CONTROL 有3个文件,里面内容都是一样的,弄三个就是为了冗余。 看这样可行。 如果说2不行, 就用CONTROL03.CTL试试,如果三个都不行,就说明控制文件坏了,如果有备份就恢复控制文件。 如果没有, 就只能重建控制文件了。
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716