Shulou(Shulou.com)06/01 Report--

Environment: RHEL 5.8

Found that the database startup starts the Times

ORA-03113: the end of the file for the communication channel

Process ID: 6988

Answer ID:191 Serial number: 3

[oracle@localhost ~] $cd $ORACLE_ Base [oracle @ localhost oracle] $cd diag/rdbms/oracle/oracle/trace/ [oracle@localhost trace] $ll-rt | tail[ oracle @ localhost trace] $vim oracle_ora_13430.trc

[oracle@localhost trace] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Thursday February 25 13:49:56 2016Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to an idle instance.SQL > startup mount;ORACLE instance started.Total System Global Area 2471931904 bytesFixed Size 2230872 bytesVariable Size 1560282536 bytesDatabase Buffers 889192448 bytesRedo Buffers 20226048 bytesDatabase mounted.SQL > select NAME | |'| | SPACE_LIMIT | |'| | SPACE_USED | |'| | SPACE_RECLAIMABLE | |'| NUMBER_OF_FILES from v$recovery_file_dest | NAME | |'|'| SPACE_LIMIT | |'| | SPACE_USED | |'| | SPACE_RECLAIMABLE | |'|'| NUMBER_OF_----/u01/app/oracle/fast_recovery_area | 6180 | 0 | 0 | 0SQL > SQL > alter database clear unarchived logfile group 1 / / there may be errors when executing this line. If an error is reported, change 1 to 2 or 3 directly and then execute 1SQL > alter database clear unarchived logfile group 2 position SQL > alter database clear unarchived logfile group 1 leading database altered.SQL > commit;Commit complete.SQL > shutdown immediate;SQL > startup;ORACLE instance started.Total System Global Area 2471931904 bytesFixed Size 2230872 bytesVariable Size 1560282536 bytesDatabase Buffers 889192448 bytesRedo Buffers 20226048 bytesDatabase mounted.Database opened.SQL > select status from vantage instanceism STATUSUV OPENSQL > exit

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.