Skip to Content
Recover lost datafile without valid backup
ORA-01172:recovery of thread 1 stuck at block xxxx of file x

To solve
1) Open SqlPlus from Oracle Bin folder, login as sys/zzz as sysdba
2) Since the database is not open, you can only query on fixed tables/Views
3) Query on v$datafile for the file name in the error message

If the error is “ORA-01172:recovery of thread 1 stuck at block 1241 of file 3”,
then Select name from v$datafile where file#=3

4) Recover datafile name_from_the_above_select
5) If file is recovered, then try

Alter database open

6) In my case, I got some weird ora-6000 [4194], So I did a shutdown and startup force, which resovled my issue
7) Shutdown immediate
8) Startup force

====

sqlplus connect as sysdba or sys
shutdown immediate
startup open
select name from v$datafile where file#=2
recover datafile 2
alter database open
shutdown immediate
startup force

Check the status of Oracle and connectivity from SAP
R3trans -d

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply