Oracle-ORA-03133-ERROR-1

Database

Oracle 错误 ORA-03113: end-of-file on communication channel 处理办法

Oracle启动时 报错信息

1
2
3
4
5
6
7
8
9
10
11
12
SQL> startup
ORACLE instance started.
  
Total System Global Area 1252663296 bytes
Fixed Size 2227944 bytes
Variable Size 704643352 bytes
Database Buffers 536870912 bytes
Redo Buffers 8921088 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 8117
Session ID: 191 Serial number: 3

错误原因

网上分析，可能由于昨晚数据库强制关闭，导致文件状态可能不一致，因为正常关闭数据库会同步校验各文件，使得重新启动的时候文件时间点一致

解决方式

1、 Oracle 需要启动到 mount 状态

1
2
3
4
5
SQL> conn / as sysdba
Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

2、获取 v$log 中的日志信息

1
SQL> select * from v$log;

3、依次尝试 恢复数据库

1
2
3
4
5
6
7
8
9
10
11
12
  
SQL> alter database open resetlogs 2;

SQL> alter database open resetlogs;

alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
  
SQL> recover database until time '2022-05-16'
Media recovery complete.

4、重置日志并启动数据库

1
2
3
SQL> alter database open resetlogs;
  
Database altered.

Title:Oracle-ORA-03133-ERROR-1

Author:

Created:2022-05-17, 16:47:39

Updated:2022-11-18, 09:11:43

Full URL:http://yoursite.com/2022/05/17/Oracle-ORA-03133-ERROR-1/

License: "CC BY-NC-SA 4.0" Keep Link & Author if Distribute.

Contents
  1. 1. Oracle 错误 ORA-03113: end-of-file on communication channel 处理办法
    1. 1.1. Oracle启动时 报错信息
    2. 1.2. 错误原因
    3. 1.3. 解决方式
      1. 1.3.1. 1、 Oracle 需要启动到 mount 状态
      2. 1.3.2. 2、获取 v$log 中的日志信息
      3. 1.3.3. 3、依次尝试 恢复数据库
      4. 1.3.4. 4、重置日志并启动数据库
|