Re: Dataguard

From: Thomas Roach <troach_at_gmail.com>
Date: Thu, 4 Feb 2010 14:21:47 -0500
Message-ID: <b86ffce61002041121r3901671fx7bb83da70eef1257_at_mail.gmail.com>

So when they move the SAN it will be back online and your Luns will be mapped the same?

You have a few options. If they move it piece by piece, and if you are on ASM, why not rebalance ASM online?

Alter diskgroup DATA add disk 'disk1','disk2'.... drop disk 'old_disk1','old_disk2'....

Or if they want to do a complete shutdown, then find out what SCN the datafiles are at before shutdown. Then take an incremental backup from your production DB as of that SCN and recreate your standby controlfile and then restore the incremental backup on your standby and then restart the apply process. It really depends on how much time is needed.

Now if they want to completely shut the SAN off, and wipe out the disks and restart, then you will need to take a complete backup of your production DB and create a new standby controlfile and essentially restore it on the standby and resetup data guard.

I prefer option 1 if it is an option since ASM has nothing to do with Data guard. It's all data files and if Physical, the datafiles (block for block copy) are the same. Where the data files live can be different.

On Thu, Feb 4, 2010 at 12:26 PM, Ozgur Ozdemircili < ozgur.ozdemircili_at_gmail.com> wrote:

> Hi,
>
> The time has come to move our SAN to another building. Yet we have a
> problem. We have a dataguard attached to that san and also because
> they will be moving it part by part they want to clean and remake the
> san disks which will mean we will loose all the data. Since it will
> last a day or so I am not concerned with loosing the data that is
> already there. What I am concerned about is:
>
> - Shutting down the Dataguard will effect the DB RAC that I have in
> production?
> - Can I just make a export for the disks, reinitialize them, add them
> to ASM when they get back online and import?
>
> Thanks.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Thomas Roach
813-404-6066
troach_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 04 2010 - 13:21:47 CST