Tit Bits

Tit Bits:

1. When you encounter the below error while opening the database
Error:
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...

Cause:

The last block written by the Oracle software was lost when the instance crashed.  On database startup, Oracle checks the last version of the block written to disk; if an old block is found, the ORA-600 [kcratr1_lostwrt] is raised.This has been seen more often on HP-UX than other platforms.

Solution:

sqlplus "/as sysdba"

startup mount

--Restore any archivelogs if not present
recover database

alter database mount

Workaround on HP-UX to avoid manual recover

Set _two_pass=FALSE in the init.ora then try to restart the instance. This will force (the less performant)single-pass recovery and so avoid the spurious assert  (which only executes on the 2-pass recovery codepath).

Reference : 351678.1 , 6443553.8 , 248718.1 Metalink note

Example:

$ sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.7.0 - Production on Fri Nov 1 14:10:28 2013

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.7.0 - Production

SQL> recover database;

Media recovery complete.

SQL> alter database open;

Database altered.

SQL>