PROBLEM:
---------------
SQL> startup
ORACLE instance started.
Total System Global Area 2.6724E+10 bytes
Fixed Size 2195216 bytes
Variable Size 4160749808 bytes
Database Buffers 2.2549E+10 bytes
Redo Buffers 12173312 bytes
ORA-03113: end-of-file on communication channel
Process ID: 3949
Session ID: 394 Serial number: 1
There is some error in alertlog like below:
SUCCESS: diskgroup DATAGRP was mounted
ERROR: failed to establish dependency between database NECO and diskgroup resource ora.DATAGRP.dg
USER (ospid: 3174): terminating the instance
System state dump requested by (instance=1, osid=3174), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/neco/NECO/trace/CLDS_diag_3100.trc
Dumping diagnostic data in directory=[cdmp_20140723101552], requested by (instance=1, osid=3174), summary=[abnormal instance terminati
SOLUTION:
----------------
Disk corruption may cause this problem.ORA-03113: end-of-file on communication channel says
control file is corrupted.You have to create a new control file,then recover database.
controlfile createscript:
-------------------------
CREATE CONTROLFILE REUSE DATABASE "NECO" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 4672
LOGFILE
GROUP 1 '+REDOGRP/NECO/onlinelog/group_1.256.839147011' SIZE 50M,
GROUP 2 '+REDOGRP/NECO/onlinelog/group_2.257.839147017' SIZE 50M,
GROUP 3 '+REDOGRP/NECO/onlinelog/group_3.258.839147023' SIZE 50M,
GROUP 4 '+REDOGRP/NECO/onlinelog/group_4.259.839147027' SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'+DATAGRP/NECO/datafile/tallydata.368.838770799',
'+DATAGRP/NECO/datafile/tallydata.383.838817089',
'+DATAGRP/NECO/datafile/system.347.838758259',
'+DATAGRP/NECO/datafile/tallydata2.291.838895197',
'+DATAGRP/NECO/datafile/tallyindex.317.838735277',
'+DATAGRP/NECO/datafile/tallydata2.378.838790455',
'+DATAGRP/NECO/datafile/tallyindex.387.838829347',
'+DATAGRP/NECO/datafile/tallydata.306.838920789',
'+DATAGRP/NECO/datafile/tallydata.380.838804317',
'+DATAGRP/NECO/datafile/tallydata.311.838907659',
'+DATAGRP/NECO/datafile/tallydata.307.838916277',
'+DATAGRP/NECO/datafile/tallyindex.334.838749141',
'+DATAGRP/NECO/datafile/tallyindex.323.838739397',
'+DATAGRP/NECO/datafile/tallyindex.335.838750441',
'+DATAGRP/NECO/datafile/tallyindex.328.838743599',
'+DATAGRP/NECO/datafile/tallyindex.384.838821257',
'+DATAGRP/NECO/datafile/tallydata.350.838758689',
'+DATAGRP/NECO/datafile/tallydata.362.838766739',
'+DATAGRP/NECO/datafile/tallydata.330.838745965',
'+DATAGRP/NECO/datafile/tallydata.382.838812911',
'+DATAGRP/NECO/datafile/tallyindex.329.838745417',
'+DATAGRP/NECO/datafile/tallydata.357.838762425',
'+DATAGRP/NECO/datafile/tallydata.381.838808627',
'+DATAGRP/NECO/datafile/tallydata.360.838764305',
'+DATAGRP/NECO/datafile/tallydata.342.838755839',
'+DATAGRP/NECO/datafile/tallydata.370.838772947',
'+DATAGRP/NECO/datafile/tallydata.336.838751643',
'+DATAGRP/NECO/datafile/tallyindex.388.838832087',
'+REDOGRP/NECO/onlinelog/group_1.256.839147011',
'+REDOGRP/NECO/onlinelog/group_2.257.839147017',
'+REDOGRP/NECO/onlinelog/group_3.258.839147023',
'+REDOGRP/NECO/onlinelog/group_4.259.839147027',
'+DATAGRP/NECO/datafile/tallydata.368.838770799',
'+DATAGRP/NECO/datafile/tallydata.383.838817089',
'+DATAGRP/NECO/datafile/system.347.838758259',
'+DATAGRP/NECO/datafile/tallydata2.291.838895197',
'+DATAGRP/NECO/datafile/tallyindex.317.838735277',
'+DATAGRP/NECO/datafile/tallydata2.378.838790455',
'+DATAGRP/NECO/datafile/tallyindex.387.838829347',
'+DATAGRP/NECO/datafile/tallydata.306.838920789',
'+DATAGRP/NECO/datafile/tallydata.380.838804317',
'+DATAGRP/NECO/datafile/tallydata.311.838907659',
'+DATAGRP/NECO/datafile/tallydata.307.838916277',
'+DATAGRP/NECO/datafile/tallyindex.334.838749141',
'+DATAGRP/NECO/datafile/tallyindex.323.838739397',
'+DATAGRP/NECO/datafile/tallyindex.335.838750441',
'+DATAGRP/NECO/datafile/tallyindex.328.838743599',
'+DATAGRP/NECO/datafile/tallyindex.384.838821257',
'+DATAGRP/NECO/datafile/tallydata.350.838758689',
'+DATAGRP/NECO/datafile/tallydata.362.838766739',
'+DATAGRP/NECO/datafile/tallydata.330.838745965',
'+DATAGRP/NECO/datafile/tallydata.382.838812911',
'+DATAGRP/NECO/datafile/tallyindex.329.838745417',
'+DATAGRP/NECO/datafile/tallydata.357.838762425',
'+DATAGRP/NECO/datafile/tallydata.381.838808627',
'+DATAGRP/NECO/datafile/tallydata.360.838764305',
'+DATAGRP/NECO/datafile/tallydata.342.838755839',
'+DATAGRP/NECO/datafile/tallydata.370.838772947',
'+DATAGRP/NECO/datafile/tallydata.336.838751643',
'+DATAGRP/NECO/datafile/tallyindex.388.838832087',
'+DATAGRP/NECO/datafile/tallyindex.385.838823995',
'+DATAGRP/NECO/datafile/tallyindex.379.838796839',
'+DATAGRP/NECO/datafile/tallyindex.305.838925223',
'+DATAGRP/NECO/datafile/tallydata2.366.838769445',
'+DATAGRP/NECO/datafile/tallydata2.339.838753799',
'+DATAGRP/NECO/datafile/tallydata2.367.838770603',
'+DATAGRP/NECO/datafile/tallydata2.369.838771833',
'+DATAGRP/NECO/datafile/tallydata2.361.838765457',
'+DATAGRP/NECO/datafile/tallydata2.338.838752373',
'+DATAGRP/NECO/datafile/tallydata2.377.838786567',
'+DATAGRP/NECO/datafile/tallydata2.363.838766741',
'+DATAGRP/NECO/datafile/tallydata2.364.838768029',
'+DATAGRP/NECO/datafile/tallydata2.374.838780685',
'+DATAGRP/NECO/datafile/tallydata2.359.838764227',
'+DATAGRP/NECO/datafile/tallydata2.356.838761713',
'+DATAGRP/NECO/datafile/tallydata2.358.838762987',
'+DATAGRP/NECO/datafile/tallydata2.331.838747175',
'+DATAGRP/NECO/datafile/tallydata2.355.838760409',
'+DATAGRP/NECO/datafile/tallydata2.353.838759083',
'+DATAGRP/NECO/datafile/sysaux.346.838757989',
'+DATAGRP/NECO/datafile/tallyindex.376.838783507',
'+DATAGRP/NECO/datafile/tallydata.332.838747455',
'+DATAGRP/NECO/datafile/tallydata.371.838775063',
'+DATAGRP/NECO/datafile/tallydata.316.838899197',
'+DATAGRP/NECO/datafile/tallyindex.373.838777679',
'+DATAGRP/NECO/datafile/tallyindex.389.838834545',
'+DATAGRP/NECO/datafile/tallydata.375.838781803',
'+DATAGRP/NECO/datafile/tallydata.326.838743023',
'+DATAGRP/NECO/datafile/tallydata.337.838752037',
'+DATAGRP/NECO/datafile/tallydata.318.838735285',
'+DATAGRP/NECO/datafile/tallyindex.385.838823995',
'+DATAGRP/NECO/datafile/tallyindex.379.838796839',
'+DATAGRP/NECO/datafile/tallyindex.305.838925223',
'+DATAGRP/NECO/datafile/tallydata2.366.838769445',
'+DATAGRP/NECO/datafile/tallydata2.339.838753799',
'+DATAGRP/NECO/datafile/tallydata2.367.838770603',
'+DATAGRP/NECO/datafile/tallydata2.369.838771833',
'+DATAGRP/NECO/datafile/tallydata2.361.838765457',
'+DATAGRP/NECO/datafile/tallydata2.338.838752373',
'+DATAGRP/NECO/datafile/tallydata2.377.838786567',
'+DATAGRP/NECO/datafile/tallydata2.363.838766741',
'+DATAGRP/NECO/datafile/tallydata2.364.838768029',
'+DATAGRP/NECO/datafile/tallydata2.374.838780685',
'+DATAGRP/NECO/datafile/tallydata2.359.838764227',
'+DATAGRP/NECO/datafile/tallydata2.356.838761713',
'+DATAGRP/NECO/datafile/tallydata2.358.838762987',
'+DATAGRP/NECO/datafile/tallydata2.331.838747175',
'+DATAGRP/NECO/datafile/tallydata2.355.838760409',
'+DATAGRP/NECO/datafile/tallydata2.353.838759083',
'+DATAGRP/NECO/datafile/sysaux.346.838757989',
'+DATAGRP/NECO/datafile/tallyindex.376.838783507',
'+DATAGRP/NECO/datafile/tallydata.332.838747455',
'+DATAGRP/NECO/datafile/tallydata.371.838775063',
'+DATAGRP/NECO/datafile/tallydata.316.838899197',
'+DATAGRP/NECO/datafile/tallyindex.373.838777679',
'+DATAGRP/NECO/datafile/tallyindex.389.838834545',
'+DATAGRP/NECO/datafile/tallydata.375.838781803',
'+DATAGRP/NECO/datafile/tallydata.326.838743023',
'+DATAGRP/NECO/datafile/tallydata.337.838752037',
'+DATAGRP/NECO/datafile/tallydata.318.838735285',
'+DATAGRP/NECO/datafile/tallydata.372.838777337',
'+DATAGRP/NECO/datafile/tallydata.386.838826931',
'+DATAGRP/NECO/datafile/tallydata.324.838740235',
'+DATAGRP/NECO/datafile/tallydata.365.838768555',
'+DATAGRP/NECO/datafile/undotbs01.320.838737503',
'+DATAGRP/NECO/datafile/tallyindex.340.838755209',
'+DATAGRP/NECO/datafile/tallyindex.321.838737563',
'+DATAGRP/NECO/datafile/tallyindex.333.838748519',
'+DATAGRP/NECO/datafile/tallyindex.341.838755235',
'+DATAGRP/NECO/datafile/tallyindex.325.838741799',
'+DATAGRP/NECO/datafile/tallydata.310.838912207',
'+DATAGRP/NECO/datafile/tallydata.319.838735317',
'+DATAGRP/NECO/datafile/tallydata.322.838739287',
'+DATAGRP/NECO/datafile/tallydata.327.838743271',
'+DATAGRP/NECO/datafile/tallydata.354.838760067',
'+DATAGRP/NECO/datafile/users.349.838758669',
'+DATAGRP/NECO/datafile/users.348.838758485',
'+DATAGRP/NECO/datafile/users.352.838758961',
'+DATAGRP/NECO/datafile/users.345.838757925',
'+DATAGRP/NECO/datafile/users.351.838758821',
'+DATAGRP/NECO/datafile/sysaux.343.838757443',
'+DATAGRP/NECO/tempfile/tmp.302.839147045',
'+DATAGRP/NECO/datafile/system.344.838757777',
'+DATAGRP/NECO/tempfile/tmp.303.839147045',
'+DATAGRP/NECO/tempfile/tmp.304.839147045',
'+DATAGRP/NECO/datafile/tallydata.372.838777337',
'+DATAGRP/NECO/datafile/tallydata.386.838826931',
'+DATAGRP/NECO/datafile/tallydata.324.838740235',
'+DATAGRP/NECO/datafile/tallydata.365.838768555',
'+DATAGRP/NECO/datafile/undotbs01.320.838737503',
'+DATAGRP/NECO/datafile/tallyindex.340.838755209',
'+DATAGRP/NECO/datafile/tallyindex.321.838737563',
'+DATAGRP/NECO/datafile/tallyindex.333.838748519',
'+DATAGRP/NECO/datafile/tallyindex.341.838755235',
'+DATAGRP/NECO/datafile/tallyindex.325.838741799',
'+DATAGRP/NECO/datafile/tallydata.310.838912207',
'+DATAGRP/NECO/datafile/tallydata.319.838735317',
'+DATAGRP/NECO/datafile/tallydata.322.838739287',
'+DATAGRP/NECO/datafile/tallydata.327.838743271',
'+DATAGRP/NECO/datafile/tallydata.354.838760067',
'+DATAGRP/NECO/datafile/users.349.838758669',
'+DATAGRP/NECO/datafile/users.348.838758485',
'+DATAGRP/NECO/datafile/users.352.838758961',
'+DATAGRP/NECO/datafile/users.345.838757925',
'+DATAGRP/NECO/datafile/users.351.838758821',
'+DATAGRP/NECO/datafile/sysaux.343.838757443',
'+DATAGRP/NECO/tempfile/tmp.302.839147045',
'+DATAGRP/NECO/datafile/system.344.838757777',
'+DATAGRP/NECO/tempfile/tmp.303.839147045',
'+DATAGRP/NECO/tempfile/tmp.304.839147045',
'+DATA/NECO/datafile/users.305.809473127',
'+DATA/NECO/datafile/users.371.809473293',
'+DATA/NECO/datafile/users.353.809473459',
'+DATA/NECO/datafile/users.331.809472961',
'+DATA/NECO/datafile/users.326.809472415',
'+DATA/NECO/datafile/system.369.809472751',
'+DATA/NECO/datafile/system.327.809472579',
'+DATA/NECO/datafile/sysaux.355.809474375',
'+DATA/NECO/datafile/sysaux.354.809474607',
'+DATAGRP/NECO/datafile/tallydata2.271.836786191',
'+DATA/NECO/datafile/users.305.809473127',
'+DATA/NECO/datafile/users.371.809473293',
'+DATA/NECO/datafile/users.353.809473459',
'+DATA/NECO/datafile/users.331.809472961',
'+DATA/NECO/datafile/users.326.809472415',
'+DATA/NECO/datafile/system.369.809472751',
'+DATA/NECO/datafile/system.327.809472579',
'+DATA/NECO/datafile/sysaux.355.809474375',
'+DATA/NECO/datafile/sysaux.354.809474607',
'+DATAGRP/NECO/datafile/tallydata2.286.836787443',
'+DATA/NECO/datafile/tallydata2.363.809467175',
'+DATA/NECO/datafile/tallydata2.350.809470127',
'+DATA/NECO/datafile/tallydata2.315.809462873',
'+DATA/NECO/datafile/tallydata2.365.809467949',
'+DATA/NECO/datafile/tallydata2.311.809442363',
'+DATA/NECO/datafile/tallydata2.352.809469377',
'+DATA/NECO/datafile/tallydata2.290.809465579',
'+DATA/NECO/datafile/tallydata2.336.809476667',
'+DATA/NECO/datafile/tallydata2.281.809453891',
'+DATA/NECO/datafile/tallydata2.363.809467175',
'+DATA/NECO/datafile/tallydata2.350.809470127',
'+DATA/NECO/datafile/tallydata2.315.809462873',
'+DATA/NECO/datafile/tallydata2.365.809467949',
'+DATA/NECO/datafile/tallydata2.311.809442363',
'+DATA/NECO/datafile/tallydata2.352.809469377',
'+DATA/NECO/datafile/tallydata2.290.809465579',
'+DATA/NECO/datafile/tallydata2.336.809476667',
'+DATA/NECO/datafile/tallydata2.281.809453891',
'+DATA/NECO/datafile/tallydata2.272.809372123',
'+DATA/NECO/datafile/tallydata2.293.809466373',
'+DATA/NECO/datafile/tallydata2.356.809473615',
'+DATA/NECO/datafile/tallydata2.303.809454673',
'+DATA/NECO/datafile/tallydata2.287.809474821',
'+DATA/NECO/datafile/tallydata2.288.809468575',
'+DATA/NECO/datafile/tallydata2.338.809477163',
'+DATA/NECO/datafile/tallydata2.282.809416029',
'+DATA/NECO/datafile/tallydata2.351.809406465',
'+DATA/NECO/datafile/tallydata2.272.809372123',
'+DATA/NECO/datafile/tallydata2.293.809466373',
'+DATA/NECO/datafile/tallydata2.356.809473615',
'+DATA/NECO/datafile/tallydata2.303.809454673',
'+DATA/NECO/datafile/tallydata2.287.809474821',
'+DATA/NECO/datafile/tallydata2.288.809468575',
'+DATA/NECO/datafile/tallydata2.338.809477163',
'+DATA/NECO/datafile/tallydata2.282.809416029',
'+DATA/NECO/datafile/tallydata2.351.809406465',
'+DATAGRP/NECO/datafile/tallydata.302.836788737',
'+DATAGRP/NECO/datafile/tallydata.309.836789679',
'+DATA/NECO/datafile/tallydata.372.809392015',
'+DATA/NECO/datafile/tallydata.320.809385291',
'+DATA/NECO/datafile/tallydata.314.809379349',
'+DATA/NECO/datafile/tallydata.372.809392015',
'+DATA/NECO/datafile/tallydata.320.809385291',
'+DATA/NECO/datafile/tallydata.314.809379349',
'+DATA/NECO/datafile/tallydata.341.809377385',
'+DATA/NECO/datafile/tallydata.319.809375471',
'+DATA/NECO/datafile/tallydata.344.809408511',
'+DATA/NECO/datafile/tallydata.313.809446213',
'+DATA/NECO/datafile/tallydata.330.809425719',
'+DATA/NECO/datafile/tallydata.277.809417955',
'+DATA/NECO/datafile/tallydata.312.809447331',
'+DATA/NECO/datafile/tallydata.297.809459681',
'+DATA/NECO/datafile/tallydata.278.809470861',
'+DATA/NECO/datafile/tallydata.298.809410365',
'+DATA/NECO/datafile/tallydata.328.809412213',
'+DATA/NECO/datafile/tallydata.273.809423209',
'+DATA/NECO/datafile/tallydata.361.809387311',
'+DATA/NECO/datafile/tallydata.325.809383291',
'+DATA/NECO/datafile/tallydata.359.809389475',
'+DATA/NECO/datafile/tallydata.300.809394295',
'+DATA/NECO/datafile/tallydata.337.809381313',
'+DATA/NECO/datafile/tallydata.348.809396549',
'+DATA/NECO/datafile/tallydata.306.809428235',
'+DATA/NECO/datafile/tallydata.285.809398871',
'+DATA/NECO/datafile/tallydata.333.809437859',
'+DATA/NECO/datafile/tallydata.346.809448611',
'+DATA/NECO/datafile/tallydata.341.809377385',
'+DATA/NECO/datafile/tallydata.319.809375471',
'+DATA/NECO/datafile/tallydata.344.809408511',
'+DATA/NECO/datafile/tallydata.313.809446213',
'+DATA/NECO/datafile/tallydata.330.809425719',
'+DATA/NECO/datafile/tallydata.277.809417955',
'+DATA/NECO/datafile/tallydata.312.809447331',
'+DATA/NECO/datafile/tallydata.297.809459681',
'+DATA/NECO/datafile/tallydata.278.809470861',
'+DATA/NECO/datafile/tallydata.298.809410365',
'+DATA/NECO/datafile/tallydata.328.809412213',
'+DATA/NECO/datafile/tallydata.273.809423209',
'+DATA/NECO/datafile/tallydata.361.809387311',
'+DATA/NECO/datafile/tallydata.325.809383291',
'+DATA/NECO/datafile/tallydata.359.809389475',
'+DATA/NECO/datafile/tallydata.300.809394295',
'+DATA/NECO/datafile/tallydata.337.809381313',
'+DATA/NECO/datafile/tallydata.348.809396549',
'+DATA/NECO/datafile/tallydata.306.809428235',
'+DATA/NECO/datafile/tallydata.285.809398871',
'+DATA/NECO/datafile/tallydata.333.809437859',
'+DATA/NECO/datafile/tallydata.346.809448611',
'+DATA/NECO/datafile/tallydata.323.809451249',
'+DATA/NECO/datafile/tallydata.347.809400857',
'+DATA/NECO/datafile/tallydata.342.809402791',
'+DATA/NECO/datafile/tallydata.343.809404637',
'+DATA/NECO/datafile/tallydata.275.809414025',
'+DATA/NECO/datafile/tallydata.368.809476303',
'+DATA/NECO/datafile/tallydata.322.809476515',
'+DATAGRP/NECO/datafile/tallyindex.330.836792089',
'+DATA/NECO/datafile/tallydata.323.809451249',
'+DATA/NECO/datafile/tallydata.347.809400857',
'+DATA/NECO/datafile/tallydata.342.809402791',
'+DATA/NECO/datafile/tallydata.343.809404637',
'+DATA/NECO/datafile/tallydata.275.809414025',
'+DATA/NECO/datafile/tallydata.368.809476303',
'+DATA/NECO/datafile/tallydata.322.809476515',
'+DATA/NECO/datafile/tallyindex.283.809457563',
'+DATA/NECO/datafile/tallyindex.316.809443179',
'+DATA/NECO/datafile/tallyindex.284.809455409',
'+DATA/NECO/datafile/tallyindex.276.809456425',
'+DATA/NECO/datafile/tallyindex.310.809436189',
'+DATA/NECO/datafile/tallyindex.335.809427027',
'+DATA/NECO/datafile/tallyindex.274.809429529',
'+DATA/NECO/datafile/tallyindex.292.809373759',
'+DATA/NECO/datafile/tallyindex.362.809432081',
'+DATA/NECO/datafile/tallyindex.366.809443983',
'+DATA/NECO/datafile/tallyindex.329.809424359',
'+DATA/NECO/datafile/tallyindex.286.809421735',
'+DATA/NECO/datafile/tallyindex.299.809458645',
'+DATA/NECO/datafile/tallyindex.360.809449983',
'+DATA/NECO/datafile/tallyindex.308.809441313',
'+DATA/NECO/datafile/tallyindex.279.809460731',
'+DATA/NECO/datafile/tallyindex.345.809419871',
'+DATA/NECO/datafile/tallyindex.280.809430777',
'+DATA/NECO/datafile/tallyindex.283.809457563',
'+DATA/NECO/datafile/tallyindex.316.809443179',
'+DATA/NECO/datafile/tallyindex.284.809455409',
'+DATA/NECO/datafile/tallyindex.276.809456425',
'+DATA/NECO/datafile/tallyindex.310.809436189',
'+DATA/NECO/datafile/tallyindex.335.809427027',
'+DATA/NECO/datafile/tallyindex.274.809429529',
'+DATA/NECO/datafile/tallyindex.292.809373759',
'+DATA/NECO/datafile/tallyindex.362.809432081',
'+DATA/NECO/datafile/tallyindex.366.809443983',
'+DATA/NECO/datafile/tallyindex.329.809424359',
'+DATA/NECO/datafile/tallyindex.286.809421735',
'+DATA/NECO/datafile/tallyindex.299.809458645',
'+DATA/NECO/datafile/tallyindex.360.809449983',
'+DATA/NECO/datafile/tallyindex.308.809441313',
'+DATA/NECO/datafile/tallyindex.279.809460731',
'+DATA/NECO/datafile/tallyindex.345.809419871',
'+DATA/NECO/datafile/tallyindex.370.809452599',
'+DATA/NECO/datafile/tallyindex.296.809444939',
'+DATA/NECO/datafile/tallyindex.370.809452599',
'+DATA/NECO/datafile/tallyindex.296.809444939'
CHARACTER SET AL32UTF8
;
Hiç yorum yok:
Yorum Gönder