ORACLE出现ora-01507和00205的错误怎么办? 查看alert日志,是否存在警告信息这个看着可能是控制文件的错误,几个控制文件的信息必须完全一致 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我已经把CONTROL01.CTL复制了两份,分别命名为CONTROL02.CTL和CONTROL03.CTL。还是出现这样的错误 上面你的图中只有两个错误:ora-01507:意思是执行你的指令前提是数据库是mount状态,而你的数据库没有mount,所以报错ora-01081:意思是你的数据库本身就是打开状态,所以报错综合原因是你的数据库是nomount状态,而且你的lsnrctl状态时是stop,下面模拟一下你的错误。下面上图。 解决方法就很简单。1.lsnrctl start;2.conn / as sysdba;然后alter system switch logfile;alter system checkpoint;3.shutdown immediate;4.startup open;5.执行你的语句; 执行alter system switch logfile出现ora-01109的错误还是无法解决。会是控制文件出问题了吗? 建议 LZ 先把 SID_alert.log 清空,再跑一下启动的语句,再把 这个 log 文件的内容贴上来,好分析 。 你未打开的状态下 ,是不允许切换日志的。 就像楼上说的, 把你的alert 的最近的日志贴上来一下。 你贴上来的都是???乱码,别人也没办法帮你更确切的分析 谢谢您的建议。我把alert贴在下面了,麻烦帮我看一下WARNING: Default Temporary Tablespace not specified in CREATE DATABASE commandDefault Temporary Tablespace will be necessary for a locally managed database in future releaseErrors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8464.trc:ORA-01163: SIZE ???? 204800 (?), ????? 102400 ??ORA-01517: ????: 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG'ORA-1503 signalled during: CREATE CONTROLFILE 你未打开的状态下 ,是不允许切换日志的。 就像楼上说的, 把你的alert 的最近的日志贴上来一下。 你贴上来的都是???乱码,别人也没办法帮你更确切的分析 谢谢版主!WARNING: Default Temporary Tablespace not specified in CREATE DATABASE commandDefault Temporary Tablespace will be necessary for a locally managed database in future releaseErrors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8464.trc:ORA-01163: SIZE ???? 204800 (?), ????? 102400 ??ORA-01517: ????: 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG'ORA-1503 signalled during: CREATE CONTROLFILE 以sysdba的身份登录后,首先shutdown immediate,出现ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...ARCH: Archival disabled due to shutdown: 1089Shutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeARCH: Archival disabled due to shutdown: 1089 然后startup,出现:ORA-00210: cannot open the specified control fileORA-00202: control file: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\E\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL'ORA-27041: unable to open fileOSD-04002: 无法打开文件O/S-Error: (OS 3) 系统找不到指定的路径。ORA-205 signalled during: ALTER DATABASE MOUNT... 发现控制文件有问题后,重新创建控制文件:CREATE CONTROLFILEREUSE DATABASE "orcl"NORESETLOGSNOARCHIVELOGMAXLOGFILES 50MAXLOGMEMBERS 3MAXDATAFILES 50MAXINSTANCES 5MAXLOGHISTORY 449LOGFILEGROUP 1 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG' SIZE 50M,GROUP 2 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG' SIZE 50M,GROUP 3 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG' SIZE 50MDATAFILE'E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF','E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF','E:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF','E:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF','E:\APP\ADMINISTRATOR\ORADATA\ORCL\MYSPACE.DBF','E:\APP\ADMINISTRATOR\ORADATA\ORCL\BOOKSPACE.DBF','E:\APP\ADMINISTRATOR\ORADATA\ORCL\BOOKUNDO.DBF'WARNING: Default Temporary Tablespace not specified in CREATE DATABASE commandDefault Temporary Tablespace will be necessary for a locally managed database in future releaseTue Oct 21 10:48:34 2014Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_m000_7464.trc (incident=56564):ORA-00227: corrupt block detected in control file: (block 1, # blocks 1)ORA-00202: control file: 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL'Incident details in: e:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_56564\orcl_m000_7464_i56564.trcTue Oct 21 10:48:36 2014Trace dumping is performing id=[cdmp_20141021104836]Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5440.trc:ORA-00200: ????????ORA-00202: ????: ''E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\E\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL''ORA-27040: ??????, ??????OSD-04002: 无法打开文件O/S-Error: (OS 3) 系统找不到指定的路径。ORA-1503 signalled during: CREATE CONTROLFILE 到底怎么回事,好着急。顺便问一下,oracle默认的数据库ORCL可以删除重建吗? 以sysdba的身份登录后,首先shutdown immediate,出现ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...ARCH: Archival disabled due to shutdown: 1089Shutting down archive processesArchiving is disabledArchive process shutdown avoided: 0 activeARCH: Archival disabled due to shutdown: 1089 然后startup,出现:ORA-00210: cannot open the specified control fileORA-00202: control file: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\E\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL'ORA-27041: unable to open fileOSD-04002: 无法打开文件O/S-Error: (OS 3) 系统找不到指定的路径。ORA-205 signalled during: ALTER DATABASE MOUNT... 发现控制文件有问题后,重新创建控制文件:CREATE CONTROLFILEREUSE DATABASE "orcl"NORESETLOGSNOARCHIVELOGMAXLOGFILES 50MAXLOGMEMBERS 3MAXDATAFILES 50MAXINSTANCES 5MAXLOGHISTORY 449LOGFILEGROUP 1 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG' SIZE 50M,GROUP 2 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG' SIZE 50M,GROUP 3 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG' SIZE 50MDATAFILE'E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF','E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF','E:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF','E:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF','E:\APP\ADMINISTRATOR\ORADATA\ORCL\MYSPACE.DBF','E:\APP\ADMINISTRATOR\ORADATA\ORCL\BOOKSPACE.DBF','E:\APP\ADMINISTRATOR\ORADATA\ORCL\BOOKUNDO.DBF'WARNING: Default Temporary Tablespace not specified in CREATE DATABASE commandDefault Temporary Tablespace will be necessary for a locally managed database in future releaseTue Oct 21 10:48:34 2014Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_m000_7464.trc (incident=56564):ORA-00227: corrupt block detected in control file: (block 1, # blocks 1)ORA-00202: control file: 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL'Incident details in: e:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_56564\orcl_m000_7464_i56564.trcTue Oct 21 10:48:36 2014Trace dumping is performing id=[cdmp_20141021104836]Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5440.trc:ORA-00200: ????????ORA-00202: ????: ''E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\E\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL''ORA-27040: ??????, ??????OSD-04002: 无法打开文件O/S-Error: (OS 3) 系统找不到指定的路径。ORA-1503 signalled during: CREATE CONTROLFILE 到底怎么回事,好着急。顺便问一下,oracle默认的数据库ORCL可以删除重建吗?可以删了重建的。 只是, 里面的数据 就要自己先导出来,要不然,就丢失了 如何在pl/sql中将两字符连接,谢谢。 关于单独存放BLOB文件表空间的问题 新手存储过程思考 Oracle同志们,努力奋斗啊! oracle 怎么把一个库中的某个表的数据单独回滚到24小时以前??跪求答案 自增id在pb的数据窗口中能使用吗?怎么用啊? 我刚学oracle,有个问题,从oracle中如何查看当前打开游标数等一些信息? 关于form_builder连接odbc的问题!!!!! oracle 数据挖掘 oracle 查询数据效率问题 oracle报错ORA-01507 查询优化
ora-01507:意思是执行你的指令前提是数据库是mount状态,而你的数据库没有mount,所以报错
ora-01081:意思是你的数据库本身就是打开状态,所以报错
综合原因是你的数据库是nomount状态,而且你的lsnrctl状态时是stop,下面模拟一下你的错误。下面上图。
1.lsnrctl start;
2.conn / as sysdba;然后alter system switch logfile;alter system checkpoint;
3.shutdown immediate;
4.startup open;
5.执行你的语句;
你未打开的状态下 ,是不允许切换日志的。 就像楼上说的, 把你的alert 的最近的日志贴上来一下。 你贴上来的都是???乱码,别人也没办法帮你更确切的分析
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8464.trc:
ORA-01163: SIZE ???? 204800 (?), ????? 102400 ??
ORA-01517: ????: 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG'
ORA-1503 signalled during: CREATE CONTROLFILE
你未打开的状态下 ,是不允许切换日志的。 就像楼上说的, 把你的alert 的最近的日志贴上来一下。 你贴上来的都是???乱码,别人也没办法帮你更确切的分析
谢谢版主!
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_8464.trc:
ORA-01163: SIZE ???? 204800 (?), ????? 102400 ??
ORA-01517: ????: 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG'
ORA-1503 signalled during: CREATE CONTROLFILE
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
然后startup,出现:
ORA-00210: cannot open the specified control file
ORA-00202: control file: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\E\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL'
ORA-27041: unable to open file
OSD-04002: 无法打开文件
O/S-Error: (OS 3) 系统找不到指定的路径。
ORA-205 signalled during: ALTER DATABASE MOUNT...
发现控制文件有问题后,重新创建控制文件:
CREATE CONTROLFILE
REUSE DATABASE "orcl"
NORESETLOGS
NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXDATAFILES 50
MAXINSTANCES 5
MAXLOGHISTORY 449
LOGFILE
GROUP 1 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG' SIZE 50M,
GROUP 2 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG' SIZE 50M,
GROUP 3 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG' SIZE 50M
DATAFILE
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF',
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF',
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF',
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF',
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\MYSPACE.DBF',
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\BOOKSPACE.DBF',
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\BOOKUNDO.DBF'
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Tue Oct 21 10:48:34 2014
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_m000_7464.trc (incident=56564):
ORA-00227: corrupt block detected in control file: (block 1, # blocks 1)
ORA-00202: control file: 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL'
Incident details in: e:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_56564\orcl_m000_7464_i56564.trc
Tue Oct 21 10:48:36 2014
Trace dumping is performing id=[cdmp_20141021104836]
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5440.trc:
ORA-00200: ????????
ORA-00202: ????: ''E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\E\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL''
ORA-27040: ??????, ??????
OSD-04002: 无法打开文件
O/S-Error: (OS 3) 系统找不到指定的路径。
ORA-1503 signalled during: CREATE CONTROLFILE
到底怎么回事,好着急。顺便问一下,oracle默认的数据库ORCL可以删除重建吗?
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
然后startup,出现:
ORA-00210: cannot open the specified control file
ORA-00202: control file: 'E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\E\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL'
ORA-27041: unable to open file
OSD-04002: 无法打开文件
O/S-Error: (OS 3) 系统找不到指定的路径。
ORA-205 signalled during: ALTER DATABASE MOUNT...
发现控制文件有问题后,重新创建控制文件:
CREATE CONTROLFILE
REUSE DATABASE "orcl"
NORESETLOGS
NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXDATAFILES 50
MAXINSTANCES 5
MAXLOGHISTORY 449
LOGFILE
GROUP 1 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG' SIZE 50M,
GROUP 2 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG' SIZE 50M,
GROUP 3 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG' SIZE 50M
DATAFILE
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF',
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF',
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF',
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF',
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\MYSPACE.DBF',
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\BOOKSPACE.DBF',
'E:\APP\ADMINISTRATOR\ORADATA\ORCL\BOOKUNDO.DBF'
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Tue Oct 21 10:48:34 2014
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_m000_7464.trc (incident=56564):
ORA-00227: corrupt block detected in control file: (block 1, # blocks 1)
ORA-00202: control file: 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL'
Incident details in: e:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_56564\orcl_m000_7464_i56564.trc
Tue Oct 21 10:48:36 2014
Trace dumping is performing id=[cdmp_20141021104836]
Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_5440.trc:
ORA-00200: ????????
ORA-00202: ????: ''E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\E\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL''
ORA-27040: ??????, ??????
OSD-04002: 无法打开文件
O/S-Error: (OS 3) 系统找不到指定的路径。
ORA-1503 signalled during: CREATE CONTROLFILE
到底怎么回事,好着急。顺便问一下,oracle默认的数据库ORCL可以删除重建吗?
可以删了重建的。 只是, 里面的数据 就要自己先导出来,要不然,就丢失了