HELP!

From: Szymon Budys <szymb_at_polbox.com>
Date: Fri, 8 Jun 2001 12:36:42 +0200
Message-ID: <9fq9nj$18p$1@news.tpi.pl>

Hi, we have seriuos problem with Oracle 8.0.5

We made mistake and to the server was sent instruction:

ALTER DATABASE DATAFILE 'T_NPG' RESIZE 102400M We didn't then received any mesage from server. After many hours server was restarted by admin and now database is mount but not open. The file T_NPG is now 3.3 GB and disk is full. Here is orc1alrt.log:

Dump file G:\orant\rdbms80\trace\orc1ALRT.LOG Fri Jun 08 07:22:29 2001
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            = G:\orant\database\ctl1orc1.ora,
F:\orant_log\ctl2orc1.ora
  db_block_buffers         = 3000
  db_block_size            = 2048
  compatible               = 8.0.5.0.0
  log_buffer               = 32768
  log_checkpoint_interval  = 8000
  log_checkpoint_timeout   = 1800
  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                  = orc1
  background_dump_dest     = G:\orant\rdbms80\trace
  user_dump_dest           = G:\orant\rdbms80\trace
  max_dump_file_size       = 10240
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
Fri Jun 08 07:22:29 2001
alter database "orc1" mount exclusive
Fri Jun 08 07:22:34 2001
Successful mount of redo thread 1, with mount id 1063750649. Fri Jun 08 07:22:34 2001
Database mounted in Exclusive Mode.
Completed: alter database "orc1" mount exclusive Fri Jun 08 07:22:34 2001
alter database "orc1" open
ORA-1122 signalled during: alter database "orc1" open...

Please help me. What can I do to restore previous status of database?

--
regrads
Szymon Budys

Received on Fri Jun 08 2001 - 05:36:42 CDT