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

Home -> Community -> Mailing Lists -> Oracle-L -> RAID installation & hopefully no recovery problem

RAID installation & hopefully no recovery problem

From: William B Ferguson <wbfergus_at_usgs.gov>
Date: Wed, 3 Aug 2005 08:51:56 -0600
Message-ID: <OF5A287CD6.1957423D-ON06257052.00504EFC@usgs.gov>

Slightly off topic, but I have an Oracle server in serious trouble.

I'm running 10.1.0.4 on a Windows 2003 server, and RAID 5.

I just received in some larger hard drives, as the existing ones were to small and the flashaback recovery area kept filling up and halting the database. I think because of this (I really don't know, but the timing is there), Windows started getting hosed. Oracle is about the only thing still running problem-free (sort of) on the server. Even the backup software is hosed. I can't install or re-install or even 'repair' any of the Windows components, as the Windows installer (and probably the registry) are hosed and hangs halfway through.

I've done a data-pump export through the web-base OEM of all the non-system schemas and copied them to another machine. I've also exported my HTML DB workspaces and applications, etc. and copied those to another machine.

I still have this lingering doubt though, so I want to play it safe.

If I mark the existing drives (so I know which one went where) and install the new drives, reload Windows and Oracle and everything else, then all the patches and updates, and then import all the data back in and THEN discover that either I forgot something or something else is wrong, can I replace the new drives with the old ones and at least get everything back to where I am right now? Or is there going to be some system 'thing' that will wind up corrupting the old drives once they're re-installed?

I really leery about doing this without a good tape backup, but I think I've done about all I can, with most of the software unresponsive. Before the exports, I turned off the flashback and archiving, as with a new install of all the Oracle software, I didn't see a need to worry about copying those. After the exports I also stopped the listener, so no more database access could occur.

Luckily the system is still in development, so access is limited and sparse anyway.

Have I missed anything? Thanks.



Bill Ferguson
U.S. Geological Survey - Minerals Information Team PO Box 25046, MS-750
Denver, Colorado 80225
Voice (303)236-8747 ext. 321 Fax (303)236-4208

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 03 2005 - 09:52:22 CDT

Original text of this message

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