Recover oracle database from error ORA-00333

To restore the oracle from ORA-00333: redo log error , you need to follow the below steps,

SQL> connect system

Enter password:

ERROR:

ORA-01033: ORACLE initializatio

Process ID: 0

Session ID: 0 Serial number: 0

ORA-00333: redo log read error block 767 count 7428

SQL>connect sys as sysdba

password

SQL> startup

SQL>select l.status, member from v$logfile inner join v$log l using (group#);

SQL>recover database using backup controlfile;

Enter and provide the current file path – /oracle/fast_recovery_area/redo01.log

SQL>alter database open resetlogs;