Oracle-ORA-03133-ERROR-1

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

Oracle启动时 报错信息

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 状态

SQL> conn / as sysdba
Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

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

SQL> select * from v$log;

3、依次尝试 恢复数据库

  
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、重置日志并启动数据库

SQL> alter database open resetlogs;
  
Database altered.

赏

谢谢你请我吃糖果

支付宝

微信