Oracle Database Discussions

Uses: Oracle 9i, Windows XP, 40GB Disk space, 1GB Ram;

The terminal above serves as my test DB. I use this terminal to import dump file from Production Server every day. I tried to open the Database by using GUI Enterprise Console > Configuration but I got this error below:

ORA-01113: file 2 needs media recovery
ORA-0110: data file 2: c:\oracle\oradata\orcl\undotbs01.dbf

I did research prior to this, but scenario is quite different. As I said earlier, I only need to up the database and data loss is irrelevant.

I tried the commands after login as Sys as Sysdba, but I'm getting the following error.

SQL*Plus: Release 9.2.0.6.0 - Production on Wed Feb 6 19:13:19 2013

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 487662076 bytes
Fixed Size 455164 bytes
Variable Size 385875968 bytes
Database Buffers 100663296 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 108807 change 116801561 time 02/06/2013
07:53:24
ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\ORCL\REDO01.LOG'


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: 'C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF'


SQL> show parameter background

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string C:\oracle\admin\ORCL\bdump
SQL> select * from v$log
2 ;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 10781 104857600 1 NO ACTIVE
116801019 06-FEB-13

2 1 10782 104857600 1 NO CURRENT
116802439 06-FEB-13

3 1 10780 104857600 1 NO INACTIVE
116800243 06-FEB-13


SQL>

I'm a novice in DBA admin setups. All I need is to up the Database and resume my operation of importing dump. Data loss is not relevant.