urgent ... cannot open my db
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: urgent ... cannot open my db

  1. #1
    Join Date
    Dec 2001

    Linux Red Hat 7.2 Oracle 9i 9.0.2

    I cant open my database, here are the errors:

    Errors in file /home/dba/oradata/linux/udump/linux_ora_1475.trc: ORA-01403: no data found Error 1403 happened during db open, shutting down database USER: terminating instance due to error 1403 Instance terminated by USER, pid = 1475 ORA-1092 signalled during: ALTER DATABASE OPEN...

    then in linux_ora_1475.trc:

    *** SESSION ID:(7.3) 2002-09-02 21:13:19.739 Thread checkpoint rba:0x00000f.00000002.0010 scn:0x0000.00010f0e Cache low rba is 0x00000f.00000003.0000 Use incremental checkpoint on-disk rba Thread 1 recovery from rba:0x00000f.00000003.0000 scn:0x0000.00010f0f ----- Redo read statistics for thread 1 ----- Read rate (ASYNC) = 29Kb/sec => 58 blocks in 1s Read buffer = 8192Kb (16384 blocks) Longest record = 0Kb Record moves = 0/76 (0%) ---------------------------------------------- *** 2002-09-02 21:13:19.894 KCRA: start recovery claims for 12 data blocks *** 2002-09-02 21:13:20.013 KCRA: buffers claimed = 12/12, eliminated = 0 ORA-01403: no data found

    What the hell is that?
    Thanks in Advance

  2. #2
    Join Date
    May 2001

    What is your type of shutdown operation last applied on your database?.

    You are not able to open the database because it seems the data is corrupted or some of the datafiles may be missing.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width