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=ORCLYou 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.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I'm getting errors while installing the Database Configuration Assistant. Continue Reading