ora-00205：系统找不到控制文件

来源：互联网发布：办公楼pert网络布线图编辑：程序博客网时间：2024/05/16 01:07

ora-00205：系统找不到控制文件

错误描述：在为系统添加控制文件时，将控制文件的路径写错，启动数据库时报错ora-00205.

SQL> alter system set control_files='f:\app\administrator\oradata\orcl\control01.ctl',

'f:\app\administrator\flash_recovery_area\orcl\control02.ctl','f:\app\administrator\orafiless\control03.ctl' scope=spfile;

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 430075904 bytes

Fixed Size 2176448 bytes

Variable Size 322964032 bytes

Database Buffers 96468992 bytes

Redo Buffers 8466432 bytes

ORA-00205: ?????????, ??????, ???????

解决方法：

1. 关闭数据库,并生成参数文件。

SQL> shutdown abort

ORACLE instance shut down.

SQL> create pfile from spfile;

File created.

SQL>

此时在路径F:\app\Administrator\product\11.2.0\dbhome_1\database下生成一个文件INITorcl.ORA。用记事本打开，将控制文件路径写对，控制文件参数为*.control_files.

2. 重新生成参数文件

SQL> create spfile from pfile;

File created.

SQL>

3.启动数据库

SQL> startup

ORACLE instance started.

Total System Global Area 430075904 bytes

Fixed Size 2176448 bytes

Variable Size 322964032 bytes

Database Buffers 96468992 bytes

Redo Buffers 8466432 bytes

Database mounted.

Database opened.

SQL> show parameter control_files

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

control_files string F:\APP\ADMINISTRATOR\ORADATA\O

RCL\CONTROL01.CTL, F:\APP\ADMI

NISTRATOR\FLASH_RECOVERY_AREA\

ORCL\CONTROL02.CTL, F:\APP\ADM

INISTRATOR\ORAFILES\CONTROL03.

CTL

SQL>

提示：在数据库报错的时候，要学会查看警告日志，警告日志位置路径：F:\app\Administrator\diag\rdbms\orcl\orcl\trace\alert_orcl.log.

0 0