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@xxxxxxxxx> 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@xxxxxxxxx<mailto: >> joan.hsieh@xxxxxxxxx>> 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@xxxxxxxxxxxxx >> <mailto:oracle-l-bounce@xxxxxxxxxxxxx> >> [mailto:oracle-l-bounce@xxxxxxxxxxxxx >> <mailto:oracle-l-bounce@xxxxxxxxxxxxx>] 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 >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> >> >