- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-12 18:31:40
|
查看: 1321 |
回复: 0
昨天晚上10点左右,两台database停掉
系统能够登录
但是sqlplus后
没有反应
查看alertlog 错误信息如下
Thread 1 advanced to log sequence 720
Current log# 2 seq# 720 mem# 0: /u03/oradata/fkmps01/redo02.log
Wed May 16 18:27:51 2007
Thread 1 advanced to log sequence 721
Current log# 3 seq# 721 mem# 0: /u03/oradata/fkmps01/redo03.log
Wed May 16 19:33:11 2007
Starting control autobackup
Wed May 16 19:33:13 2007
Errors in file /u01/app/oracle/admin/fkmps01/udump/fkmps01_ora_9914.trc:
Wed May 16 19:33:13 2007
Errors in file /u01/app/oracle/admin/fkmps01/udump/fkmps01_ora_9914.trc:
Wed May 16 19:33:13 2007
Errors in file /u01/app/oracle/admin/fkmps01/udump/fkmps01_ora_9914.trc:
Control autobackup written to DISK device
handle '/u10/orabackup/fkmps01/control/c-2942228881-20070516-01'
Wed May 16 21:31:27 2007
Thread 1 advanced to log sequence 722
Current log# 1 seq# 722 mem# 0: /u03/oradata/fkmps01/redo01.log
Wed May 16 22:00:03 2007
GATHER_STATS_JOB encountered errors.Check the trace file.
Wed May 16 22:00:03 2007
Errors in file /u01/app/oracle/admin/fkmps01/bdump/fkmps01_j001_15775.trc:
查看trc文,信息如下件/u01/app/oracle/admin/fkmps01/bdump/fkmps01_j001_10163.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name: Linux
Node name: ZFKERPDB01
Release: 2.6.9-22.ELsmp
Version: #1 SMP Mon Sep 19 18:32:14 EDT 2005
Machine: i686
Instance name: fkmps01
Redo thread mounted by this instance: 1
Oracle process number: 23
Unix process pid: 10163, image: oracle@ZFKERPDB01 (J001)
*** ACTION NAME:(GATHER_STATS_JOB) 2007-05-17 22:00:04.464
*** MODULE NAME:(DBMS_SCHEDULER) 2007-05-17 22:00:04.464
*** SERVICE NAME:(SYS$USERS) 2007-05-17 22:00:04.464
*** SESSION ID:(177.62924) 2007-05-17 22:00:04.464
ORA-20001: "?U?PNL" is an invalid identifier
*** 2007-05-17 22:00:04.486
GATHER_STATS_JOB: GATHER_TABLE_STATS('"MPS"','"APS_PASS_TMP"','""', ...)
ORA-20001: "?U?PNL" is an invalid identifier
各位大大帮忙分析下
个人只是看出rman backup时controlfile备份有错误
但是备份错误是整个database停掉的原因吗?
还是别的部份错误
希望各位大大帮忙看下~~~
GATHER_STATS_JOB: GATHER_TABLE_STATS('"MPS"','"APS_PASS_TMP"','""', ...)
ORA-20001: "?U?PNL" is an invalid identifier
定时收集数据库统计信息的job好像出现了问题吧?
无效的标识符!
看看这两个trace文件:fkmps01_ora_9914.trc:
fkmps01_j001_15775.trc:
信息如下
fkmps01_ora_9914.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name: Linux
Node name: ZFKERPDB01
Release: 2.6.9-22.ELsmp
Version: #1 SMP Mon Sep 19 18:32:14 EDT 2005
Machine: i686
Instance name: fkmps01
Redo thread mounted by this instance: 1
Oracle process number: 27
Unix process pid: 9914, image: oraclefkmps01@ZFKERPDB01
*** 2007-05-16 19:33:13.881
*** ACTION NAME:(0000051 STARTED111) 2007-05-16 19:33:13.821
*** MODULE NAME:(backup incr datafile) 2007-05-16 19:33:13.821
*** SERVICE NAME:(fkmps01) 2007-05-16 19:33:13.821
*** SESSION ID:(199.44791) 2007-05-16 19:33:13.821
fkmps01_j001_15775.trc
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name: Linux
Node name: ZFKERPDB01
Release: 2.6.9-22.ELsmp
Version: #1 SMP Mon Sep 19 18:32:14 EDT 2005
Machine: i686
Instance name: fkmps01
Redo thread mounted by this instance: 1
Oracle process number: 23
Unix process pid: 15775, image: oracle@ZFKERPDB01 (J001)
*** ACTION NAME:(GATHER_STATS_JOB) 2007-05-16 22:00:03.915
*** MODULE NAME:(DBMS_SCHEDULER) 2007-05-16 22:00:03.915
*** SERVICE NAME:(SYS$USERS) 2007-05-16 22:00:03.915
*** SESSION ID:(195.21216) 2007-05-16 22:00:03.915
ORA-20001: "?U?PNL" is an invalid identifier
*** 2007-05-16 22:00:03.978
GATHER_STATS_JOB: GATHER_TABLE_STATS('"MPS"','"APS_PASS_TMP"','""', ...)
ORA-20001: "?U?PNL" is an invalid identifier
*** 2007-05-16 22:03:01.584
*** SERVICE NAME:(SYS$USERS) 2007-05-16 22:03:01.584
*** CLIENT ID:() 2007-05-16 22:03:01.584
*** SESSION ID:(195.21218) 2007-05-16 22:03:01.584
kwqicaclcur: Error 8103
Cursor Session Number : 183
Cursor Session Serial : 4293
Cursor Pin Number : 24585
error 8103 happened during job cache initialization
这些信息有什麽意义呢??
|
|