【问题】
接到告警，发现extract进程ABENDED
查看进程日志如下：
***********************************************************************
** Run Time Messages **
***********************************************************************
2024-08-25 13:22:11 INFO OGG-01517 Position of first record processed Log Number: 79079
Record Offset: 67072343, Aug 24, 2024 12:32:26 AM.
2024-08-25 13:22:11 INFO OGG-06507 MAP (TABLE) resolved (entry pub_......
>>阅读全文<<
【报错】
接到告警电话，查看alert 日志报错如下：
Thu Jun 20 22:17:11 2024
Errors in file /oracle/diag/rdbms/coredb/coredb/trace/coredb_j003_23800.trc (incident=288071):
ORA-04030: out of process memory when trying to allocate 432 bytes (kxs-heap-c,kprbalo temp memory)
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
End automatic SQL Tuning Advisor run for special tuning task “SYS_AUTO_SQL_TUNING_TASK......
>>阅读全文<<
最近用exp导出数据的时候报了很多EXP-00091: Exporting questionable statistics的错误。
【问题现象】
exp system/123456 OWNER=rs2 file=20160823_rs2_17_8.dmp log=20160823_rs2_17_8.log
...
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ......
>>阅读全文<<
前两天遇到一个问题，在删除一个主键的之后，插入重复的数据报错ORA-00001唯一性约束冲突
test@TESTDB> insert into t1 select * from dba_objects where rownum < 100;
insert into t1 select * from dba_objects where rownum < 100
*
ERROR at line 1:
ORA-00001: unique constraint (TEST.PK_T1_OBJECT_ID) violated
查询T1表主键及索引，发现主键索引仍然存在
test@TESTDB> select * from dba_cons_columns where table_name='T1';
no rows selected
test@TESTDB> select INDEX_OWNER,INDEX_NA......
>>阅读全文<<
[box style=”blue”]APPLIES TO:[/box]
OS：Windows 2008 64bit
DB：ORACLE 11.2.0.3
[box style=”blue”]SYMPTOMS[/box]
通过EXPDP导出全库，查看log发现如下报错：
ORA-31693: 表数据对象 “AUDIT_GD”.”PUB_LOBFILE” 无法加载/卸载并且被跳过, 错误如下:
ORA-02354: 导出/导入数据时出错
ORA-01555: 快照过旧: 回退段号 7 (名称为 “_SYSSMU7_93985497$”) 过小
已成功加载/卸载了主表 “EXP_DBA”.”JOB_EXP_FULL_2″
[box style=......
>>阅读全文<<
