Oracle回闪空间不足引起的ORA-03113问题排解

1.启动数据库失败

oracle@zxyybak:~ (zxyybak)$ sq

SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 21 21:31:59 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup 
ORACLE instance started.

Total System Global Area 5.5051E+10 bytes
Fixed Size          2266344 bytes
Variable Size        6039800600 bytes
Database Buffers     4.8989E+10 bytes
Redo Buffers           19292160 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 7479
Session ID: 1134 Serial number: 3

SQL>```


## 2.启动到Mount状态
```bash
oracle@zxyybak:~ (zxyybak)$ sq

SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 21 21:36:26 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount 
ORACLE instance started.

Total System Global Area 5.5051E+10 bytes
Fixed Size          2266344 bytes
Variable Size        6039800600 bytes
Database Buffers     4.8989E+10 bytes
Redo Buffers           19292160 bytes
Database mounted.
SQL>

3. rman

oracle@zxyybak:~ (zxyybak)$ rman target  / 

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Nov 21 21:36:42 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1407307953, not open)

RMAN>  crosscheck archivelog all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1982 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=2266 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=2549 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=2832 device type=DISK
validation succeeded for archived log
archived log file name=/u01/app/oracle/archive/ORCL/archivelog/2019_11_16/o1_mf_1_32583_gwxlw3df_.arc RECID=403932 STAMP=1024444805

RMAN> delete archivelog all;
点赞

发表评论

电子邮件地址不会被公开。必填项已用 * 标注