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:
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
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;

Leave a Reply

Your email address will not be published. Required fields are marked *