EXPERT RESPONSE
You can choose to only start the instance, rather than start both the instance and database on the Windows platform. Starting only the instance would allow you to connect internal and perform the necessary recovery tasks and procedures. After starting just the instance with the oradim utility from the DOS command prompt, set your ORACLE_SID as follows replacing ORCL with your SID:
set ORACLE_SID=ORCL
You should then be able to log into sqlplus as SYS and start the database in nomount mode:
sqlplus /nolog
connect / as sysdba
startup nomount;
For additional information on administering an Oracle 9.2 database on Windows, the Oracle9i Database Release 2 (9.2) Administrator's Guide for Windows is a good source of information.
|
