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,468 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
  • 2
2 Comments
 
LVL 47

Accepted Solution

by:
schwertner earned 250 total points
Comment Utility
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 47

Expert Comment

by:schwertner
Comment Utility
Thanks!

Did it  succeed?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to take different types of Oracle backups using RMAN.

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now