{"id":934,"date":"2021-12-15T10:42:50","date_gmt":"2021-12-15T02:42:50","guid":{"rendered":"http:\/\/www.danios.com\/?p=934"},"modified":"2021-12-20T10:41:24","modified_gmt":"2021-12-20T02:41:24","slug":"ora-03113-end-of-file-on-communication-channel%e8%a7%a3%e5%86%b3%e6%ad%a5%e9%aa%a4","status":"publish","type":"post","link":"https:\/\/www.oceansource.cc\/?p=934","title":{"rendered":"ORA-03113: end-of-file on communication channel\u89e3\u51b3\u6b65\u9aa4"},"content":{"rendered":"\n

\u901a\u5e38\u8fd9\u4e2a\u5f02\u5e38\u90fd\u662f\u7a7a\u95f4\u6ee1\u5bfc\u81f4\uff0c\u67e5\u8be2alter_orcl.log \u8fd9\u4e2a\u6587\u4ef6\u4e00\u822c\u90fd\u80fd\u770b\u5230\u9519\u8bef\u4fe1\u606f\uff0c\u5176\u4e2dorcl\u4e3a\u6570\u636e\u5e93\u7684sid\u3002
\u4e00\u822c\u90fd\u4f1a\u6709\u7c7b\u4f3c\u7684\u65e5\u5fd7\uff1a
ORA-19815: WARNING: db_recovery_file_dest_size of 5218762752 bytes is 100.00% used, and has 0 remaining bytes available.<\/p>\n\n\n\n

\n\n\n\n

You have following choices to free up space from recovery area:<\/p>\n\n\n\n

  1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
    then consider changing RMAN ARCHIVELOG DELETION POLICY.<\/li>
  2. Back up files to tertiary device such as tape using RMAN
    BACKUP RECOVERY AREA command.<\/li>
  3. Add disk space and increase db_recovery_file_dest_size parameter to
    reflect the new space.<\/li>
  4. Delete unnecessary files using RMAN DELETE command. If an operating
    system command was used to delete files, then use RMAN CROSSCHECK and
    DELETE EXPIRED commands.<\/li><\/ol>\n\n\n\n
    \n\n\n\n

    \u89e3\u51b3\u65b9\u6848\u4e00\u3001\u6e05\u7406\u6587\u4ef6<\/strong>\uff08\u5982\u679c\u4e0d\u60f3\u6e05\u7406\u6587\u4ef6\u53ef\u4ee5\u67e5\u770b\u89e3\u51b3\u65b9\u6848\u4e8c\uff09<\/p>\n\n\n\n

    \u5207\u6362\u5230oracle\u7528\u6237\u6267\u884c\uff1a<\/p>\n\n\n\n

    su – oracle<\/h4>\n\n\n\n

    [oracle@db~]$ sqlplus \/nolog<\/p>\n\n\n\n

    SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 23 17:44:00 2016<\/p>\n\n\n\n

    Copyright (c) 1982, 2009, Oracle. All rights reserved.
    sql> conn \/ as sysdba<\/p>\n\n\n\n

    Connected to an idle instance.<\/p>\n\n\n\n

    sql> startup nomount<\/p>\n\n\n\n

    ORACLE instance started.
    \u518d\u6267\u884c
    sql> alter database mount;<\/p>\n\n\n\n

    Database altered.<\/p>\n\n\n\n

    \u63a5\u4e0b\u6765\u5c31\u8981\u6e05\u7406\u7a7a\u95f4\u4e86
    \u53e6\u5916\u8d77\u4e00\u4e2a\u7ec8\u7aef\uff0c\u627e\u5230\u6587\u4ef6\u5b58\u653e\u8def\u5f84\uff1a
    [oracle@db~]$ cd \/data2\/oracle\/flash_recovery_area\/ORCL\/archivelog\/
    [oracle@db archivelog]$ pwd
    \/data2\/oracle\/flash_recovery_area\/ORCL\/archivelog
    [oracle@db archivelog]$ ls
    2016_06_01 2016_06_02 2016_06_03 2016_06_04 2016_06_05 2016_06_06 2016_06_07 2016_06_08 2016_06_21 2016_06_22 2016_06_23
    [oracle@db archivelog]$ rm -rf 2016_05*
    \u5220\u9664\u6389\u4e0d\u8981\u7684\u6587\u4ef6\u3002<\/p>\n\n\n\n

    \u63a5\u4e0b\u6765\u9700\u8981\u542f\u52a8rman\u4e86
    [oracle@db archivelog]$ rman target \/<\/p>\n\n\n\n

    Recovery Manager: Release 11.2.0.1.0 – Production on Thu Jun 23 17:49:55 2016<\/p>\n\n\n\n

    Copyright (c) 1982, 2009, Oracle and\/or its affiliates. All rights reserved.<\/p>\n\n\n\n

    connected to target database: ORCL (DBID=1412518558)<\/p>\n\n\n\n

    RMAN> crosscheck archivelog all;<\/p>\n\n\n\n

    \u4e00\u5806\u7684\u63d0\u793a\u4e0d\u7ba1\u5b83\uff0c\u518d\u6267\u884c\uff1a
    RMAN> delete expired archivelog all;
    \u5220\u9664\u6389\u8fc7\u671f\u7684\u5f52\u6863\u6587\u4ef6\u3002<\/p>\n\n\n\n

    \u63a5\u4e0b\u6765\u56de\u5230\u521a\u624d\u7684sqlplus\u7ec8\u7aef\uff0c\u6267\u884c\u5982\u4e0b\uff1a
    SQL> alter database open;<\/p>\n\n\n\n

    Database altered.<\/p>\n\n\n\n

    SQL><\/p>\n\n\n\n

    \u597d\u4e86\uff0c\u6570\u636e\u5e93\u8d77\u6765\u4e86\u3002
    \u7136\u540e\u542f\u52a8\u76d1\u542c\u7aef\u53e3\u5c31\u4e07\u4e8b\u5927\u5409\u4e86\u3002<\/p>\n\n\n\n

    \u89e3\u51b3\u65b9\u6848\u4e8c\u3001\u589e\u52a0\u6570\u636e\u5e93\u7a7a\u95f4<\/strong><\/p>\n\n\n\n

    \u5982\u679c\u78c1\u76d8\u7a7a\u95f4\u6ca1\u6709\u6ee1\uff0c\u60f3\u589e\u52a0\u95ea\u56de\u6062\u590d\u533a\u3002
    \u5728mount\u6570\u636e\u5e93\u540e\uff0c\u6267\u884c\uff1a
    alter system set db_recovery_file_dest_size=8G;
    \u4fee\u6539\u7684\u8fc7\u7a0b\u5982\u4e0b\uff1a
    <pre>
    [oracle@db~]$ sqlplus \/nolog<\/p>\n\n\n\n

    SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 24 10:56:40 2016<\/p>\n\n\n\n

    Copyright (c) 1982, 2009, Oracle. All rights reserved.<\/p>\n\n\n\n

    SQL> conn \/as sydba
    SP2-0306: Invalid option.
    Usage: CONN[ECT] [{logon|\/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
    where <logon> ::= <username>[\/<password>][@<connect_identifier>]
    <proxy> ::= <proxyuser>[<username>][\/<password>][@<connect_identifier>]
    SQL> exit
    [oracle@firebox42 ~]$ sqlplus \/nolog<\/p>\n\n\n\n

    SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 24 10:57:02 2016<\/p>\n\n\n\n

    Copyright (c) 1982, 2009, Oracle. All rights reserved.<\/p>\n\n\n\n

    SQL> conn \/as sysdba
    Connected to an idle instance.
    SQL> startup nomount
    ORA-01012: not logged on
    SQL> shutdown abort
    ORACLE instance shut down.
    SQL> startup nomount
    ORACLE instance started.<\/p>\n\n\n\n

    Total System Global Area 1.0689E+10 bytes
    Fixed Size 2216344 bytes
    Variable Size 6845107816 bytes
    Database Buffers 3825205248 bytes
    Redo Buffers 16945152 bytes
    SQL> alter database mount;<\/p>\n\n\n\n

    Database altered.<\/p>\n\n\n\n

    SQL> show parameter db_recover;<\/p>\n\n\n\n

    NAME TYPE VALUE<\/p>\n\n\n\n

    \n\n\n\n

    db_recovery_file_dest string \/opt\/oracle\/flash_recovery_are
    a
    db_recovery_file_dest_size big integer 3882M
    SQL> alter system set db_recovery_file_dest_size=80G;<\/p>\n\n\n\n

    System altered.<\/p>\n\n\n\n

    SQL> alter database open;<\/p>\n\n\n\n

    Database altered.<\/p>\n\n\n\n

    \u53c2\u8003\u6587\u7ae0\uff1ahttps:\/\/www.jianshu.com\/p\/97b86d95894b<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    \u901a\u5e38\u8fd9\u4e2a\u5f02\u5e38\u90fd\u662f\u7a7a\u95f4\u6ee1\u5bfc\u81f4\uff0c\u67e5\u8be2alter_orcl.log \u8fd9\u4e2a\u6587\u4ef6\u4e00\u822c\u90fd\u80fd\u770b\u5230\u9519\u8bef\u4fe1\u606f\uff0c\u5176\u4e2dorcl\u4e3a\u6570\u636e […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-934","post","type-post","status-publish","format-standard","hentry","category-linux"],"aioseo_notices":[],"views":340,"_links":{"self":[{"href":"https:\/\/www.oceansource.cc\/index.php?rest_route=\/wp\/v2\/posts\/934","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oceansource.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oceansource.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oceansource.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oceansource.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=934"}],"version-history":[{"count":1,"href":"https:\/\/www.oceansource.cc\/index.php?rest_route=\/wp\/v2\/posts\/934\/revisions"}],"predecessor-version":[{"id":935,"href":"https:\/\/www.oceansource.cc\/index.php?rest_route=\/wp\/v2\/posts\/934\/revisions\/935"}],"wp:attachment":[{"href":"https:\/\/www.oceansource.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=934"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oceansource.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=934"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oceansource.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}