>> When our developers are trying to connect my test database its showing ORA-03113 end of file communication channel.
>> The connection between Client and Server process was broken this shoot up ORA-03113 error.
C:\Users\oracle> set oracle_sid= testdb
C:\Users\oracle> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Mar 15 12:35:41 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2264616 bytes
Variable Size 6543114712 bytes
Database Buffers 4127195136 bytes
Redo Buffers 16900096 bytes
Database mounted.
ORA-03113 : end-of-file on communication channel
Process ID : 5114
Session ID : 191 Serial number: 3
>> In my Alert log and Trace files following errors have shown.
Alert log :-
ORA-03113 : end-of-file on communication channel
Process ID : 5114
Session ID : 191 Serial number: 3
Trace File :-
ARC1: Error 19809 Creating archive log file to 'K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2016_03_10\O1_MF_1_58_%U_.ARC'
ORA-19815: WARNING: db_recovery_file_dest_size of 10737418240 bytes is 100.00% used, and has 0 remaining bytes available.
>> The problem you can see above in trace file, my FRA destination is filled up.
>> So we have to delete the archivelogs and make space to generate new archives.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2264616 bytes
Variable Size 6543114712 bytes
Database Buffers 4127195136 bytes
Redo Buffers 16900096 bytes
Database mounted.
Connect From RMAN and Delete Archivelogs
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Users\oracle> rman
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Mar 10 14:09:03 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target \
target database Password:
target database Password:
connected to target database: TESTDB (DBID=2750453233, not open)
RMAN> delete expired archivelog all;
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_08\O1_MF_1_72_BFGQZ4OX_.ARC RECID=3 STAMP=871142933
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_08\O1_MF_1_73_BFGQZ5H1_.ARC RECID=4 STAMP=871142934
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_08\O1_MF_1_74_BFGQZ2HP_.ARC RECID=1 STAMP=871142931
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_08\O1_MF_1_75_BFGQZ3G5_.ARC RECID=2 STAMP=871142932
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_08\O1_MF_1_1_BFGS7WV5_.ARC RECID=5 STAMP=871144238
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_10\O1_MF_1_2_BFLYTWYN_.ARC RECID=6 STAMP=871281038
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_11\O1_MF_1_3_BFP3LWPN_.ARC RECID=7 STAMP=871384205
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_12\O1_MF_1_4_BFRMVYL4_.ARC RECID=8 STAMP=871466415
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_14\O1_MF_1_5_BFXTY7N4_.ARC RECID=9 STAMP=871637496
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_16\O1_MF_1_6_BG3HYLRN_.ARC RECID=10 STAMP=871822851
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_17\O1_MF_1_7_BG6GW86G_.ARC RECID=11 STAMP=871920057
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_19\O1_MF_1_8_BGC61B7J_.ARC RECID=12 STAMP=872074843
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_20\O1_MF_1_9_BGGM0ZWN_.ARC RECID=13 STAMP=872186449
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_22\O1_MF_1_10_BGM4TB15_.ARC RECID=14 STAMP=872335738
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_23\O1_MF_1_11_BGP3GMHR_.ARC RECID=15 STAMP=872432644
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_25\O1_MF_1_12_BGT00Z5D_.ARC RECID=16 STAMP=872560208
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_26\O1_MF_1_13_BGXH5M8O_.ARC RECID=17 STAMP=872674021
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_02_28\O1_MF_1_14_BH2R01T6_.ARC RECID=18 STAMP=872846899
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_01\O1_MF_1_15_BH5O9YKH_.ARC RECID=19 STAMP=873201648
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_02\O1_MF_1_16_BH8C5LOX_.ARC RECID=20 STAMP=873289571
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_02\O1_MF_1_17_BH8QBX5F_.ARC RECID=21 STAMP=873302029
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_03\O1_MF_1_18_BHB1Y3RY_.ARC RECID=22 STAMP=873345652
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_04\O1_MF_1_19_BHF7WYSZ_.ARC RECID=23 STAMP=873450064
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_05\O1_MF_1_20_BHJVZ2KQ_.ARC RECID=24 STAMP=873568915
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_07\O1_MF_1_21_BHOPQ5T0_.ARC RECID=25 STAMP=873727382
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_09\O1_MF_1_22_BHTLB1L6_.ARC RECID=26 STAMP=873886706
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_10\O1_MF_1_23_BHWZBKHN_.ARC RECID=27 STAMP=873965570
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_11\O1_MF_1_24_BJ0X4WBC_.ARC RECID=28 STAMP=874094413
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_13\O1_MF_1_25_BJ5KV4GX_.ARC RECID=29 STAMP=874246677
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_14\O1_MF_1_26_BJ8D86DC_.ARC RECID=30 STAMP=874339255
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_16\O1_MF_1_27_BJDKT4DD_.ARC RECID=31 STAMP=874476021
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_17\O1_MF_1_28_BJJ3J4FF_.ARC RECID=32 STAMP=874592437
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_19\O1_MF_1_29_BJNOJZL0_.ARC RECID=33 STAMP=874741968
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_20\O1_MF_1_30_BJRR274X_.ARC RECID=34 STAMP=874875640
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_21\O1_MF_1_31_BJV8Y567_.ARC RECID=35 STAMP=874958454
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_23\O1_MF_1_32_BJYLZ38C_.ARC RECID=36 STAMP=875067028
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_24\O1_MF_1_33_BK1X9QQC_.ARC RECID=37 STAMP=875175913
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_26\O1_MF_1_34_BK76467O_.ARC RECID=38 STAMP=875348791
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_27\O1_MF_1_35_BKBZNT57_.ARC RECID=39 STAMP=875473227
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_28\O1_MF_1_36_BKG2QBM5_.ARC RECID=40 STAMP=875574683
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_30\O1_MF_1_37_BKKX5L28_.ARC RECID=41 STAMP=875700067
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_03_31\O1_MF_1_38_BKO54KQP_.ARC RECID=42 STAMP=875806530
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_02\O1_MF_1_39_BKSZNJ01_.ARC RECID=43 STAMP=875964736
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_03\O1_MF_1_40_BKXBRCTF_.ARC RECID=44 STAMP=876074429
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_04\O1_MF_1_41_BL02N7D2_.ARC RECID=45 STAMP=876164408
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_06\O1_MF_1_42_BL44VKT1_.ARC RECID=46 STAMP=876297762
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_07\O1_MF_1_43_BL7BZHMO_.ARC RECID=47 STAMP=876402336
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_09\O1_MF_1_44_BLCQ9JCR_.ARC RECID=48 STAMP=876546017
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_10\O1_MF_1_45_BLHMGVGP_.ARC RECID=49 STAMP=876673164
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_11\O1_MF_1_46_BLL7689Y_.ARC RECID=50 STAMP=876758905
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_12\O1_MF_1_47_BLO5ON0Y_.ARC RECID=51 STAMP=876855653
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_14\O1_MF_1_48_BLS89M5B_.ARC RECID=52 STAMP=876989412
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_16\O1_MF_1_49_BLYK43P8_.ARC RECID=53 STAMP=877162293
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_17\O1_MF_1_50_BM2OSCWF_.ARC RECID=54 STAMP=877298140
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_19\O1_MF_1_51_BM5W12Y4_.ARC RECID=55 STAMP=877402835
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_20\O1_MF_1_52_BM994D7J_.ARC RECID=56 STAMP=877514557
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_21\O1_MF_1_53_BMDH71VL_.ARC RECID=57 STAMP=877619091
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_22\O1_MF_1_54_BMHNY7JJ_.ARC RECID=58 STAMP=877723256
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_24\O1_MF_1_55_BMN42Q9M_.ARC RECID=59 STAMP=877869832
deleted archived log
archived log file name=K:\FAST_RECOVERY_AREA\TESTDB\TESTDB\ARCHIVELOG\2015_04_25\O1_MF_1_56_BMQT88FO_.ARC RECID=60 STAMP=877990841
Deleted 60 objects
RMAN> exit
Recovery Manager complete.
C:\Users\oracle> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 10 14:21:29 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> startup
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2264616 bytes
Variable Size 6543114712 bytes
Database Buffers 4127195136 bytes
Redo Buffers 16900096 bytes
Database mounted.
Database opened.
Happy Learning...
No comments:
Post a Comment