As per Oracle information, ORA-00333 is caused by an IO error while reading the log described in the accompanying error. The resolution is to restore accessibility to the file, or get another copy of the file.
First run following command:
1. SQL> Conn sys as sysdba
Pass:
2. SQL> Shutdown immediate;
3. SQL> startup mount;
4. SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
5. SQL> Shutdown immediate;
6. SQL> alter database open resetlogs;
Here , you will get error. Then try next command.
7. SQL>recover database until cancel;
For any promopt error or anything, just press ENTER ( I followed) .
8. SQL> alter database open resetlogs;
9. SQL> Shutdown immediate;
10. SQL> Startup
After database open, please take backup first then try following.
11. SQL> Shutdown immediate;
12. SQL> startup mount;
13. SQL> alter system set "_allow_resetlogs_corruption"=false scope=spfile;
14. SQL> Shutdown immediate;
15. SQL> startup
