ORA-1113 signalled during: alter database "perd" open...

From: Oliver Üffing <oliver.ueffing_at_vb-programmers.de>
Date: Fri, 13 Sep 2002 21:04:00 +0200
Message-ID: <altcq9$ho0$04$1@news.t-online.com>

Hi I have a big Problem with our Oracle 8.0.5 Database Server.

A few days ago we had to reinstall the NT 4 Server after a SCSI HDD Crash. With a copy of the old NT we restored the complete System. Restarting the Oracle Services looks fine, but connecting to Oracle with svrmgr results in the following Error Message: -Oracle not available-

The AlertLog for the DB:

Dump file I:\oradata\PERD\strace\perdALRT.LOG Fri Sep 13 19:11:44 2002
ORACLE V8.0.5.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V4.0, OS V5.101, CPU type 586 Starting up ORACLE RDBMS Version: 8.0.5.0.0. System parameters with non-default values:

  processes                = 100
  shared_pool_size         = 9000000
  control_files            = I:\oradata\PERD\database\ctl1perd.ora,
I:\oradata\PERD\database\ctl2perd.ora
  db_block_buffers         = 2000
  db_block_size            = 2048
  compatible               = 8.0.5.0.0
  log_archive_start        = TRUE
  log_archive_buffers      = 4
  log_archive_buffer_size  = 127
  log_archive_dest         = I:\oradata\database\archive
  log_archive_format       = arc%S.%T
  log_buffer               = 32768
  log_checkpoint_interval  = 8000
  log_checkpoint_timeout   = 0
  db_files                 = 1020
  db_file_multiblock_read_count= 16
  dml_locks                = 200

  sequence_cache_entries = 30
  sequence_cache_hash_buckets= 23

  remote_login_passwordfile= SHARED
  sort_area_size           = 65536
  db_name                  = perd
  open_cursors             = 150
  background_dump_dest     = I:\oradata\PERD\strace
  user_dump_dest           = I:\oradata\PERD\utrace
  max_dump_file_size       = 10240
PMON started with pid=2
DBW0 started with pid=3
ARCH started with pid=4
LGWR started with pid=5
CKPT started with pid=6

SMON started with pid=7
RECO started with pid=8
Fri Sep 13 19:11:44 2002
alter database "perd" mount exclusive
Fri Sep 13 19:11:48 2002
Successful mount of redo thread 1, with mount id 898916340. Fri Sep 13 19:11:48 2002
Database mounted in Exclusive Mode.
Completed: alter database "perd" mount exclusive Fri Sep 13 19:11:49 2002
alter database "perd" open
ORA-1113 signalled during: alter database "perd" open...

Whats the Problem here ?? Received on Fri Sep 13 2002 - 14:04:00 CDT