ORA-00353: log corruption near block change time – 11.2.0.3

Posted 1 CommentPosted in 11gR2, GoldenGate, ORA-00353, redo log

Recently I came across “ORA-00353: log corruption near block change time” error. Errors in file /oracle/app/diag/rdbms/test/test/trace/test_ms00_54284.trc (incident=1490189): ORA-00353: log corruption near block change time ORA-00353: log corruption near block 4631374 change 263470473806052 time 04/16/2015 06:53:16 ORA-00312: online log 43 thread 3: ‘+REDO02/test/onlinelog/group_43.258.875922665’ ORA-00312: online log 43 thread 3: ‘+REDO01/test/onlinelog/group_43.258.875922633’ Incident details in: /oracle/app/diag/rdbms/test/test/incident/incdir_1490189/test_ms00_54284_i1490189.trc Thu Apr […]

ORA-01628: max # extents (32765) reached for rollback segment _SYSSMUxxx

Posted 3 CommentsPosted in 11gR2, ORA Error, undo

Recently I came across “ORA-01628: max # extents (32765)” error. The database had resumable_timeout parameter set I received page for a session in resumable state. Looking into the alert log showed statement in resumable session ‘User USER_E3(375), Session 9028, Instance 1’ was suspended due to ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU375_247595031$ […]

ORA-17629 ORA-20079

Posted 1 CommentPosted in 11gR2, ORA Error, resync

Yesterday I received page for ” ORA-17629: Cannot connect to the remote database server”  reported in Primary Database alert log. Fri Apr 10 06:47:41 2015 Errors in file /oracle/app/diag/rdbms/testdb/testdb/trace/testdb_ora_161991.trc: ORA-17627: ORA-17629: Cannot connect to the remote database server Errors in file /oracle/app/diag/rdbms/testdb/testdb/trace/testdb_ora_161991.trc: ORA-17629: Cannot connect to the remote database server ORA-17627: ORA-17629: Cannot connect to […]

ORA-00600: [ktbdchk1: bad dscn]

Posted 6 CommentsPosted in 11gR1, 11gR2, ORa-600, Oracle

Last week I had performed switchover activity of database on version 11.2.0.3 The switchover was performed using dgmgrl “swicthover to standby” command. After sometime we started receiving “ORA-00600: [ktbdchk1: bad dscn]” on the primary database. Tue Dec 16 10:33:26 2014 Errors in file /ora_software/diag/rdbms/db02_dbv/dbv/trace/db02_ora_16271.trc (incident=434103): ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], […]

Upgrading to 11.2.0.4 – Dictionary View Performing Poor

Posted Leave a commentPosted in 11gR2, Oracle, Upgrade

Just a quick blog post on things you might see after upgrading to 11.2.0.4. We recently upgraded database from 11.2.0.3 to 11.2.0.4 and query on some data dictionary views ran too slow. 1. Performace of query on dba_free_space degraded 2. Performance of query involving dba_segments is slow DEV01> select ceil(sum(b.bytes)/1024/1024) b from sys.dba_free_space b; Elapsed: […]

Purging SYSAUX

Posted 1 CommentPosted in 10gR2, 11gR2, Oracle, SYSAUX

In continuation to my previous post “SYSAUX Growing Rapidly” , here i wanted to present the second method of purging sysaux. Basically i tried to perform the steps as mentioned in previous post and drop_snapshot_range was taking too long (> 24hrs) and still running on test db.Again WRH$_ACTIVE_SESSION_HISTORY was in top of the list occupying […]