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面试题集锦第一季
- 关于dblink调用存储过程,无法获取游标类型的返回值
- FOR 里面纠结的变量问题
- 一个基本问题,但是很急,丢饭碗的事,望大家帮忙!谢谢了
- 请问一台机子上的ORA文件,在另一台机子上可以直接做为一个数据库用吗?
- 我的temp表空间的数据文件怎么不能脱机?
- 关于oracle的数据类型……acsess VS oracle
- 奇怪!!!oracle占用了所以的linux系统CUP资源!
- 怎么在表中插入 '&' 字符啊!?
- 服务确定已经启动,但是连接提示ORA-01033
- 求助: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