-
编辑 删除
ORA-31640: unable to open dump file ORA-19505 ORA-27037
环境: 11.2.0.4 Rac双节点 ,准备在单节点下导入报错Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATAORA-31693: Table data object "GS"."JC_SALESMAN_DATA" failed to load/unload and is being skipped due to error:ORA-31640: unable to open dump file "/home/oracle/dump/xxxx.dmp" for readORA-19505: fa...
-
编辑 删除
ORA-00600: internal error code, arguments: [kokiasg1]及ORA-04063错误
原因:通过语句批量动态删除用户对象,估计是删除了sys用户下一些对象,直接导致数据库宕掉ORA-04098: trigger 'SYS.XDB_PI_TRIG' is invalid and failed re-validationORA-04063: package body "SYS.DBMS_LOGSTDBY" has errorsThu Mar 03 18:04:53 2016Errors in file /u01/app/oracle/diag/rdbms/jin/jin/trace/jin_cjq...
-
编辑 删除
ORA-10458,ORA-01196,ORA-01110处理
事情起因:是因为主备dg机器要换新位置,运维直接关机搬服务器修改ip地址,系统起来后,备库启动报错.ORA-10458: standby database requires recoveryORA-01196: file 1 is inconsistent due to a failed media recovery sessionORA-01110: data file 1: '/u01/app/oracle/oradata/rong/system01.dbf'原因:日志的scn跟控...
-
编辑 删除
MRP进程无法启动,ORA-19909错误,ORA-01194,ORA-00328,gap等问题综合解决
环境:Oracle11.2.0.4 Rac 一主两备模式第一部分: 修改incarnation前因:前几天在备2上面做Flashback下的Failover恢复实验,但影响了备1下面的adg恢复,错误如下备1的alert日志如下:Fri Nov 06 17:01:37 2015Warning:Recovery target destination is in a sibling branchofthe ...
-
编辑 删除
某运营商网管故障报告(2013年写的)
1. 故障现象：[BEGIN] 2013/2/2 6:16:26-ef |grep ora_
-
编辑 删除
asm实例自动dismount导致rac一个节点宕机
asm日志<br />/u01/app/grid/diag/asm/+asm/+ASM1/trace<br /><br /><br />Thu Jul 30 02:10:46 2015<br />WARNING: Waited 15 secs for write IO to PST disk 0 in group 1.<br />WARNING: Waited 15 secs for write IO to PST disk 1 in group 1.<br />WARNING: Waited 15 secs for write IO to PST disk 2 in gro...
