Solved

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

Posted on 2003-10-31
2
2,478 Views
Last Modified: 2007-12-19
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...
0
Comment
Question by:alsaeed_s
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 250 total points
ID: 9656895
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
 
LVL 48

Expert Comment

by:schwertner
ID: 9657000
Thanks!

Did it  succeed?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question