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...
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...
alter session set nls_language=american;
alter database mount;
alter database open;然后贴报错信息
SQL> startup nomount;
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
SQL> alter session set nls_language=american; Session altered.SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted
Thu Sep 10 10:36:57 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=10, OS id=4904
Thu Sep 10 10:36:57 2009
starting up 1 shared server(s) ...
Thu Sep 10 10:37:22 2009
alter database mount
Thu Sep 10 10:37:22 2009
ORA-00202: ????: ''E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL''
ORA-27046: ??????????????
OSD-04012: 文件大小不匹配 (OS 8437776)Thu Sep 10 10:37:22 2009
ORA-205 signalled during: alter database mount...
Thu Sep 10 10:37:35 2009
alter database open
Thu Sep 10 10:37:35 2009
ORA-1507 signalled during: alter database open...
*.control_files='D:\oracle/oradata/TEST\control01.ctl',
'D:\oracle/oradata/TEST\control02.ctl',
'D:\oracle/oradata/TEST\control03.ctl'这些目录下面可有这些文件. 或者路径是否正确..如果不正确修改一下.. 如果没有pfile文件就创建个先
C:\Documents and Settings\user.HQ-TEXT>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on 星期四 9月 10 10:42:11 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn sys/admin as sysdba
已连接。
SQL> create pfile from spfile;文件已创建。SQL>在修改里面有关控制文件的内容,保存..startup pfile=....\sid.ora
就可以了..
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECORDS
BACKUP DATAFILE RECORDS
BACKUP LOG RECORDS
DATAFILE COPY RECORDS
BACKUP DATAFILE CORRUPTION RECORDS
DATAFILE COPY CORRUPTION RECORDS
DELETION RECORDS
PROXY COPY RECORDS
INCARNATION RECORDS 如果说原来的控制文件丢了,且没有备份的情况下,就只能重建控制文件了..
show parameter control_files 看看路径有没有问题
ORACLE 例程已经关闭。
SQL> startup nomount;
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
SQL> show parameter control_files;NAME TYPE
------------------------------------ -------------------
VALUE
------------------------------
control_files string
E:\ORACLE\PRODUCT\10.2.0\ORADA
TA\ORCL\CONTROL01.CTL, E:\ORAC
LE\PRODUCT\10.2.0\ORADATA\ORCL
\CONTROL02.CTL, E:\ORACLE\PROD
UCT\10.2.0\ORADATA\ORCL\CONTRO
L03.CTL
SQL>
27046, 00000, "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
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Sep 10 17:35:31 2009
SMON: enabling cache recovery
Thu Sep 10 17:35:31 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_3968.trc:
ORA-00600: 内部错误代码, 参数: [4000], [18], [], [], [], [], [], []Thu Sep 10 17:35:32 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_3968.trc:
ORA-00704: 引导程序进程失败
ORA-00704: 引导程序进程失败
ORA-00600: 内部错误代码, 参数: [4000], [18], [], [], [], [], [], []Thu Sep 10 17:35:32 2009
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Thu Sep 10 17:35:33 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4296.trc:
ORA-00704: ????????Thu Sep 10 17:35:33 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_2412.trc:
ORA-00704: ????????Thu Sep 10 17:35:33 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_reco_4128.trc:
ORA-00704: ????????Thu Sep 10 17:35:33 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ckpt_2228.trc:
ORA-00704: ????????Thu Sep 10 17:35:34 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_4100.trc:
ORA-00704: ????????Thu Sep 10 17:35:34 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_2192.trc:
ORA-00704: ????????Thu Sep 10 17:35:34 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_2400.trc:
ORA-00704: ????????Thu Sep 10 17:35:34 2009
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_1424.trc:
ORA-00704: ????????Instance terminated by USER, pid = 3968
ORA-1092 signalled during: ALTER DATABASE OPEN...现在的alert提示变这样了