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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: BAARF - true life story

RE: BAARF - true life story

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Mon, 9 Aug 2004 11:06:50 -0400
Message-ID: <009b01c47e22$7f327ea0$8459699f@vttaxnet.tax.state.vt.us>


I would use the rman duplicate command. I used it to move my DB's to a new OS and it works like a charm. Just check the docs for how to do it and use the script provided in OH/rdbms/demo/case4.rcv as a template.

Caveat: 8i or later.

HTH,
Ruth

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of solbeach_at_cox.net Sent: Saturday, August 07, 2004 3:19 PM
To: oracle-l_at_freelists.org
Subject: BAARF - true life story

I just joined this site.
Less than 6 weeks ago they had a problem with one of their Oracle DBs. It seems it was running on a RAID-5 volume. A disk died. The hot spare got automagically included, but nobody was notified or noticed this happening. Then 2nd disk failed. It was some time after this that errors started and one of the *DBF had gotten corrupted. They have been able to reload the records which had been sitting on the bad block. So we think that from a logical (data) standpoint the problem has been resolved. The DBV utility no longer reports any bad blocks.

We now have to move this whole database (178GB) to a new system, with minimal downtime.

We have worries, doubts & concerns about just doing an OS copy from the old to the new system. Can there still be 1 or more bad blocks in the tablespace that just are not being used now? If the OS (Linux) has tagged & remapped bad blocks, will an OS copy allow them to be "left behind"? We doubt we have a big enough downtime window to allow for either an expotr/import to RMAN duplicate operation.

What would YOU do given this history & requirements?



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Mon Aug 09 2004 - 10:03:42 CDT

Original text of this message

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