Re: Dataguard
- From: Thomas Roach <troach@xxxxxxxxx>
- To: ozgur.ozdemircili@xxxxxxxxx
- Date: Thu, 4 Feb 2010 14:21:47 -0500
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@xxxxxxxxx> 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.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Thomas Roach
813-404-6066
troach@xxxxxxxxx
Other related posts:
