> 데이터 베이스 > MySQL 튜토리얼 > ORA-03113: end-of-file on communication channel

ORA-03113: end-of-file on communication channel

WBOY
풀어 주다: 2016-06-07 17:34:42
원래의
1296명이 탐색했습니다.

ORA-03113: end-of-file on communication channel

1. 当启动Oracle 发现报错

SQL> startup

报错:

ORA-03113: end-of-file on communication channel

查看alert.log文件,发现

ORA-03113: end-of-file on communication channel
cannot reclaim 45680128 bytes disk space from 2147483648 limit
ARCH: Error 19809 Creating archive log file to '/u01/flash_recovery_area/ORCL/archivelog/2014_01_17/o1_mf_1_6_%u_.arc'


这是由于归档表空间已满,分配不到空间所致

解决办法如下:打开数据库至mount模式,而后删除需要废弃的文件:

RMAN> startup nomount;

Oracle instance started

Total System Global Area    835104768 bytes

Fixed Size                    2217952 bytes
Variable Size                587204640 bytes
Database Buffers            243269632 bytes
Redo Buffers                  2412544 bytes

RMAN> resotre spfile from autobackup;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, connect, convert, copy, create, crosscheck, delete, drop, duplicate, exit, flashback, grant, host, import, list, mount, open, print, quit, recover, register, release, repair, replace, report, reset, restore, resync, revoke, run, send, set, show, shutdown, spool, sql, startup, switch, transport, unregister, upgrade, validate, {, "
RMAN-01008: the bad identifier was: resotre
RMAN-01007: at line 1 column 1 file: standard input

RMAN> alter database mount;

database mounted

RMAN> delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
Deleting the following obsolete backups and copies:
Type                Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set          2      27-DEC-13       
  Backup Piece      2      27-DEC-13          /u01/flash_recovery_area/ORCL/backupset/2013_12_27/o1_mf_nnndf_TAG20131227T172528_9cwb48k0_.bkp
Archive Log          2      27-DEC-13          /u01/flash_recovery_area/ORCL/archivelog/2013_12_27/o1_mf_1_7_9cwq8sbj_.arc
Backup Set          1      27-DEC-13       
  Backup Piece      1      27-DEC-13          /u01/flash_recovery_area/ORCL/backupset/2013_12_27/o1_mf_ncsnf_TAG20131227T172528_9cwb7lrp_.bkp
Archive Log          1      27-DEC-13          /u01/flash_recovery_area/ORCL/archivelog/2013_12_27/o1_mf_1_6_9cwq0xm1_.arc
Archive Log          3      27-DEC-13          /u01/flash_recovery_area/ORCL/archivelog/2013_12_27/o1_mf_1_5_9cwm7cv6_.arc

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/flash_recovery_area/ORCL/backupset/2013_12_27/o1_mf_nnndf_TAG20131227T172528_9cwb48k0_.bkp RECID=2 STAMP=835306248
deleted archived log
archived log file name=/u01/flash_recovery_area/ORCL/archivelog/2013_12_27/o1_mf_1_7_9cwq8sbj_.arc RECID=2 STAMP=835306247
deleted backup piece
backup piece handle=/u01/flash_recovery_area/ORCL/backupset/2013_12_27/o1_mf_ncsnf_TAG20131227T172528_9cwb7lrp_.bkp RECID=1 STAMP=835306248
deleted archived log
archived log file name=/u01/flash_recovery_area/ORCL/archivelog/2013_12_27/o1_mf_1_6_9cwq0xm1_.arc RECID=1 STAMP=835306247
deleted archived log
archived log file name=/u01/flash_recovery_area/ORCL/archivelog/2013_12_27/o1_mf_1_5_9cwm7cv6_.arc RECID=3 STAMP=835306247
Deleted 5 objects


RMAN> alter datatbase open;

推荐阅读:

ORA-01172、ORA-01151错误处理

ORA-00600 [2662]错误解决

ORA-01078 和 LRM-00109 报错解决方法

ORA-00471 处理方法笔记

ORA-00314,redolog 损坏,或丢失处理方法

ORA-00257 归档日志过大导致无法存储的解决办法

linux

관련 라벨:
원천:php.cn
본 웹사이트의 성명
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.
인기 튜토리얼
더>
최신 다운로드
더>
웹 효과
웹사이트 소스 코드
웹사이트 자료
프론트엔드 템플릿