Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Moving Database - urgent matter !!

user586004May 13 2008 — edited May 16 2008
Hello,

I have a very urgent issue.

I have been running Oracle Database 10.1.0.5 Enterprise Edition on a Linux Red Hat Enterprise 4.
My system had 4 disks in the RAID 5 parity configuration and 2 disks for archive logs in straight mirror configuration.

Believe it or not, 2 days ago 2 out of 4 disks in the RAID 5 failed and 1 out 2 disks in the mirror configuration failed. No idea why, no idea how, bottom line is that the database is down.
Since I don't have Oracle Support, (waiting for the PO to move through and Admin people to arrange everything) I need to figure out how to recover data in the meantime.

I have a backup (using Networker) from a night before the crash.

I have installed a completely new database on another server (version 10.2.0.3) and am trying to move all of the control files and DBF files there and import them but I am getting this error::

SQL*Loader: Release 10.2.0.1.0 - Production on Tue May 13 15:37:21 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL*Loader-350: Syntax error at line 1.
Illegal combination of non-alphanumeric characters


I am really running out of ideas what to do or try.


p.s. not to mention that I tried to push one of the 2 failed disks back into RAID 5 so that I can try to recover other disk but resulted in no INCON errors.
My database would not start so I would get errors bellow and every time I would try to recover files from the tape that are problematic I would get a new error:


ORA-01113: File 2 needs media recovery
followed by

- ORA-01115: IO error reading block from file 2
- ORA-02072: File I/O error

followed by

- ORA-01122 database file failed verification check
- ORA-01207 file is more recent then controlfile - old control file

error, followed by "finally"

ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []

At this point, I really don't know what else to do. If anyone has ANY idea or suggestion please help !!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2008
Added on May 13 2008
8 comments
1,035 views