步骤摘要：
1.启动报错ORA-03113
2.查看alert日志查找原因
3.根据实际情况采取合理的措施，这里我们先增加闪回区大小，把库启动起来
4.制定对应的归档日志删除策略
1.启动报错ORA-03113
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期六 2月 28 13:56:44 2015
Copyright (c) 1982, 2013, Oracle.? All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 3206836224 bytes
Fixed Size? ? ? ? ? ? ? ? ? 2257520 bytes
Variable Size? ? ? ? ? ? 2365590928 bytes
Database Buffers? ? ? ? ? 822083584 bytes
Redo Buffers? ? ? ? ? ? ? 16904192 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: 通信通道的文件结尾
进程 ID: 13501
会话 ID: 853 序列号: 5
SQL>
2.查看alert日志查找原因
Sat Feb 28 13:56:52 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 8
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
? ? NUMA status: non-NUMA system
? ? cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
? ? Grp 0:
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =249
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /opt/app/oracle/product/11.2.0.4/dbhome_1
System name:? ? Linux
Node name:? ? ? JJFAB01
Release:? ? ? ? 2.6.32-358.el6.x86_64
Version:? ? ? ? #1 SMP Tue Jan 29 11:47:41 EST 2013
Machine:? ? ? ? x86_64
VM name:? ? ? ? Xen Version: 4.1 (PVM)
Using parameter settings in server-side spfile /opt/app/oracle/product/11.2.0.4/dbhome_1/dbs/spfileJJFAB.ora
System parameters with non-default values:
? processes? ? ? ? ? ? ? ? = 1500
? sessions? ? ? ? ? ? ? ? = 2272
? memory_target? ? ? ? ? ? = 3G
? control_files? ? ? ? ? ? = "/opt/oradata/gxwj/control01.ctl"
? control_files? ? ? ? ? ? = "/opt/app/oracle/fast_recovery_area/gxwj/control02.ctl"
? db_block_size? ? ? ? ? ? = 8192
? compatible? ? ? ? ? ? ? = "11.2.0.0.0"
? db_recovery_file_dest? ? = "/opt/app/oracle/fast_recovery_area"
? db_recovery_file_dest_size= 4122M
? undo_tablespace? ? ? ? ? = "UNDOTBS1"
? remote_login_passwordfile= "EXCLUSIVE"
? db_domain? ? ? ? ? ? ? ? = ""
? dispatchers? ? ? ? ? ? ? = "(PROTOCOL=TCP) (SERVICE=gxwjXDB)"
? audit_file_dest? ? ? ? ? = "/opt/app/oracle/admin/gxwj/adump"
? audit_trail? ? ? ? ? ? ? = "DB"
? db_name? ? ? ? ? ? ? ? ? = "JJFAB"
? open_cursors? ? ? ? ? ? = 300
? diagnostic_dest? ? ? ? ? = "/opt/app/oracle"
Sat Feb 28 13:56:54 2015
PMON started with pid=2, OS id=13461
Sat Feb 28 13:56:54 2015
PSP0 started with pid=3, OS id=13463
Sat Feb 28 13:56:55 2015
VKTM started with pid=4, OS id=13465 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Sat Feb 28 13:56:55 2015
GEN0 started with pid=5, OS id=13469
Sat Feb 28 13:56:55 2015
DIAG started with pid=6, OS id=13471
Sat Feb 28 13:56:55 2015
DBRM started with pid=7, OS id=13473
Sat Feb 28 13:56:55 2015
DIA0 started with pid=8, OS id=13475
Sat Feb 28 13:56:55 2015
MMAN started with pid=9, OS id=13477
Sat Feb 28 13:56:55 2015
DBW0 started with pid=10, OS id=13479
Sat Feb 28 13:56:55 2015
LGWR started with pid=11, OS id=13481
Sat Feb 28 13:56:55 2015
CKPT started with pid=12, OS id=13483
Sat Feb 28 13:56:55 2015
SMON started with pid=13, OS id=13485
Sat Feb 28 13:56:55 2015
RECO started with pid=14, OS id=13487
Sat Feb 28 13:56:55 2015
MMON started with pid=15, OS id=134