启动Oracle11R2数据库，提示ORA-03113: 通信通道的文件结尾的解决方案

SQL> startup;
ORA-01031: insufficient privileges
SQL> connect /as sysdba;
已连接到空闲例程。
SQL> startup;
ORACLE 例程已经启动。

Total System Global Area  780824576 bytes
Fixed Size                  2179816 bytes
Variable Size             587205912 bytes
Database Buffers          184549376 bytes
Redo Buffers                6889472 bytes
数据库装载完毕。
ORA-03113: 通信通道的文件结尾
进程 ID: 3232
会话 ID: 9 序列号: 3

 

1.找到trace文件，查看日志:

SQL> show parameter dump;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      e:\app\administrator\diag\rdbm
                                                 s\yms\yms\trace
core_dump_dest                       string      e:\app\administrator\diag\rdbm
                                                 s\yms\yms\cdump
max_dump_file_size                   string      unlimited
shadow_core_dump                     string      none
user_dump_dest                       string      e:\app\administrator\diag\rdbm
                                                 s\yms\yms\trace

 

------------------------------------------------------------------------------------------------------------

查看alter_yms.log

 Errors in file e:\app\administrator\diag\rdbms\yms\yms\trace\yms_m000_3812.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4102029312 bytes is 99.15% used, and has 34836992 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
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.
************************************************************************
Completed: alter database backup controlfile to trace as 'c:/ctl.txt'
Mon Oct 29 11:14:22 2012
Starting background process SMCO
Mon Oct 29 11:14:22 2012
SMCO started with pid=26, OS id=2344

显示恢复区域不足：

1.停止归档.

  startup mount

 alter database noarchivelog;

 

2. 查看归档参数信息：

 archive  log list

 数据库日志模式            存档模式
自动存档             启用
存档终点            E:\app\Administrator\oradata\archive
最早的联机日志序列     11
下一个存档日志序列   13
当前日志序列           13

 

3.检查删除归档内容：

CROSSCHECK BACKUPSET;
DELETE NOPROMPT OBSOLETE;
crosscheck archivelog all;
DELETE NOPROMPT OBSOLETE;

 

4.更改归档路径：

alter system set log_archive_dest_1='location=E:\app\Administrator\oradata\archive
' scope=spfile sid='*';

 

5.重启数据库。