Hello, everyone,
We have Oracle DB 9.2.0.8 installed on windows 2003.
Now we have an error in the alertlog:
Recovery of Online Redo Log: Thread 1 Group 3 Seq 10359 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\PMPOCHOP\REDO03.LOG
RECOVERY OF THREAD 1 STUCK AT BLOCK 424305 OF FILE 10
ORA-1172 signalled during: alter database open...
----------------------
The database was is NOARCHIVELOG mode.
--------------------
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 614015372 bytes
Fixed Size 455052 bytes
Variable Size 343932928 bytes
Database Buffers 268435456 bytes
Redo Buffers 1191936 bytes
SQL> alter database mount;
Database altered.
------------
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01172: recovery of thread 1 stuck at block 424305 of file 10
ORA-01151: use media recovery to recover block, restore backup if needed
--------
SQL> select * from v$recover_file;
no rows selected
-------------------------
SQL> COLUMN first_change# FORMAT 99999999999999999999
SQL> COLUMN next_change# FORMAT 99999999999999999999
SQL> select recid
2 , stamp
3 , sequence#
4 , first_change#
5 , next_change#
6 from v$log_history
7 where sequence# = ((select sequence# from v$log where STATUS='CURRENT') -1);
RECID STAMP SEQUENCE# FIRST_CHANGE# NEXT_CHANGE#
---------- ---------- ---------- --------------------- ---------------------
10358 943634589 10358 31107641847 31107875454
SQL> set linesize 150
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- --------------------- ----------
1 1 10357 104857600 1 NO INACTIVE 31105337566 10.05.2017
2 1 10358 104857600 1 NO INACTIVE 31107641847 10.05.2017
3 1 10359 104857600 1 NO CURRENT 31107875454 10.05.2017
------------
I ran CHKDSK against the appropriate NFS area and it was descovered that the file system does not have errors!
Could someone please advise on to the problem.