文件夹中只有一个控制文件CONTROL01.CTL。版主救命啊! 手动重建控制文件。 比如: CREATE CONTROLFILE REUSE DATABASE "PRIMARY" NORESETLOGS ARCHIVELOG MAXLOGFILES 5 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 226 LOGFILE GROUP 1 '/opt/oracle/oradata/primary/redo01.log' SIZE 10M, GROUP 2 '/opt/oracle/oradata/primary/redo02.log' SIZE 10M, GROUP 3 '/opt/oracle/oradata/primary/redo03.log' SIZE 10M DATAFILE '/opt/oracle/oradata/primary/system01.dbf', '/opt/oracle/oradata/primary/undotbs01.dbf', '/opt/oracle/oradata/primary/users01.dbf' CHARACTER SET ZHS16GBK ; RECOVER DATABASE ;ALTER DATABASE OPEN;
文件夹中只有一个控制文件CONTROL01.CTL。版主救命啊! 手动重建控制文件。 比如: CREATE CONTROLFILE REUSE DATABASE "PRIMARY" NORESETLOGS ARCHIVELOG MAXLOGFILES 5 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 226 LOGFILE GROUP 1 '/opt/oracle/oradata/primary/redo01.log' SIZE 10M, GROUP 2 '/opt/oracle/oradata/primary/redo02.log' SIZE 10M, GROUP 3 '/opt/oracle/oradata/primary/redo03.log' SIZE 10M DATAFILE '/opt/oracle/oradata/primary/system01.dbf', '/opt/oracle/oradata/primary/undotbs01.dbf', '/opt/oracle/oradata/primary/users01.dbf' CHARACTER SET ZHS16GBK ; RECOVER DATABASE ;ALTER DATABASE OPEN; 重建报错了。
在nomount 状态下执行执行重建命令
在nomount 状态下执行执行重建命令 就是在nomount下执行的啊
在nomount 状态下执行执行重建命令 就是在nomount下执行的啊
ora 01158就是报:database already mounted 你再好好检查一下,先关掉,启动到nomount状态
在nomount 状态下执行执行重建命令 就是在nomount下执行的啊
ora 01158就是报:database already mounted 你再好好检查一下,先关掉,启动到nomount状态 以sysdba的身份登录后,首先shutdown immediate,出现 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可以删除重建吗?
在nomount 状态下执行执行重建命令 就是在nomount下执行的啊
ora 01158就是报:database already mounted 你再好好检查一下,先关掉,启动到nomount状态 终于搞定了,谢谢版主帮忙。好像就是控制文件不一致导致数据库无法加载。 SHUTDOWN IMMEDIATE; STARTUP NOMOUNT; CONTROL1.CTL文件复制到CONTROL2.CTL; ALTER SYSTEM SET CONTROL_FILES='E:\APP\ADMINSTRATOR\ORADATA\ORCL\CONTROL01.CTL' SCOPE=SPFILE; SHUTDOWN IMMEDIATE; STARTUP; OK!
手动重建控制文件。
比如:
CREATE CONTROLFILE REUSE DATABASE "PRIMARY" NORESETLOGS ARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 '/opt/oracle/oradata/primary/redo01.log' SIZE 10M,
GROUP 2 '/opt/oracle/oradata/primary/redo02.log' SIZE 10M,
GROUP 3 '/opt/oracle/oradata/primary/redo03.log' SIZE 10M
DATAFILE
'/opt/oracle/oradata/primary/system01.dbf',
'/opt/oracle/oradata/primary/undotbs01.dbf',
'/opt/oracle/oradata/primary/users01.dbf'
CHARACTER SET ZHS16GBK
;
RECOVER DATABASE ;ALTER DATABASE OPEN;
手动重建控制文件。
比如:
CREATE CONTROLFILE REUSE DATABASE "PRIMARY" NORESETLOGS ARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 '/opt/oracle/oradata/primary/redo01.log' SIZE 10M,
GROUP 2 '/opt/oracle/oradata/primary/redo02.log' SIZE 10M,
GROUP 3 '/opt/oracle/oradata/primary/redo03.log' SIZE 10M
DATAFILE
'/opt/oracle/oradata/primary/system01.dbf',
'/opt/oracle/oradata/primary/undotbs01.dbf',
'/opt/oracle/oradata/primary/users01.dbf'
CHARACTER SET ZHS16GBK
;
RECOVER DATABASE ;ALTER DATABASE OPEN;
重建报错了。
就是在nomount下执行的啊
就是在nomount下执行的啊
ora 01158就是报:database already mounted
你再好好检查一下,先关掉,启动到nomount状态
就是在nomount下执行的啊
ora 01158就是报:database already mounted
你再好好检查一下,先关掉,启动到nomount状态
以sysdba的身份登录后,首先shutdown immediate,出现
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可以删除重建吗?
就是在nomount下执行的啊
ora 01158就是报:database already mounted
你再好好检查一下,先关掉,启动到nomount状态
终于搞定了,谢谢版主帮忙。好像就是控制文件不一致导致数据库无法加载。
SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;
CONTROL1.CTL文件复制到CONTROL2.CTL;
ALTER SYSTEM SET CONTROL_FILES='E:\APP\ADMINSTRATOR\ORADATA\ORCL\CONTROL01.CTL' SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP;
OK!