Moving Database - urgent matter !!
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 !!!