系统是redhat 6.5,之前没有过任何预兆即出现了以下问题。
今日发现整个数据库非常缓慢,遂准备重启服务器解决问题。
但是执行shutdown immediate没有任何效果。同时sql语句执行缓慢,小弟并非专业oracle数据库运维,只是接了个活,所以想着速战速决,于是执行了shutdown abort。成功。
之后再启动时就出现了无法启动的问题。下面是错误日志。希望各位能够帮助我
Tue Apr 21 14:16:54 2015
Starting ORACLE instance (normal)
Tue Apr 21 14:17:27 2015
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =134
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Tue Apr 21 14:17:43 2015
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/db_1/dbs/spfileorc11g.ora
System parameters with non-default values:
processes = 800
sessions = 1224
memory_target = 3200M
control_files = "/u01/app/oracle/oradata/orc11g/control01.ctl"
control_files = "/u01/app/oracle/flash_recovery_area/orc11g/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=/u01/arch"
db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area"
db_recovery_file_dest_size= 2G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orc11gXDB)"
audit_file_dest = "/u01/app/oracle/admin/orc11g/adump"
audit_trail = "DB"
db_name = "orc11g"
open_cursors = 1000
diagnostic_dest = "/u01/app/oracle"
Tue Apr 21 14:17:47 2015
PMON started with pid=2, OS id=3335
Tue Apr 21 14:17:47 2015
VKTM started with pid=3, OS id=3337
VKTM running at (100ms) precision
Tue Apr 21 14:17:47 2015
GEN0 started with pid=4, OS id=3341
Tue Apr 21 14:17:47 2015
DIAG started with pid=5, OS id=3343
Tue Apr 21 14:17:47 2015
DBRM started with pid=6, OS id=3345
Tue Apr 21 14:17:47 2015
PSP0 started with pid=7, OS id=3347
Tue Apr 21 14:17:47 2015
DIA0 started with pid=8, OS id=3349
Tue Apr 21 14:17:47 2015
MMAN started with pid=9, OS id=3351
Tue Apr 21 14:17:47 2015
DBW0 started with pid=10, OS id=3353
Tue Apr 21 14:17:47 2015
LGWR started with pid=11, OS id=3355
Tue Apr 21 14:17:47 2015
CKPT started with pid=12, OS id=3357
Tue Apr 21 14:17:47 2015
SMON started with pid=13, OS id=3359
Tue Apr 21 14:17:47 2015
RECO started with pid=14, OS id=3361
Tue Apr 21 14:17:47 2015
MMON started with pid=15, OS id=3363
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Apr 21 14:17:47 2015
MMNL started with pid=16, OS id=3365
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
Tue Apr 21 14:18:02 2015
ALTER DATABASE MOUNT
Tue Apr 21 14:18:11 2015
Successful mount of redo thread 1, with mount id 598884954
Database mounted in Exclusive Mode
Lost write protection disabled
Tue Apr 21 14:18:22 2015
Completed: ALTER DATABASE MOUNT
Tue Apr 21 14:18:25 2015
ALTER DATABASE OPEN
Tue Apr 21 14:18:44 2015
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Started redo scan
Tue Apr 21 14:26:02 2015
Completed redo scan
read 1587084 KB redo, 46815 data blocks need recovery
Tue Apr 21 14:33:21 2015
Errors in file /u01/app/oracle/diag/rdbms/orc11g/orc11g/trace/orc11g_m000_26444.trc:
ORA-01155: the database is being opened, closed, mounted or dismounted
orc11g_m000_12676.trc文件内容如下。
Trace file /u01/app/oracle/diag/rdbms/orc11g/orc11g/trace/orc11g_m000_12676.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: localhost.localdomain
Release: 2.6.18-128.el5
Version: #1 SMP Wed Dec 17 11:41:38 EST 2008
Machine: x86_64
Instance name: orc11g
Redo thread mounted by this instance: 1
Oracle process number: 32
Unix process pid: 12676, image: oracle@localhost.localdomain (M000)
*** 2015-04-21 14:47:52.744
*** SESSION ID
5.9727) 2015-04-21 14:47:52.745
*** CLIENT ID
) 2015-04-21 14:47:52.745
*** SERVICE NAME
) 2015-04-21 14:47:52.745
*** MODULE NAME
MMON_SLAVE) 2015-04-21 14:47:52.745
*** ACTION NAME
Monitor FRA Space) 2015-04-21 14:47:52.745
ORA-01155: the database is being opened, closed, mounted or dismounted