Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1113 signalled during: alter database "perd" open...

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

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Fri, 13 Sep 2002 23:12:10 +0400
Message-ID: <altdat$m02$1@babylon.agtel.net>

ORA-01113 Cause: an attempt was made to open a datafile that is in need of media recovery. Action: First apply media recovery to the datafile identified in the message,

   then retry the operation.

This means you need to recover datafiles identified in the error message.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Oliver Ãœffing" <oliver.ueffing_at_vb-programmers.de> wrote in message
news:altcq9$ho0$04$1_at_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:12:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US