ORA-1113 signalled during: alter database "perd" open...
Oliver Üffing
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 ??
Vladimir M. Zakharychev
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 (b...@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....@vb-programmers.de> wrote in message
news:altcq9$ho0$04$1...@news.t-online.com...
Anton Buijs
during backup of the datafiles of the database?
If not: where the tablespaces in backup mode (requires the db to run in
archive log mode) during the backup?
If both where not the case: you did not made a proper backup of the database
and in fact you have a corrupt database now.
With the help of Oracle Technical Support you can get it up and running but
in an inconsistent state. The only thing you can do with that database is
make a full database export and remove it. Some data is lost but you don't
know what.
Then you can build a new database and run a full import.
IF this is the case...
I've seen this so many times on NT machines when I was working for a service
provider... if I had got a dollar each time, I could retire now......
Oliver Üffing <oliver....@vb-programmers.de> schreef in berichtnieuws
altcq9$ho0$04$1...@news.t-online.com...