Primary on FileSystem and Standby on ASM

For one of the client, standby server went down. We had another standby server which was kept down for more than a month. Decision was taken to start the server and apply incremental SCN based backup on the standby database. The standby was on ASM and the Primary on filesystem.Incremental backup was started from the …

Advertisement

ORA-00600: [ktbdchk1: bad dscn]

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], [], [], …

ORA-00600 – [kfnsInstanceReg00]

An interesting case of ORA-600 🙂 I was paged for standby lag and started looking into the issue. The db version was 11.1.0.7.0 version. Standby was lagging behind by 36 archives SQL> @mrp INST_ID PROCESS STATUS THREAD# SEQUENCE# BLOCK# DELAY_MINS ---------- --------- ------------ ---------- ---------- ---------- ---------- 1 MRP0 WAIT_FOR_LOG 1 568330 0 0 INST_ID …