ORA-03113: end-of-file on communication channel
来源:互联网 发布:nginx启动 window 编辑:程序博客网 时间:2024/04/29 01:15
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 startedTotal System Global Area 835104768 bytesFixed Size 2217952 bytesVariable Size 587204640 bytesDatabase Buffers 243269632 bytesRedo Buffers 2412544 bytesRMAN> resotre spfile from autobackup;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00558: error encountered while parsing input commandsRMAN-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: resotreRMAN-01007: at line 1 column 1 file: standard inputRMAN> alter database mount;database mountedRMAN> delete obsolete;RMAN retention policy will be applied to the commandRMAN retention policy is set to recovery window of 1 daysallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=19 device type=DISKDeleting 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_.bkpArchive Log 2 27-DEC-13 /u01/flash_recovery_area/ORCL/archivelog/2013_12_27/o1_mf_1_7_9cwq8sbj_.arcBackup 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_.bkpArchive Log 1 27-DEC-13 /u01/flash_recovery_area/ORCL/archivelog/2013_12_27/o1_mf_1_6_9cwq0xm1_.arcArchive Log 3 27-DEC-13 /u01/flash_recovery_area/ORCL/archivelog/2013_12_27/o1_mf_1_5_9cwm7cv6_.arcDo you really want to delete the above objects (enter YES or NO)? yesdeleted backup piecebackup piece handle=/u01/flash_recovery_area/ORCL/backupset/2013_12_27/o1_mf_nnndf_TAG20131227T172528_9cwb48k0_.bkp RECID=2 STAMP=835306248deleted archived logarchived log file name=/u01/flash_recovery_area/ORCL/archivelog/2013_12_27/o1_mf_1_7_9cwq8sbj_.arc RECID=2 STAMP=835306247deleted backup piecebackup piece handle=/u01/flash_recovery_area/ORCL/backupset/2013_12_27/o1_mf_ncsnf_TAG20131227T172528_9cwb7lrp_.bkp RECID=1 STAMP=835306248deleted archived logarchived log file name=/u01/flash_recovery_area/ORCL/archivelog/2013_12_27/o1_mf_1_6_9cwq0xm1_.arc RECID=1 STAMP=835306247deleted archived logarchived log file name=/u01/flash_recovery_area/ORCL/archivelog/2013_12_27/o1_mf_1_5_9cwm7cv6_.arc RECID=3 STAMP=835306247Deleted 5 objectsRMAN> alter datatbase open;
ORA-03113: end-of-file on communication channel
0 0
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- 遇到ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113 end-of-file on communication channel 问题解决
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113end-of-file on communication channel解决
- ORA-03113: end-of-file on communication channel 解决方法
- ORA-03113: end-of-file on communication channel解决方法
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- u-boot.lds详细的分析
- ubuntu13.10安装 octave
- 静态链接库和动态链接库
- POJ 2115 C Looooops
- 理解RESTful架构
- ORA-03113: end-of-file on communication channel
- c语言中可变参数的原理---printf()函数
- c c++中冒号的用法
- argc argv
- 按钮效果
- 学长们的求职血泪史(C/C++/JAVA)
- 将一个文件夹下的多个文件合并到一个文件中
- FLAC格式总结
- device time zone