Networker

Re: [Networker] I just don't seem to get it... Are there other do c resources?

2004-01-15 11:40:16
Subject: Re: [Networker] I just don't seem to get it... Are there other do c resources?
From: Matthew Huff <mhuff AT OX DOT COM>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Thu, 15 Jan 2004 11:39:42 -0500
I agree with what Terry is saying. A file level backup of a running
Oracle database is worthless without special consideration.

However, I would argue there are three levels of backups you can do with
Oracle and Legato.

1) Cold. Database has to be shutdown. You can use Legato's pre and post
command to run a script to shutdown/startup database. This is actually
the easiest to restore and the least complicated. However the database
has to be completely shut down during backups and you always run the
risk of the database not restarting for the next day.

2) Hot. You can use a script to put Oracle's tablespaces in "hot backup"
mode while backup is running. File level backup is then possible. This
is fairly complicated and error prown. However, you can backup the
database without shutting it down or purchasing other licenses.

3) Rman. You can use Oracle's RMAN with Legato's module for Oracle to do
backups without shutting the database down, nor putting the database in
"hot backup" mode. The database wont' see near as a performance impact
as the normal Hot backup causes. However you need to buy Legato's
license. Generally around $5k per Oracle server.


--
Matthew Huff           | One Manhattanville Rd
Director of Operations | Purchase, NY 10577
OTA LLC                | Phone: 914-460-4039 
mailto:mhuff AT ox DOT com    | Fax:   914-460-4139   

> -----Original Message-----
> From: Lemons, Terry [mailto:lemons_terry AT EMC DOT COM] 
> Sent: Thursday, January 15, 2004 11:23 AM
> To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
> Subject: Re: [Networker] I just don't seem to get it... Are 
> there other do c resources?
> 
> 
> Hi Miles
> 
> Welcome to our world!  I'm glad you've found this list, as 
> there is an incredible amount of knowledge in the heads of 
> the people who subscribe.
> 
> In addition to what other have already said, I wanted to say 
> a few words about Oracle.  If you already know this, I apologize.
> 
> If you backup up disks that contain a database from Oracle 
> (or anyone else, for that matter) while the database is 
> active, what you are saving is almost certainly junk or 
> nearly-junk.  The only good ways to backup databases are:
> 
> O 'cold' (the database is shutdown, making it safe to backup 
> up the database
> files)
> O 'hot' (the database is running, but special programs are 
> used that talk to the database daemons, and do 'the right 
> things' during the backup)
> 
> There are add-ins to the basic NetWorker product that do 
> these special database things.  You'll find documentation on 
> all of these in the same area as the regular NetWorker 
> manual, if you want to read up on them.
> 
> Hope this helps.
> tl
> 
> -----Original Message-----
> From: Miles D. Oliver [mailto:moliver AT LGI DOT COM]
> Sent: Thursday, January 15, 2004 7:50 AM
> To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
> Subject: [Networker] I just don't seem to get it... Are there 
> other doc resources?
> 
> From moliver AT linux.lgi DOT com Thu Jan 15 07:46:38 2004
> Date: Wed, 14 Jan 2004 08:21:51 -0500 (EST)
> From: Miles D. Oliver <moliver AT linux.lgi DOT com>
> To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
> Subject: I just don't get it... Are there other doc resources?
> 
> 
>  Sorry for the post, it is out of frustration that I am making it.
> 
>  I'm very new to Legato and am looking for other sources of 
> documentation other than the PDF files from Legato and the 
> archives of this list.
> 
>  I am 'attempting' to manage a 4 host Sun environment with 2 
> 480s and 2 220Rs and an L9 tape drive on one of the 480s.
> 
>  So far I have been able to perform the Legato installation 
> add all the other Sun clients and are performing scheduled 
> automated backups with full and incrementals of the systems. 
> At least I think that I am doing this properly. I found the 
> documentation hard to digest and understand.
> 
>  However,  2 of the systems are running oracle and we do not 
> need to backup ALL of the filesystems, only selected 
> filesystems nightly.
> 
>  I can't seem for the life of me to figure out how to create 
> a backup schedule that will backup only selected filesystems 
> on each server.
> 
>  Is there any kind of a 'Legato for Dummies' type of 
> resource??  I'm fumbling badly here and could use some 
> assistance.  I've RTFM'd till I'm blue in the face.
> 
> --
>  Miles D. Oliver
> 
> --
> 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. 
> =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
> 
> 

--
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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=