| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: BAARF - true life story
With minimum downtime: Data Guard.
I'vo done this with 90 GB from one end of the world to another, with
minimum downtime (1,5 hour, mostly spent on application-stuff), and with
several aother (bigger/smaller) databases within the datacenter.
Set up the standby database on the new site, using RMAN or vanilla hot backup. Get the standby database in managed recovery mode. At some moment you perform a gracefull switchover, and continue working on the new site.
Pre-requisites: Oracle must be on the same patchlevel on both ends, and OS must be the same: so no Windows/Linux mix or whatever.
Best regards,
Carel-Jan Engel
===
If you think education is expensive, try ignorance. (Derek Bok)
===
On Sat, 2004-08-07 at 21:18, solbeach_at_cox.net wrote:
> 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
> -----------------------------------------------------------------
-- 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 - 15:37:10 CDT
 |
 |