toasters

toasters@lists.teaparty.net

13520 discussions

RE: Snapshots and Oracle
by Yarmas, Tom 15 Aug '00

15 Aug '00

The control file contains: The database name. The timestamp of database creation. The names of the database's datafiles and online and archived redo log files. The checkpoint, i.e., a record indicating the point in the redo log such that all database changes prior to this point have been saved in the datafiles. Information on backups (when using the Recovery Manager utility). You should certainly backup the control file after any structural change to the database (i.e. addition of data or log files). Additionally, as part of a "normal" backup, I would issue - alter system archivelog current; This would cause a log switch, as well as archive the current redo log and all unarchived redo logs. I would then issue - alter system backup controlfile to 'PATH-TO-FILER' reuse; That way I would have a current copy of the control file included in the snapshot. I might also issue - alter system backup controlfile to trace, as well as copy the parameter file (init.ora and config.ora) to the Filer so I have them as part of the snapshot as well. Finally, I would not exclude any tablespaces from the alter tablespace begin backup. I figure if the snapshot is going to capture the datafiles anyway, I might as well have them in hot backup mode so they are valid for backup. And yes, I would also move the commands that manage the snapshots (except of course the creation of the snapshot) to before the tablespaces are actually put in hot backup mode. No doubt, the Oracle Backup and Recovery Guide is indispensable. You should fully understand what needs to be backed up and you should test your restore procedures. > -----Original Message----- > From: X X [mailto:gynt@post.com] > Sent: Tuesday, August 15, 2000 4:57 AM > To: toasters(a)mathworks.com > Subject: Re: Snapshots and Oracle > > > >Treat the control files just as you would any other critical DB > >file. When you shut your DB down and snapshot it, make a backup > >copy of the control files also. Control files only change when > >you do structural changes to your database, and thus must be > >backed up only then. Of course that is best case, just > >incorporate control files into your normal backups. As for redo > >logs they do not nee to be backed up. In fact you really cannot > >use them for anything other than instance recovery when you have > >the database crash. If you do a clean shutdown there is no data > >in these redo's. It gets flushed to disk during the shutdown. > > Shure! but I was talking about hot-backups. From what I under- > stand the control-file also contains info about the logfiles, > so it is important when and how it is copied. > > Should it not be a "ALTER SYSTEM SWITCH LOGFILE;" (that also > updates the control file) and then a "ALTER DATABASE BACKUP > CONTROLFILE TO '/SomeDirectory/SomeFileName.bkp' REUSE;" > before the snapshot is taken?? > > Also to minimize the time that the database is in backup > mode I would move all the "rsh -l root filer4 snap ..." > commands in dohotbackup.sh to a line before the dobegin.sql > script is run. > > /Gynt > > > ______________________________________________ > FREE Personalized Email at Mail.com > Sign up at http://www.mail.com/?sr=signup >

1 0

Virus Scan
by Shaw, Kevin 15 Aug '00

15 Aug '00

Anyone virus scanning their filers from a unix system? What S/W is being used? Any major problems? Thanks in advance. Kevin

1 0

Quick question
by kelvin tooth 15 Aug '00

15 Aug '00

Someone has just come up to me and asked me: "What is the maximum number of files on a fully populated (disk wise) F760?" I don't (sorry) know the volume configuration specified. have you guys got any ideas? I couldn't find the maximum value of the maxfiles command documented in the now site, or on my piece of paper from NTAP201/2. regards, Kelvin Tooth

3 2

RE: Virus Scanning
by Lyons, Jim 15 Aug '00

15 Aug '00

Am using a pretty crude couple of batch files to do a dir against the volume, pipe that to a file. Then iterate through the file and scan each dir that is not named ~snapshot. Need to use the /NORESULTS switch on the navwnt command so that processing does not stop when a dialog is presented to the screen. We tried NAV corp edition 7.xx, but it lacked the email notification feature (you have to buy a separate product, Symantec System Center, to do this). It also did not do scheduled scans for some reason on our NT server, but would from a workstation. Also hit the known bug that you cannot start a manual scan as long as the service is running. Also note that in NAV5, the exclusions work, but not as I would like (thus the batch file). Even though a directory is excluded, NAV still reads each file in the directory, but does not scan it. In Corp edition 7.xx, the exclusions work properly, but we had so many other issues with it that we went back to NAV5. rgds, Jim -----Original Message----- From: Nail, Larry Sent: Friday, August 04, 2000 5:59 PM To: Lyons, Jim; 'toasters(a)mathworks.com' Subject: RE: Virus Scanning Jim, We're currently using NAV5 to do this however, we're having to move to Corp. Edition 7.02 because of Windoze 2000, so I'm looking for another command line driven virus scanner that I can use. On a side note, what are you using to exclude snapshots. My efforts to put ~snapshot in the exclusions have been futile. Regards, Larry -----Original Message----- From: Lyons, Jim Sent: Friday, August 04, 2000 3:58 PM To: Nail, Larry; 'toasters(a)mathworks.com' Subject: RE: Virus Scanning Larry, we are using NAV50 called from a scheduled nightly batch file in order to skip the snapshot directories. Jim -----Original Message----- From: Nail, Larry Sent: Friday, August 04, 2000 2:53 PM To: 'toasters(a)mathworks.com' Subject: Virus Scanning Just curious if anyone is running a virus scanner against filers for CIFS? ______________________________________ Lawrence D. Nail Microsoft Certified Systems Engineer Senior NT Systems Administrator MSPD NT Systems Engineering Mixed Signal Products http://www1.msp.sc.ti.com/nail/ <http://www1.msp.sc.ti.com/nail/>

1 0

Re: Snapshots and Oracle
by X X 15 Aug '00

15 Aug '00

>Treat the control files just as you would any other critical DB >file. When you shut your DB down and snapshot it, make a backup >copy of the control files also. Control files only change when >you do structural changes to your database, and thus must be >backed up only then. Of course that is best case, just >incorporate control files into your normal backups. As for redo >logs they do not nee to be backed up. In fact you really cannot >use them for anything other than instance recovery when you have >the database crash. If you do a clean shutdown there is no data >in these redo's. It gets flushed to disk during the shutdown. Shure! but I was talking about hot-backups. From what I under- stand the control-file also contains info about the logfiles, so it is important when and how it is copied. Should it not be a "ALTER SYSTEM SWITCH LOGFILE;" (that also updates the control file) and then a "ALTER DATABASE BACKUP CONTROLFILE TO '/SomeDirectory/SomeFileName.bkp' REUSE;" before the snapshot is taken?? Also to minimize the time that the database is in backup mode I would move all the "rsh -l root filer4 snap ..." commands in dohotbackup.sh to a line before the dobegin.sql script is run. /Gynt ______________________________________________ FREE Personalized Email at Mail.com Sign up at http://www.mail.com/?sr=signup

1 0

Configuring Netbackup for NDMP 3.2
by Oye Akintan 15 Aug '00

15 Aug '00

We have a F230 running Data Ontap 5.2.3 with a Quantum DLT4700 directly attached to it. I'm running Netbackup for Veritas 3.2 and Netbackup for NDMP 3.2. I've installed jumbo patch 0820413. I'm having problem configuring the storage device. I ran the command set_ndmp_attr -robot . The sys admin guide says to test it using tldtest -r servername:spt0 but when I ran this command, the mode sense failed with the following error: mode_sense failed, CHECK CONDITION sense key = 0x5, asc = 0x24, ascq = 0x0, INVALID FIELD IN CDB Can anyone tell me what I can do to fix it ? -Oye

1 0

Re: Bad NFS performance with Linux.. please help
by Eyal Traitel 14 Aug '00

14 Aug '00

I can suggest you to check: 1. Network cards and switches/routers between the Linuxes and the filers - check for 100mbit full duplex settings - check in the filer and the linux for nfsstat and netstat errors. 2. I don't have experience with NFS on linux, but I know that there were a lot of nfs changes in the last kernels, so even if it worked OK before, maybe you should just consider to upgrade the linuxes - it is never bad in linux anyway... :) You'll probably get faster NFS that way, since nfs was moved to kernel level I think in 2.3 or something... Eyal. --- Henrique Pantarotto <henrique(a)corp.terra.com.br> wrote: > Hello toaster friends! > > This week I experienced a very strange NFS performance in our POP3 > servers. > We've 4 POP3 Linux clients mouting 2 netapp boxes, like this: > > /var/spool/mail1 - F760 (cluster) > /var/spool/mail2 - F760 (cluster) > /var/spool/pop - F720 > > Our Linux clients are Pentium III 650Mhz Dual with 1GB RAM running a > Red > Hat-like distribution with Kernel 2.2.14-19smp. > > This solution has worked very fine until this week, when we started > experiencing high Load Average in our Linux boxes and accumulation of > pop > processes. > > Copies from /var/spool/mail to /var/spool/pop are verrrrrrrrry > slowwwwwwwwww... so pop processes get status of "D" (Disk Waiting > right?, > and caos takes place. > > I don't know what it is. We're crazy here... > > Anyone has ever had hard times like this before with Linux? > > > Thanks a lot for any help!!!!!!! > > PS: We've Brazilian NetApp guys giving us a hand here. > > > Regards, > _______________________________________________ > Henrique Pantarotto > SysOp Site S�o Paulo > Terra Networks Brasil S/A > A Internet mais sua do que nunca > Tel: (11) 5505-5728 r.316/238 ICQ: 6934285 IT: henpa > henrique(a)corp.terra.com.br > ===== Yours, Eyal Traitel eTraitel(a)yahoo.com, Home: 972-3-5290415 (Tel Aviv) *** eTraitel - it's the new eBuzzword ! *** __________________________________________________ Do You Yahoo!? Yahoo! Mail � Free email you can access from anywhere! http://mail.yahoo.com/

6 5

BudTool-4.6.1a problem
by Marion Hakanson 14 Aug '00

14 Aug '00

Folks, We're wanting to upgrade from BudTool-4.6 (with patch 10) to bt-4.6.1a (plus its patch 2.Jumbo), in order to enable a NetApp OS upgrade (OnTAP 5.2.3 -> 5.3.x), per the applicable compatibility matrix, and we have run into a pretty serious issue that perhaps others of you have already dealt with. As background, at our site, our BudTool host is Solaris-2.6/SPARC, which controls a tape library's robotics & uses NDMP to tell our NetApp to back itself up to a SCSI-connected tape drive in that library (other tape drives are SCSI-connected to the BudTool host, and are used to backup other clients by various BudTool methods). While reading through the BudTool-4.6.1a Release Notes, I found: Split Images If a backup request is too large to fit on one tape, BudTool can split the backup image across a maximum of three tapes. BudTool does not support backup requests that require four or more tapes. Now if you're like me, you have a NetApp filesystem which is big enough to be split across 4 or 5 DLT7k tapes. In fact, we've been backing up such a filesystem for a couple years now, and have even done a number of single-file or single-directory restores from such backups, without any problems. We also use "btcp" to make offsite copies of these backups onto a DLT4k stacker, which of course splits such a backup image across even more tapes (up to 5 or 6). Naturally, after a lot of slow, deep breaths, I immediately did a little test, and was able to successfully restore a single file from a recent full backup which is split across five tapes. As is typical of dump/restore, it had to load and read all five tapes before the restore was complete. Although the file was a pretty recent one, and has a "high" inode number, I can't be sure which of the tapes contained the file I restored. Anyway, when I called PDC (yeah, Legato has farmed out all our BudTool support calls to PDC), they checked with Legato, who told them that yes, this is a known problem, and it has "always been that way", it's not something new introduced between bt-4.6 and bt-4.6.1a (and its subsequent jumbo patch). Specifically, I was told that if I tried to restore something that resided on that 4th (or 5th) tape, the restore would fail. The PDC support person also told me that Legato would not be issuing any more patches to BudTool, so this problem will apparently not be fixed. Ain't it great what $30k worth of software purchase and $6k/year of software maintenance (over the course of 2-3 years) can buy you? And any guesses as to who we're _not_ going to use to replace our BudTool installation & maintenance? At this point, I'm not sure what to say, other than to ask if anyone else out there has used bt-4.6 or bt-4.6.1a to backup and restore a filesystem that spans more than three or four, or more tapes, and of course to please let me know your results. I'd particularly like to know how and/or under what circumstances this split-image limit comes into play. Well, I'm off to break up that backup request into smaller ones. It's a lucky thing that 200GB filesystem is mostly divided into qtrees for each of our research centers. Regards, -- Marion Hakanson <hakanson(a)cse.ogi.edu> CSE Computing Facilities

1 0

Re: Configuring Netbackup for NDMP 3.2
by Steve Kappel 14 Aug '00

14 Aug '00

Oye Akintan wrote: >We have a F230 running Data Ontap 5.2.3 with a Quantum DLT4700 directly >attached to it. I'm running Netbackup for Veritas 3.2 and Netbackup for >NDMP 3.2. I've installed jumbo patch 0820413. I'm having problem >configuring the storage device. I ran the command set_ndmp_attr -robot . >The sys admin guide says to test it using tldtest -r servername:spt0 but >when I ran this command, the mode sense failed with the following error: > >mode_sense failed, CHECK CONDITION >sense key = 0x5, asc = 0x24, ascq = 0x0, INVALID FIELD IN CDB > Can anyone tell me what I can do to fix it ? Is this a standalone drive? If so, then there is no robot to configure. tldtest -r tests the robot. If it is in a library then the SCSI controller, id, or lun that you provided to set_ndmp_attr -robot are probably not the correct ones for your configuration. __________________________________________________________________________ Steve Kappel steve.kappel(a)veritas.com VERITAS Software steve.kappel(a)iname.com (Personal)

1 0

RE: move command on filer?
by Davis, John 14 Aug '00

14 Aug '00

I have..it reqires a MS JVM be installed on the NT box in question and a proper JDK..need a twist of Java expertise but if I can do it most of this audience sure can..I have the class libraries should anyone want them..I used Borlands JavaBuilder to knit them together.. -----Original Message----- From: Agnew, Blaine [mailto:Blaine.Agnew@netapp.com] Sent: Tuesday, August 08, 2000 5:59 PM To: ''Nick.Mayrath(a)envoy.com' '; 'toasters(a)mathworks.com ' Subject: RE: move command on filer? NDMPCopy can be handy for this sort of application, however I don't know if someone has ported it to NT yet. It is a freeware utility that runs on the host and controls the filer via NDMP commands. It is similar to having a dump piped through to a restore, except that the data does not have to go through your host. You can get the source from www.ndmp.org if you want to get more information. -----Original Message----- From: Muhlestein, Mark To: 'Nick.Mayrath(a)envoy.com'; toasters(a)mathworks.com Sent: 8/8/00 4:23 PM Subject: RE: move command on filer? If the files are in the same qtree the moves will be fast because this is just a rename; there is no need to copy the data. If not, you will have to copy the files. There is currently no way to do that locally on the filer. Mark -----Original Message----- From: Nick.Mayrath(a)envoy.com [mailto:Nick.Mayrath@envoy.com] Sent: Friday, August 04, 2000 4:07 PM To: toasters(a)mathworks.com Subject: move command on filer? This weekend I need to move alot of files around of my F720. Is there any "move" command locally on the filer that I can use instead of using my NT machine? My concern is that using the NT machine will cause the moves to take longer since they have to "pass through" my NT box. Thanks

2 1

Jump to page:

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