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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-14 18:41:51 | 查看: 1308| 回复: 0
Starting background process QMNC
QMNC started with pid=16, OS id=1507
Fri May  3 15:24:22 2013
Errors in file /export/home/oracle/admin/ARIC/bdump/aric_smon_1491.trc:
ORA-00600: internal error code, arguments: [5120], [8], [512], [25], [0], [], [], []
Fri May  3 15:24:23 2013
Completed: ALTER DATABASE OPEN
Fri May  3 15:24:24 2013
Non-fatal internal error happenned while SMON was doing temporary segment drop.
SMON encountered 3 out of maximum 100 non-fatal internal errors.
Fri May  3 15:24:25 2013
Errors in file /export/home/oracle/admin/ARIC/bdump/aric_smon_1491.trc:
ORA-00600: internal error code, arguments: [5120], [8], [512], [25], [0], [], [], []
Non-fatal internal error happenned while SMON was doing temporary segment drop.
SMON encountered 4 out of maximum 100 non-fatal internal errors.

之前这个库在导入表的时候也报了600错:

Completed: ALTER DATABASE OPEN
The value (30) of MAXTRANS parameter ignored.
Fri May  3 15:07:28 2013
Errors in file /export/home/oracle/admin/ARIC/udump/aric_ora_1415.trc:
ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []
Fri May  3 15:07:58 2013
Shutting down instance: further logons disabled
Fri May  3 15:08:00 2013
Stopping background process QMNC
Fri May  3 15:08:00 2013
Stopping background process CJQ0
Fri May  3 15:08:02 2013
Stopping background process MMNL
Fri May  3 15:08:03 2013
Stopping background process MMON
Fri May  3 15:08:04 2013
Shutting down instance (immediate)
第一个弄好了...第二个是在要导入分区表时,后台日志会抱这样的错,同时会抱这样的错::


UDI-00008: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2745
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3712




现在是不能导入分区表数据,一导后台就报错

Errors in file /export/home/oracle/admin/ARIC/udump/aric_ora_1580.trc:
ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []
The value (30) of MAXTRANS parameter ignored.
Fri May  3 17:04:24 2013
Errors in file /export/home/oracle/admin/ARIC/udump/aric_ora_1606.trc:
ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []


同时报:


bash-3.00$ impdp system/oracle directory=dump1  dumpfile=f_ticket_sls.130416.dmp   logfile=ticket2012.log   tables=f_ticket_sls:f_ticket_sls_p71      

UDI-00008: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2745
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3712
ORA-06512: at line 1

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

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

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

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

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

GMT+8, 2024-12-20 07:50 , Processed in 0.043774 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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