Reference documents:
ORA-01033: Workaround
Solution of ORA-01172 disk bad block after database power-down
--attempt to connect to database PrjdbC:\Documents andSettings\Administrator>Sqlplus test/Test@prjdbSQL*Plus:release11.2.0.1.0Production onMon June9 -: at: , theCopyright (c)1982, ., Oracle. Allrights reserved.--Error ORA01033Error:ora-01033: ORACLE???????? Process ID:0Session ID:0Serial Number:0--find out what the root cause of ORA-01033 is, log in with AdministratorC:\Documents andSettings\Administrator>SQLPLUS SYS/SYS asSysdbasql*Plus:release11.2.0.1.0Production onMon June9 -: -: to theCopyright (c)1982, ., Oracle. Allrights reserved. Connected to: OracleDatabase11g Enterprise Edition Release11.2.0.1.0 -Production withThe partitioning, OLAP, Data Mining and RealApplication Testing Options--To close a DB instanceSql> SHUTDOWNORA-01109:Database not OpenDatabasedismounted. ORACLE instance shut down.--try to start the database, and if the startup fails it will error, so you can find the source of the problem. Sql>Startuporacle instance started. Total System Global Area778387456bytesfixed Size1374808bytesvariable Size469763496bytesDatabaseBuffers301989888Bytesredo Buffers5259264bytesDatabasemounted.--the root of the problem is ORA-01172 and ORA-01151.ORA-01172: Recovery ofThread1Stuck at block651 of file -ORA-01151: UseMedia recovery toRecover block,Restore Backup ifneeded--to see what file 90 is, this step is not requiredSql> Select file#,name fromV$datafilewhere file#= -; FILE# NAME -D:\ORACLE\ORADATA\PRJDB\TS_HIS18. DBF--Recover FileSql>Recover DataFile -; Media recovery complete. SQL> ExitDisconnected fromOracleDatabase11g Enterprise Edition Release11.2.0.1.0 -Production withThe partitioning, OLAP, Data Mining and RealApplication Testing Options--try connecting prjdb againC:\Documents andSettings\Administrator>Sqlplus test/Test@prjdbSQL*Plus:release11.2.0.1.0Production onMon June9 -: $: - theCopyright (c)1982, ., Oracle. Allrights reserved.--still failError:ora-01033: ORACLE???????? Process ID:0Session ID:0Serial Number:0--Repeat the previous actionC:\Documents andSettings\Administrator>SQLPLUS SYS/SYS asSysdbasql*Plus:release11.2.0.1.0Production onMon June9 -: $: $ theCopyright (c)1982, ., Oracle. Allrights reserved. Connected to: OracleDatabase11g Enterprise Edition Release11.2.0.1.0 -Production withThe partitioning, OLAP, Data Mining and RealApplication Testing Optionssql> SelectOpen_mode fromv$Database; Open_mode--------------------Mountedsql> Alter Database Open;Alter Database Open*ERROR at line1:--There is also a problem with file 7 found.ORA-01172: Recovery ofThread1Stuck at block89361 of file 7ORA-01151: UseMedia recovery toRecover block,Restore Backup ifneeded--Recover file 7Sql>Recover DataFile7; Media recovery complete.--start the database againSql> Alter Database Open;--database started successfullyDatabasealtered. SQL> ExitDisconnected fromOracleDatabase11g Enterprise Edition Release11.2.0.1.0 -Production withThe partitioning, OLAP, Data Mining and RealApplication Testing Options--Try connecting againC:\Documents andSettings\Administrator>Sqlplus test/Test@prjdbSQL*Plus:release11.2.0.1.0Production onMon June9 -: -: - theCopyright (c)1982, ., Oracle. Allrights reserved. Connected to: OracleDatabase11g Enterprise Edition Release11.2.0.1.0 -Production withThe partitioning, OLAP, Data Mining and RealApplication Testing Optionssql> --The connection was successful.