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

When you made the backup of the NT server disk , was the database closed 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.ueffing_at_vb-programmers.de> schreef in berichtnieuws 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 - 17:15:20 CDT