|
Re: [Networker] Oracle Backups w/o rman
2008-09-24 18:14:15
Yes I would strongly recommend RMAN
as well. Most disasters don' t happen at opportune moments.
Meaning you'll want to recover the database to a particular point in time.
Oracle's recovery manager ( RMAN ) will give you this functionality.
If you lose a disk, RMAN can handle the recovery flawlessly.
You can use RMAN to backup to disk if you like, then backup
those files to tape. To recover, restore to the disk backup location.
|
|
Doug Brown
IT Team Lead
Corporate Information Technology
ATS - Database Engineering
SAP Databases
| Abbott Laboratories
Bldg: NWJ46, Dept: GA25
| Office (847)935-1366
Cell (847)404-7723
Doug.Brown AT abbott DOT com
|
|
|
|
|
Bruce Breidall <Bruce.Breidall AT CONCUR DOT COM>
Sent by: EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU>
09/24/2008 01:35 PM
|
Please respond to
EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU>; Please
respond to
Bruce Breidall <Bruce.Breidall AT CONCUR DOT COM> |
|
|
To
| NETWORKER AT LISTSERV.TEMPLE DOT EDU
|
|
cc
|
|
|
Subject
| Re: [Networker] Oracle Backups w/o rman |
|
I would strongly urge you to push for oracle backups
via RMAN. The DBAs
will thank you in the end, and your life will be so much easier. It is
the right thing to do, and the way the industry is going.
If you don't use RMAN, then you have to worry about duplicate backups
and how to accommodate for change without anybody telling you. You will
have to have oracle quiesce pre and post scripts to run with Legato, or
run everything outside of legato via scripts and commands. Each method
has it's own pros and cons.
Push for rman.
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Yard, John
Sent: Wednesday, September 24, 2008 12:34 PM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] Oracle Backups w/o rman
I have a Legato 7.4.1 system
on AIX 5.3 which backups up a
number of Oracle databases.
Our strategy is to backup the Oracle
databases to disk , then backup the
Oracle backup os files to tape, then
delete the oracle backups.
In addition we backup the os filesystems
to tape . If I backup the oracle
file systems to Legato I will have a
massive duplication of data. Since Oracle
is not being terminated, these backups are
not valid for recovery, yet I need a structure
for the dba to recover into if we were to lose
a disk.
I am sure there is documentation in
respect to this issue, can this group
suggest some starting points ? Comments ?
Thank You,
JYard
UCLA
To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the body of the email. Please write
to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
To sign off this list, send email to listserv AT listserv.temple DOT edu and type
"signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at http://listserv.temple.edu/archives/networker.html
or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
|
|
|
