Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-12 18:31:40 | 查看: 1322| 回复: 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   

这些信息有什麽意义呢??


下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 16:55 , Processed in 0.048158 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569