Monthly Archives: Ноябрь 2013

Wierd Things with Oracle :-)

Few weeks ago one of my clients had met a really wierd thing: there were 2 logfiles with CURRENT status:

SQL> select GROUP#,SEQUENCE#,BYTES,MEMBERS,STATUS from v$log
  2  ;
    GROUP#  SEQUENCE#      BYTES    MEMBERS STATUS
     ———- ———- ———- ———- —————-
         1       5651   52428800          2 INACTIVE
         3       5653   52428800          2 CURRENT
         2       5652   52428800          2 CURRENT
Here is the error from alertlog:
ORA-00600: internal error code, arguments: [3705], [1], [3], [2], [8], [], [], []

We had to perform point-in-time recovery up to 5652 sequence and DB felt much better 🙂

%d такие блоггеры, как: