Networker

Re: [Networker] oracle backup

2004-01-17 22:20:44
Subject: Re: [Networker] oracle backup
From: Dave Gold - News <dave2 AT CAMBRIDGECOMPUTER DOT COM>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Sat, 17 Jan 2004 22:20:03 -0500
Don't forget about the other option to the three below. BMC SQL Backtrack can 
work with Oracle, including a media management interface with NetWorker, and 
allows some advanced features not seen in Oracle, including logical restores 
from physical backups. 
I've only run into this in cases where that level of control was required, but 
have been impressed with the option that it adds.

In terms of RMAN, make sure to check with your DBA's. They need to know the 
RMAN side of things, and while it is a tremendously powerful product, some 
DBA's simply don't want to use it. Between 80 and 90% of the configuration has 
to be done by the DBA, and the restores are also pretty much controlled by 
them, so they normally "own" the decision on which method to use.

Dave



Date:    Thu, 15 Jan 2004 11:39:42 -0500
From:    Matthew Huff <mhuff AT OX DOT COM>
Subject: Re: I just don't seem to get it... Are there other do c resources?

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.


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

<Prev in Thread] Current Thread [Next in Thread>
  • Re: [Networker] oracle backup, Dave Gold - News <=