While restarting my database it is able start database but it is failing for mounting and open database
file (dbfile). I got below error while starting database.
ORA-01172: recovery of thread 1 stuck at block 224 of file 3
ORA-01151: use media recovery to recover block, restore backup if needed
I have did below fix for this issues. and after that its working fine.
SQL> Recover datafile 3;
media recovery complete.
SQL> alter database open;
database altered.
file (dbfile). I got below error while starting database.
ORA-01172: recovery of thread 1 stuck at block 224 of file 3
ORA-01151: use media recovery to recover block, restore backup if needed
I have did below fix for this issues. and after that its working fine.
SQL> Recover datafile 3;
media recovery complete.
SQL> alter database open;
database altered.
i got the likely error and i have tried same but still giving this error:ORA-00283: recovery session canceled due to errors. i don't know what to do next.
ReplyDelete