toasters

toasters@lists.teaparty.net

13531 discussions

RE: NetApp and Oracle
by Liu, Jerry 19 Dec '00

19 Dec '00

First, Use Oracle SQLloader to load that data into the Oracle database. Second, Update the read-only-reporting Oracle database from the other database at desired interval. There are several methods to accomplish the second task. Method one: Run Oracle database in archive mode, after the first time load "that data" into the Oracle database, take a cold backup of the DB; use the cold backup to restore on the second server system (sun+F840) to create the reporting database. Then, use Snapmirror to ship archive logs to the reporting database system. Apply archive logs to update the reporting database at desired interval that can be done in scripts via cron job. This method is straight forward. Method two: Use Oracle Standby Database (replication) that provide you the ability to ship archive logs via net8, apply archive logs at desired interval to update/sync with the other database; and the standby database can be in read-only mode as reporting database. You will need to follow Oracle Standby Database documentation for configuration and operation of Oracle Standby Database. Please do not hesitate to contact me if I can provide any assistance. Regards. Jerry Liu Database Engineer Network Appliance, Inc. -----Original Message----- From: Schiel, John [mailto:John.Schiel@qwest.com] Sent: Tuesday, December 19, 2000 1:02 PM To: 'toasters(a)mathworks.com' Subject: NetApp and Oracle I'd like to pose this question here and see where it leads. If this is not the appropriate forum, please let me know what is. I'm in a group where we need to implement a data warehouse. Our design so far is to purchase two 840 filers each with one terabyte of storage using the 36gb drives. On top of that we are going to use either a 420R or Netra 1405 sun server as the database server (solaris 8, Oracle 8.1.6). What we need to do is grab files off of a 760 filer that is in CDR (comma delimited record) format and load that data into an instance of Oracle. Our goal then is to use some method of getting the data off of the 'load' server to another server that will be essentially 'read only' for reporting purposes. These so far are separate servers and I'd like to stay away from Oracle Parallel Server (OPS) at this point because of the extra maintenance and design work that would need to be done to handle this. What I would like to know is what methods of data movement some of you have used. In our quote for the filers we have asked for SnapMirror but I have some reservations on how that might work with Oracle because of the SCN's that are in each separate instance of Oracle. John

1 0

RE: need help with Legato and Filer backup
by Benn, Paul 19 Dec '00

19 Dec '00

If you have files with NT-style permissions, though, backing up over NFS is not a desirable option as you will loose any NTFS file attributes including ACLs and DOS attributes. Backing up over CIFS not only retains NTFS file permissions but it retains UNIX permissions as well as tracks an archive bit on UNIX files (so NT apps can do "incremental" backups). If you have a lot of data, you should really consider an NDMP based solution. You can read more on NT based backup here: http://www.netapp.com/tech_library/3052.html Regards, Paul Benn Network Appliance -----Original Message----- From: Michael Salmon [mailto:michael.salmon@uab.ericsson.se] Sent: Tuesday, December 19, 2000 3:13 AM To: Dell, Mary; toasters(a)mathworks.com Subject: Re: need help with Legato and Filer backup +-- On Friday, December 15, 2000 11:28:24 -0600 "Dell, Mary" <mdell(a)mesirow.com> wrote: | | Is anyone out there using legato to back up your filer? We just got our | filer running and are not able to get legato working for it yet despite | help from support and so on. We've got the client installed on the | filer, we've created a client & group setup for it on the (unix) | networker server, and we've got the (eval) enabler--but it keeps failing. +-- I have tried the netapp client, even had it working from time to time, I gave up before I could do any serious testing but I suspect that it isn't 100% reliable when it does work. My best advice is to stop trying to use it and concentrate on something that works, backup over CIFS, NFS or another backup system. /Michael -- This space intentionally left non-blank.

1 0

2 questions for f760
by neil lehrer 19 Dec '00

19 Dec '00

hi, 1. we will be moving our home and share dirs from old sun boxes to f760. the home dirs on the suns were set up like: \home \home\a \home\a\abe \home\a\allen \home\b etc. in other words, user homedirs under the first letter of the id. i was told this was done for performance reasons, inode searching, on the sun boxes. do i need to use this structure on the 760? is there a similar issue on filers? or can it just be \home\userid? 2. i have heard i can connect a tape device to a fibre channel card rather than the scsi to get better performance. anybody know anything about this? i'm not looking for a separate network, just more performance. current config is: 2 atm cards fcal card cluster card [i am configured with 1 f760 as active and the other as standby, do nothing. the tape drive will be attached to the active filer]. plus the other normal cards. thanks.

2 1

re: 2 questions for f760
by mds＠gbnet.net 19 Dec '00

19 Dec '00

On Tue 19 Dec, 2000, neil lehrer <nlehrer(a)ibb.gov> wrote: > > 2. i have heard i can connect a tape device to a fibre channel card > rather than the scsi to get better performance. anybody know anything > about this? i'm not looking for a separate network, just more > performance. Given there are no single tape devices that will likely top the maximum throughput available on a fast-wide parallel SCSI connection, moving to FC won't buy you much. If you say wanted to go from two devices to four, then, yes FC might be a suitable move. I'm not aware yet of (m)any tape devices that do FC natively - most currently require the use of a FC-parallel-SCSI 'bridge' (they're SCSI routers to afficionados). > cluster card [i am configured with 1 f760 as active and the other as > standby, do nothing. the tape drive will be attached to the active > filer]. Then the costs and difficulties in using FC tape hardware outweigh the benefits. >-- End of excerpt from neil lehrer -- -Mark ... an Englishman in London ...

1 0

FW: Backups Using Netapp Dump
by Daniel Oxenhandler 19 Dec '00

19 Dec '00

Jim, We are very happily using Ontap's dump program. We have a DLT7000 autoloader connected to a Solaris box, and use commands like this to back the filer up over a dedicated 100Mbps net: rsh filer dump 0ubf 63 rmt@solaris-box:/dev/rmt/1ubn /vol/vol0/projects It's been totally solid, and captures both CIFS and UNIX metadata, which is a requirement for us. This solution works well if you don't have too many filers, or too much data (we have 1 filer and <200GB). We abandonned paid for Legato licenses to implement this solution, BTW. To me, a commercial solution would start to make sense if your numbers were significantly larger, or you wanted to take advantage of the NDMP protocol, or some of the more advanced libraries, etc. that are out there. Otherwise, dump rocks! Daniel Oxenhandler Network Engineer Sprint Laboratories 650-375-4281 -----Original Message----- From: Collins, Jim [mailto:JCollins@sandc.com] Sent: Tuesday, December 19, 2000 6:35 AM To: 'toasters(a)mathworks.com' Subject: Backups Using Netapp Dump Is anyone using the Dump program that comes with Ontap? I have seen a lot of third party stuff and am wondering if anyone has seen any short falls in using this Ontap backup program? Jim Collins

1 0

Backups Using Netapp Dump
by Collins, Jim 19 Dec '00

19 Dec '00

Is anyone using the Dump program that comes with Ontap? I have seen a lot of third party stuff and am wondering if anyone has seen any short falls in using this Ontap backup program? Jim Collins

3 2

Re: need help with Legato and Filer backup
by Leif Nixon 19 Dec '00

19 Dec '00

"Dell, Mary" <mdell(a)mesirow.com> writes: > Is anyone out there using legato to back up your filer? Yup. > We just got our filer running and are not able to get legato working > for it yet despite help from support and so on. We've got the > client installed on the filer, we've created a client & group setup > for it on the (unix) networker server, and we've got the (eval) > enabler--but it keeps failing. We're currently backing the filer up over NFS from a Unix host. Works fine, basically, but it stresses the network a bit. (100 Mbps full duplex) In the near future we're probably moving to Networker 6.0, which can back the filer up directly via NDMP, and we'll possibly set up a dedicated net between the backup server and the filer for the backups. -- Leif Nixon Sysadm/developer Ericsson SoftLab AB ---------------------------------------------------------- E-mail: nixon(a)softlab.ericsson.se Phone: +46 13 23 57 61 ----------------------------------------------------------

1 0

need help with Legato and Filer backup
by Dell, Mary 19 Dec '00

19 Dec '00

Is anyone out there using legato to back up your filer? We just got our filer running and are not able to get legato working for it yet despite help from support and so on. We've got the client installed on the filer, we've created a client & group setup for it on the (unix) networker server, and we've got the (eval) enabler--but it keeps failing. Any ideas or suggestions would be a big help. Thanks, Mary Dell

2 1

about blocking factor
by Abu Ihsan 19 Dec '00

19 Dec '00

hi, i would like to know how to find the blocking factor of a volume and what is the default size and can we modify them as we do with our unix box (newfs). i know we can increase the inode on the fly (very cool). tq, --fared __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/

1 0

tested SNMP trap code
by Schepers, Jan 18 Dec '00

18 Dec '00

Hello list, is there anyone out there that has practice with SNMP test? Where can I obtain more information? regards, Yann

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

1997

toasters