ORA-01033 and ORA-01172 of Oracle power-off restart

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.