(021) 29427411 ext. 12

    When I trying to extract data using Oracle Data Integrator, suddenly my laptop go ‘blue screen’, and when startup again, my oracle database doesn’ open, here is situation, and how to solve it:

    
    SQL> select name from v$database;
    
    NAME
    ———
    JTEK
    
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
    [503], [3], [56], [], [], [], [], [], [], []
    SQL> shutdown;
    ORA-01109: database not open
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup
    ORACLE instance started.
    
    Total System Global Area 1570009088 bytes
    Fixed Size 2176088 bytes
    Variable Size 1023413160 bytes
    Database Buffers 536870912 bytes
    Redo Buffers 7548928 bytes
    Database mounted.
    ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
    [503], [3], [56], [], [], [], [], [], [], []
    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
    [503], [3], [56], [], [], [], [], [], [], []
    SQL> show parameter control_files;
    
    NAME TYPE VALUE
    ———————————— ———– ——————————
    control_files string C:\ORACLE-EE\ORADATA\JTEK\CONT
    ROL01.CTL, C:\ORACLE-EE\FLASH_
    RECOVERY_AREA\JTEK\CONTROL02.C
    TL
    SQL> select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=
    b.group# and b.status=’CURRENT’
    2 ;
    
    MEMBER
    ——————————————————————————–
    
    GROUP# STATUS
    ———- —————-
    C:\ORACLE-EE\ORADATA\JTEK\REDO02.LOG
    2 CURRENT
    SQL> shutdown abort;
    ORACLE instance shut down.
    SQL> startup mount;
    ORACLE instance started.
    
    Total System Global Area 1570009088 bytes
    Fixed Size 2176088 bytes
    Variable Size 1023413160 bytes
    Database Buffers 536870912 bytes
    Redo Buffers 7548928 bytes
    Database mounted.
    SQL> recover database using backup controlfile until cancel;
    ORA-00279: change 5038568 generated at 09/26/2013 22:20:59 needed for thread 1
    ORA-00289: suggestion :
    C:\ORACLE-EE\FLASH_RECOVERY_AREA\JTEK\ARCHIVELOG\2013_09_26\O1_MF_1_503_%U_.ARC
    ORA-00280: change 5038568 for thread 1 is in sequence #503
    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    C:\ORACLE-EE\ORADATA\JTEK\REDO02.LOG
    Log applied.
    Media recovery complete.
    SQL> alter database open resetlogs;
    
    Database altered.
    
    SQL>
    
    

    No Comment

    You can post first response comment.

    Leave A Comment

    Please enter your name. Please enter an valid email address. Please enter a message.