联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
数据库启动报:ORA-03113: 通信通道的文件结尾
PS C:\Users\Administrator> sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on 星期六 8月 3 11:05:03 2024 Copyright (c) 1982, 2010, Oracle. All rights reserved. 已连接到空闲例程。 SQL> startup nomount ORACLE 例程已经启动。 Total System Global Area 2.0510E+10 bytes Fixed Size 2184632 bytes Variable Size 1.1476E+10 bytes Database Buffers 8992587776 bytes Redo Buffers 40046592 bytes SQL> shutdown immediate ORA-01507: ?????? ORACLE 例程已经关闭。 SQL> startup ORACLE 例程已经启动。 Total System Global Area 2.0510E+10 bytes Fixed Size 2184632 bytes Variable Size 1.1476E+10 bytes Database Buffers 8992587776 bytes Redo Buffers 40046592 bytes 数据库装载完毕。 ORA-03113: 通信通道的文件结尾 进程 ID: 4040 会话 ID: 1018 序列号: 7
这类错误,一般真正错误原因在alert日志中,查看alert日志
Sat Aug 03 08:15:12 2024 alter database mount exclusive Successful mount of redo thread 1, with mount id 3557233552 Database mounted in Exclusive Mode Lost write protection disabled Completed: alter database mount exclusive alter database open Beginning crash recovery of 1 threads parallel recovery started with 11 processes Started redo scan Completed redo scan read 0 KB redo, 0 data blocks need recovery Started redo application at Thread 1: logseq 745, block 80599, scn 7100295 Recovery of Online Redo Log: Thread 1 Group 1 Seq 745 Reading mem 0 Mem# 0: D:\ORACLE\ORADATA\XFF\REDO01.LOG Completed redo application of 0.00MB Completed crash recovery at Thread 1: logseq 745, block 80599, scn 7120296 0 data blocks read, 0 data blocks written, 0 redo k-bytes read LGWR: STARTING ARCH PROCESSES Sat Aug 03 08:15:19 2024 ARC0 started with pid=32, OS id=5496 ARC0: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC0: STARTING ARCH PROCESSES Sat Aug 03 08:15:20 2024 ARC1 started with pid=33, OS id=3873072 Sat Aug 03 08:15:20 2024 ARC2 started with pid=34, OS id=3873644 ARC1: Archival started ARC2: Archival started ARC2: Becoming the 'no FAL' ARCH ARC2: Becoming the 'no SRL' ARCH ARC1: Becoming the heartbeat ARCH sksasmowrt WriteConsole error 6 Errors in file d:\oracle\diag\rdbms\xff\xff\trace\xff_arc2_3873644.trc: ORA-19815: 警告: db_recovery_file_dest_size 字节 (共 10737418240 字节) 已使用 100.00%, 尚有 0 字节可用。 ************************************************************************ You have following choices to free up space from recovery area: 1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, then consider changing RMAN ARCHIVELOG DELETION POLICY. 2. Back up files to tertiary device such as tape using RMAN BACKUP RECOVERY AREA command. 3. Add disk space and increase db_recovery_file_dest_size parameter to reflect the new space. 4. Delete unnecessary files using RMAN DELETE command. If an operating system command was used to delete files, then use RMAN CROSSCHECK and DELETE EXPIRED commands. ************************************************************************ Errors in file d:\oracle\diag\rdbms\xff\xff\trace\xff_arc2_3873644.trc: ORA-19809: 超出了恢复文件数的限制 ORA-19804: 无法回收 13760000 字节磁盘空间 (从 10737418240 限制中) ARC2: Error 19809 Creating archive log file to 'D:\FRA\XFF\ARCHIVELOG\2024_08_03\O1_MF_1_744_%U_.ARC' Sat Aug 03 08:15:20 2024 ARC3 started with pid=35, OS id=3873424 ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Errors in file d:\oracle\diag\rdbms\xff\xff\trace\xff_ora_3873352.trc: ORA-19815: ??: db_recovery_file_dest_size ?? (? 10737418240 ??) ??? 100.00%, ?? 0 ????? ************************************************************************ You have following choices to free up space from recovery area: 1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, then consider changing RMAN ARCHIVELOG DELETION POLICY. 2. Back up files to tertiary device such as tape using RMAN BACKUP RECOVERY AREA command. 3. Add disk space and increase db_recovery_file_dest_size parameter to reflect the new space. 4. Delete unnecessary files using RMAN DELETE command. If an operating system command was used to delete files, then use RMAN CROSSCHECK and DELETE EXPIRED commands. ************************************************************************ Errors in file d:\oracle\diag\rdbms\xff\xff\trace\xff_ora_3873352.trc: ORA-19809: ??????????? ORA-19804: ???? 12296704 ?????? (? 10737418240 ???) ARCH: Error 19809 Creating archive log file to 'D:\FRA\XFF\ARCHIVELOG\2024_08_03\O1_MF_1_743_%U_.ARC' ARCH: Archival stopped, error occurred. Will continue retrying Errors in file d:\oracle\diag\rdbms\xff\xff\trace\xff_arc2_3873644.trc: ORA-16038: 日志 3 sequence# 744 无法归档 ORA-19809: 超出了恢复文件数的限制 ORA-00312: 联机日志 3 线程 1: 'D:\ORACLE\ORADATA\XFF\REDO03.LOG' Errors in file d:\oracle\diag\rdbms\xff\xff\trace\xff_ora_3873352.trc: ORA-16038: ?? 2 sequence# 743 ???? ORA-19809: ??????????? ORA-00312: ???? 2 ?? 1: 'D:\ORACLE\ORADATA\XFF\REDO02.LOG' USER (ospid: 3873352): terminating the instance due to error 16038 Sat Aug 03 08:15:27 2024 Instance terminated by USER, pid = 3873352
是由于闪回区满了,导致redo无法归档,从而使得数据库无法正常open,解决办法:
1. 清理以前归档日志
2. 把闪回区调大一些