Networker

Re: [Networker] Staging to disk - How to

2003-07-10 18:26:54
Subject: Re: [Networker] Staging to disk - How to
From: Yura Pismerov <ypismerov AT TUCOWS DOT COM>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Thu, 10 Jul 2003 18:26:48 -0400
Paula Ehn wrote:
>
> I think I've gotten it all figured out.
>
> For us compression is set via the Sybase Module for Oracle's script nsrsyb.
> Since we have it turned off, we're not doing compression.
>
> As for the backing up to disk, I've gotten that too with some hints from 
> various
> people and noticing that I needed to manually mount the volume I created with
> the Media->Devices->Volume Operation->Mount command. Now all works fine!


No, you don't have to mount them manually, you only need to create a
volume in
particular devices. You will have N volumes (one per each device) and
Networker will mount them on demand.

>
> Thanks to all!
> Paula
>
> >From: lemons_terry AT emc DOT com
> >Date: Thu, 10 Jul 2003 15:01:40 -0400
> >
> >Hi Paula
> >
> >Regarding compression, tape drives commonly do compression, but disk drives
> >do not.  You can configured the NetWorker client resource to perform
> >compression, but this puts a (perhaps sizeable) CPU load on the client
> >system to perform that compression.
> >
> >I've never used NetWorker to just make a copy of data.  All, what are the
> >best ways to do this?
> >
> >Thanks
> >tl
> >
> >-----Original Message-----
> >From: Paula Ehn [mailto:pehn AT cc.UManitoba DOT CA]
> >Sent: Thursday, July 10, 2003 2:53 PM
> >To: lemons_terry AT emc DOT com
> >Subject: RE: [Networker] Staging to disk - How to
> >
> >
> >Yes that's baiscally it. Why they (Administration) call it a development
> >server
> >if it has live data on it is beyond me. I just need to find out how to dump
> >a
> >database to disk rather than tape and our DBA will be happy and my tape
> >drives
> >will be free from conflicts again.
> >
> >The data dumped to the staging area would not be kept beyond a day and of
> >course
> >would not be going to tape at all as I run a seperate backup nightly of all
> >DB's.
> >
> >Would you happen to know what kind of compression we would see putting this
> >type
> >of data to disk. Don't DB's typically have a compression ratio of greater
> >then
> >2:1?
> >
> >Thanks!
> >Paula
> >
> >>From: lemons_terry AT emc DOT com
> >>Date: Thu, 10 Jul 2003 14:33:58 -0400
> >>
> >>Gotcha; thanks.
> >>
> >>So, is the whole purpose here to make a copy of the data on another system?
> >>That really isn't a 'backup', I guess . . . .
> >>
> >>??
> >>
> >>tl
> >>
> >>-----Original Message-----
> >>From: Paula Ehn [mailto:pehn AT cc.UManitoba DOT CA]
> >>Sent: Thursday, July 10, 2003 2:32 PM
> >>To: lemons_terry AT emc DOT com
> >>Subject: RE: [Networker] Staging to disk - How to
> >>
> >>
> >>Unfortunately, all our Sybase and Orcale DB's are on local disk. If I can
> >>talk
> >>our DBA into it, we can use our NetApp for a staging area. We've tried
> >>talking
> >>them into moving the DB's to the NetApp but they don't like the idea of
> >>mixing
> >>Administration data with Academic data. They like stand alone boxes.
> >>
> >>Paula
> >>
> >>>From: lemons_terry AT emc DOT com
> >>>Date: Thu, 10 Jul 2003 14:20:15 -0400
> >>>
> >>>Hi Paul
> >>>
> >>>Before we go this route, where are you storing your data?  If it is on a
> >>>storage array connected to a SAN, there are some clever, quick things we
> >>can
> >>>do . . . .
> >>>
> >>>Thanks
> >>>tl
> >>>
> >>>-----Original Message-----
> >>>From: Paula Ehn [mailto:pehn AT cc.UManitoba DOT CA]
> >>>Sent: Thursday, July 10, 2003 2:19 PM
> >>>To: lemons_terry AT emc DOT com
> >>>Cc: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
> >>>Subject: RE: [Networker] Staging to disk - How to
> >>>
> >>>
> >>>When I say old system I mean SQL Backtrack instead of Networker. Basically
> >>>on a
> >>>nightly basis, we want to copy a Sybase DB from the devlopement box to the
> >
> >>>production box. So we want to backup to disk then restore to the
> >production
> >>>box.
> >>>
> >>>What I am basically looking for is how to make Networker backup to disk
> >>>instead
> >>>of tape?
> >>>
> >>>I've gotten some clues so far about setting up a file type device as
> >>opposed
> >>>to
> >>>a tape device but I've been unsuccessful in setting up a disk volume in
> >>>Networker for it to use.
> >>>
> >>>I think I need specifics although if I play long enough, I'm sure I'll
> >>>stumble
> >>>on the answer.
> >>>
> >>>Paula
> >>>
> >>>>From: lemons_terry AT emc DOT com
> >>>>To: pehn AT cc.UManitoba DOT CA
> >>>>
> >>>>Hi Paul
> >>>>
> >>>>I'm confused by "In the old system, DB's from the Development
> >>>>server were staged to disk and then restored to the production server on
> >a
> >>>>regular scheduled basis."  Would you mind talking a bit more about this?
> >>>>
> >>>>I believe that all NetWorker database modules support backup to disk, as
> >>>>well as to tape.  So, doing a backup to disk, followed by a staging to
> >>tape
> >>>>for the data you'd like to archive, should work just fine.  But, I may
> >not
> >>>>yet understand what you want to do.
> >>>>
> >>>>Thanks!
> >>>>tl
> >>>>
> >>>>Terry Lemons
> >>>> CLARiiON Applications Integration Engineering
> >>>>    EMC╡
> >>>>where information lives
> >>>>
> >>>>4400 Computer Drive, MS D239
> >>>>Westboro MA 01580
> >>>>Phone: 508 898 7312
> >>>>Email: Lemons_Terry AT emc DOT com
> >>>>
> >>>>
> >>>>
> >>>>-----Original Message-----
> >>>>From: Paula Ehn [mailto:pehn AT cc.UManitoba DOT CA]
> >>>>Sent: Thursday, July 10, 2003 12:00 PM
> >>>>To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
> >>>>Subject: [Networker] Staging to disk - How to
> >>>>
> >>>>
> >>>>Hi gang,
> >>>>
> >>>>We have just moved our 2 Sybase (development and production) servers off
> >>>SQL
> >>>>BackTrack and into Networker. In the old system, DB's from the
> >Development
> >>>>server were staged to disk and then restored to the production server on
> >a
> >>>>regular scheduled basis. How can I do this same thing with Networker?
> >>>>
> >>>>Environment: Server and all clients are running Solaris 2.5, 8 or 9.
> >>>>Both Sybase servers have Sybase Module for Networker 2.0 installed
> >>>>Networker version for both server and all clients is 6.1.3.
> >>>>
> >>>>We've gotten around this for now by staging to tape instead of disk but
> >>>this
> >>>>has
> >>>>great potential to interfere with our large nightly backups as we have
> >>>>limited
> >>>>number of tape drives. Staging to disk would eliminate this possible
> >>>>problem.
> >>>>
> >>>>Do we need extra Networker modules to accomplish this? We will want to do
> >>>>the
> >>>>same thing with Oracle in the near future as well.
> >>>>
> >>>>Thanks!
> >>>>Paula
> >>>> -----------------------------------------------------------------
> >>>>| Paula Ehn  VE4MHZ/VE4HZ                    Room 624 Eng.        |
> >>>>| Unix System Administrator                  pehn AT cc.umanitoba DOT ca |
> >>>>| Academic Computing and Networking          (204)474-7849        |
> >>>>| University of Manitoba                     Fax: (204) 474-7920  |
> >>>> -----------------------------------------------------------------
> >>>>
> >>>>--
> >>>>Note: To sign off this list, send a "signoff networker" command via email
> >>>>to listserv AT listmail.temple DOT edu or visit the list's Web site at
> >>>>http://listmail.temple.edu/archives/networker.html where you can
> >>>>also view and post messages to the list.
> >>>>=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
> >>>
> >>> -----------------------------------------------------------------
> >>>| Paula Ehn  VE4MHZ/VE4HZ                    Room 624 Eng.        |
> >>>| Unix System Administrator               pehn AT cc.umanitoba DOT ca |
> >>>| Academic Computing and Networking          (204)474-7849        |
> >>>| University of Manitoba                  Fax: (204) 474-7920  |
> >>> -----------------------------------------------------------------
> >>
> >> -----------------------------------------------------------------
> >>| Paula Ehn  VE4MHZ/VE4HZ                    Room 624 Eng.        |
> >>| Unix System Administrator                pehn AT cc.umanitoba DOT ca |
> >>| Academic Computing and Networking          (204)474-7849        |
> >>| University of Manitoba                   Fax: (204) 474-7920  |
> >> -----------------------------------------------------------------
> >
> > -----------------------------------------------------------------
> >| Paula Ehn  VE4MHZ/VE4HZ                    Room 624 Eng.        |
> >| Unix System Administrator                 pehn AT cc.umanitoba DOT ca |
> >| Academic Computing and Networking          (204)474-7849        |
> >| University of Manitoba                    Fax: (204) 474-7920  |
> > -----------------------------------------------------------------
>
>  -----------------------------------------------------------------
> | Paula Ehn  VE4MHZ/VE4HZ                    Room 624 Eng.        |
> | Unix System Administrator                  pehn AT cc.umanitoba DOT ca |
> | Academic Computing and Networking          (204)474-7849        |
> | University of Manitoba                     Fax: (204) 474-7920  |
>  -----------------------------------------------------------------
>
> --
> Note: To sign off this list, send a "signoff networker" command via email
> to listserv AT listmail.temple DOT edu or visit the list's Web site at
> http://listmail.temple.edu/archives/networker.html where you can
> also view and post messages to the list.
> =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=