DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: urgent ... cannot open my db

  1. #1
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282

    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
    F.

  2. #2
    Join Date
    May 2001
    Posts
    736

    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.

    regards
    akhadar



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