oracle 版本 11.2.0
SQL> startup
ORACLE instance started.
Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 356518272 bytes
Database Buffers 58720256 bytes
Redo Buffers 6094848 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 4545
Session ID: 1 Serial number: 5
----------------------------------------------------------------
1:查看trace文件 (位置:http://blog.csdn.net/yfb8530/article/details/8997374)
/u01/app/oracle/diag/rdbms/orcl/ORCL
2:按trace记录的原因操作
[oracle@rhel flashback]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 31 00:12:52 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup mount
Oracle instance started
database mounted
Total System Global Area 422670336 bytes
Fixed Size 1336960 bytes
Variable Size 356518272 bytes
Database Buffers 58720256 bytes
Redo Buffers 6094848 bytes
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
RMAN> alter database open;
database opened