Re: oracle 11g dataguard on Netapps

From: LS Cheng <exriscer_at_gmail.com>
Date: Thu, 12 Feb 2009 23:11:06 +0100
Message-ID: <6e9345580902121411l167b054ds35b2e13f82f312db_at_mail.gmail.com>

I am not sure what is your SLA but in UNIX or Linux you can backup ORACLE_HOME online, a simple tar command.

But even if you want to backup the software offline it probably takes 10 minutes or less so I am not sure if snapshot is giving you any benefits at all.

Thanks

--
LSC





On Thu, Feb 12, 2009 at 4:45 PM, Joan Hsieh <joan.hsieh_at_tufts.edu> wrote:



> Hi LS,

>

> Thank you, I am just wandering the snapshots on ORACLE HOME should it be

> the benefit when we apply patch or upgrade the oracle? So we can skip the

> backup of oracle home and fast of restoring it in case it needed?

>

> I am not sure it is worth to do it or not? We have enough space on both

> local and NetApps. Just curious to know.

>

> Joan

>

> LS Cheng wrote:

>

>  Hi

>>

>> You can install the binaries in NetApp volumes or local disk, it is up to

>> you, but if you have plenty of spaces in your local disks (now days 100 of

>> GB is not unusual) I dont see why you want to install them in a NAS device,

>> I dont see any advantage.

>>

>> Again I dont have experience with NetApp snapshots but I have used EMC

>> Snapview which should be similar technology, you put your database in backup

>> mode, take the snap and end the backup mode. More or less there are steps to

>> get two controlfile copies and archived logs, probably googling can get you

>> detail steps.

>>

>> Thanks

>>

>> --

>> LSC

>>

>>

>>  On Wed, Feb 11, 2009 at 9:07 PM, Joan Hsieh <joan.hsieh_at_tufts.edu<mailto:

>> joan.hsieh_at_tufts.edu>> wrote:

>>

>>    Hi Matt,

>>

>>    Thanks for your prompt reply, what is the disadvantage to install

>>    the binary on Netapps giving that we have 250gb storage? I am

>>    thinking if primary and standby shared a same oracle home, it will

>>    save time for patching or upgrading the binary, besides, it also can

>>    take the benefit of the snapshots????

>>

>>    I just know little about NetApps snapshots, how it work for you? do

>>    you use it for database recovery? Do you need to script the database

>>    in hot backup mode in order to that? That's why I thought we could

>>    benefit from the shared oracle home.

>>

>>

>>    Thanks,

>>

>>    Joan

>>

>>

>>    Matthew Zito wrote:

>>

>>        I would recommend keeping your binary installs on the local

>>        filesystem

>>        of your servers - NetApp is expensive storage, and it's useful

>>        to keep

>>        that install local.

>>

>>        As far as separating volumes, you have to remember that on NetApp,

>>        having two separate volumes does not necessarily automatically

>> imply

>>        that they are on different physical spindles.  On NetApp you have

>>        something called an "aggregate", which is basically a RAID group

>> (or

>>        multiple raid groups, potentially).  Out of this aggregate,

>>        volumes are

>>        carved up, sharing the same physical spindles.  The major

>>        advantage of

>>        having multiple volumes from the same aggregate is

>>        administrative - you

>>        can make sure that a bad actor on one volume doesn't fill up the

>>        whole

>>        filer.

>>

>>        Also, keep in mind that since NetApp uses a copy-on-write

>>        filesystem, it

>>        can be useful to share a datafile and its index on the same

>>        aggregate,

>>        as NetApp will make sure those writes are sequential.

>>

>>        For redundancy's sake, if you can spare the disk space, keep at

>>        least

>>        one set of redo logs, controlfiles, etc. on a separate

>>        aggregate.  That

>>        will help protect you against a multiple disk failure scenario.

>>         Also,

>>        familiarize yourself with NetApp snapshots, they're very useful.

>>

>>        Thanks,

>>        Matt

>>

>>        -----Original Message-----

>>        From: oracle-l-bounce_at_freelists.org

>>        <mailto:oracle-l-bounce_at_freelists.org>

>>        [mailto:oracle-l-bounce_at_freelists.org

>>        <mailto:oracle-l-bounce_at_freelists.org>] On Behalf Of Joan Hsieh

>>        Sent: Wednesday, February 11, 2009 2:49 PM

>>        To: oracle_l

>>        Subject: oracle 11g dataguard on Netapps

>>

>>        Hi listers,

>>

>>        Our new project is creating a 11g dataguard environment on

>>        NetApps storage. I have the following questions like to ask;

>>

>>        1. What is the best practice  of volume configuration? should we

>>        configure single volume for data, single volume for redo?

>>

>>        2. As oracle home, is it better to install on the local file

>>        system or on NetApps? If it is best on Netapps, then should the

>>        Oracle home be shared with primary and standby sites? Our

>>        primary and standby are on separate servers.

>>

>>        Thanks,

>>

>>        Joan

>>        --

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

>>

>>

>>    --

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

>>

>>

>>

>>

>


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

Received on Thu Feb 12 2009 - 16:11:06 CST