多路复用控制文件错误

Question

我们只能创建8个控制文件。

如果我创建了9个文件，我应该得到错误: ORA-00208:控制文件名的数量超过了8个。

但是我在通信通道上得到了错误ORA-03113:文件结束。

为什么不是奥拉-00208？

Answer 1

所发生的情况是后端尝试响应您在SQL*Plus中提供的startup命令而启动。这会失败--在alert.log中记录错误--而SQL*Plus将失去与后端的连接，因此您将在通信通道错误上接收文件结束。

在SQL*Plus中：

SQL> startup pfile='C:\more_ctlfiles.ora'
ORACLE instance started.

Total System Global Area 2.1206E+10 bytes
Fixed Size                 19897816 bytes
Variable Size            2818572288 bytes
Database Buffers         1.8321E+10 bytes
Redo Buffers               47210496 bytes
ORA-03113: end-of-file on communication channel
Process ID: 19528
Session ID: 607 Serial number: 8502

在警报日志文件中：

ALTER DATABASE   MOUNT
2020-01-19T11:06:24.896505-06:00
Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ckpt_22600.trc:
ORA-00208: number of control file names exceeds limit of 8
Errors in file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_ckpt_22600.trc  (incident=860698) (PDBNAME=CDB$ROOT):
ORA-208 [] [] [] [] [] [] [] [] [] [] [] []
Incident details in: C:\APP\ORACLE\diag\rdbms\orcl\orcl\incident\incdir_860698\orcl_ckpt_22600_i860698.trc
2020-01-19T11:06:27.070718-06:00
USER (ospid: ): terminating the instance due to ORA error 
2020-01-19T11:06:27.084396-06:00
System state dump requested by (instance=1, osid=22600 (CKPT)), summary=[abnormal instance termination].
System State dumped to trace file C:\APP\ORACLE\diag\rdbms\orcl\orcl\trace\orcl_diag_24248.trc
2020-01-19T11:06:30.323367-06:00
Instance terminated by USER, pid = 22600