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