Oracle Server 9i is returning "ORA-01033: ORACLE initialization or shutdown in progress" error message after hard drive upgrade

My server was running fine with Oracle Server 9i on Windows 2000 Server. Oracle installed on drive C and database files are located on drive E.

Yesterday I stopped oracle services,  backed up database files on drive E then I replaced drive E and restored the backup to the new drive E. But the server doesn't come up. every time I try to login I get thw error messgae "ORA-01033: ORACLE initialization or shutdown in progress". I removed the new drive and put back the old drive. But it still not working. my database is called "plines"

It is looking for a file name "REDO02.LOG" which doesn't exist even on the original database files on old drive. but "REDO01.LOG" does exist.

Here is dump file contects of my server :
==========================
Dump file c:\oracle\admin\plines\bdump\alert_plines.log
Fri Oct 31 12:47:16 2003
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Fri Oct 31 12:47:16 2003
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 50331648
  large_pool_size          = 8388608
  java_pool_size           = 33554432
  control_files            = E:\oracle\oradata\PLINES\CONTROL01.CTL, E:\oracle\oradata\PLINES\CONTROL02.CTL, E:\oracle\oradata\PLINES\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 25165824
  compatible               = 9.2.0.0.0
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = ARAMCO.COM.SA
  instance_name            = PLINES
  dispatchers              = (PROTOCOL=TCP) (SERVICE=PLINESXDB)
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\PLINES\bdump
  user_dump_dest           = C:\oracle\admin\PLINES\udump
  core_dump_dest           = C:\oracle\admin\PLINES\cdump
  sort_area_size           = 524288
  db_name                  = PLINES
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 25165824
  aq_tm_processes          = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Fri Oct 31 12:47:20 2003
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Oct 31 12:47:21 2003
alter database mount exclusive
Fri Oct 31 12:47:25 2003
Successful mount of redo thread 1, with mount id 2561636633.
Fri Oct 31 12:47:25 2003
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Oct 31 12:47:25 2003
alter database open
Fri Oct 31 12:47:27 2003
Errors in file c:\oracle\admin\plines\bdump\plines_lgwr_2044.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'E:\ORACLE\ORADATA\PLINES\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Fri Oct 31 12:47:28 2003
Errors in file c:\oracle\admin\plines\bdump\plines_lgwr_2044.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'E:\ORACLE\ORADATA\PLINES\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

ORA-313 signalled during: alter database open...
alsaeed_sAsked:
Who is Participating?
 
schwertnerCommented:
use
STARTUP DATABASE NOMOUNT
ALTER DATABASE MOUNT

The following statement adds a new group of redo logs to the database:
ALTER DATABASE
ADD LOGFILE ('E:\ORACLE\ORADATA\PLINES\REDO02.LOG') SIZE 500K;

You can also specify the number that identifies the group using the GROUP option:

ALTER DATABASE
ADD LOGFILE GROUP 10 ('E:\ORACLE\ORADATA\PLINES\REDO02.LOG') SIZE 500K;

After that try to open the database.
0
 
schwertnerCommented:
Thanks!

Did it  succeed?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.