and in any case, I truly believe you should do the backup to disk and
then back that up to tape...
what happens if there is a problem with the tape drive? Will the backup
hang because it's stuck?
Just easier.
- Cherie_Machler_at_gelco.com wrote:
>
> Yechiel,
>
> I believe that Dennis is moving towards backing up to tape. This is
> just
> his first step in testing and implementing RMAN. It's a pretty
> complex
> tool to use and takes quite a while to fully implement. RMAN can be
> pretty overwhelming and Dennis is trying to bite off small bits and
> try to
> get those working before moving forward to add more complexity.
>
> I know some people are put off by the work involved with getting RMAN
> going
> but once it's set up, it's a great, reliable tool. I give Dennis
> credit
> for trying to tackle it and keeping us apprised of the method he's
> using to
> do so. I think lot's of other folks out there would like to
> implement
> RMAN and could learn from his travails.
>
> Cherie Machler
> Oracle DBA
> Gelco Information Network
>
>
>
>
> אדר יחיאל
>
> <adary_at_mehish. To: Multiple recipients
> of list ORACLE-L <ORACLE-L_at_fatcity.com>
> co.il> cc:
>
> Sent by: Subject: RE: Disaster
> recovery using RMAN
> root_at_fatcity.c
>
> om
>
>
>
>
>
> 01/18/02 02:15
>
> AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
> Hello Dennis
>
> I think that you need to backup the disk files to tape A.S.A.P.
> What will you do if your disk has gone to the great disk scrap yard
> in the
> sky?
> One more point: Is the disk on the same machine or in the same room?
> What will you do if a fire will destroy your server farm?
>
> To get a good backup you need to replicate the disks to a remote site
> or backup them to tapes and put the tapes in remote site.
>
> Yechiel Adar, Mehish Computer Services
> adary_at_mehish.co.il
>
> > -----Original Message-----
> > From: DENNIS WILLIAMS [SMTP:DWILLIAMS_at_LIFETOUCH.COM]
> > Sent: Fri, January 18, 2002 4:05 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Disaster recovery using RMAN
> >
> > Sona -
> > Please keep in mind that we are RMAN novices at this
> stage. Of
> all
> > the DBA duties, I feel that the ability to recover the data is the
> most
> > important.
> > I picked our smallest database to start getting some
> operational
> > experience with. We still do weekly cold backups, writing the
> results to
> > tape because I haven't worked with RMAN long enough to have full
> > confidence
> > in it. The database is archivelog, of course.
> > Currently I do a weekly RMAN level 0 backup to disk. We
> don't
> have a
> > Media Manager like Legato or Veritas yet, and we were warned that
> RMAN
> > gets
> > much more complex when these are used, so I thought disk backups
> sounded
> > like a good way to begin.
> > During the week we do RMAN incremental backups each night.
> This
> > takes up very little disk space. My feeling is that with the weekly
> cold
> > backup we are heavily dependent on our archive logs and with the
> RMAN
> > incremental backup we would only be vulnerable for a day if an
> archive
> log
> > was lost. Recall that during recovery, Oracle reads the archive
> logs in
> > sequence and if for some reason an archive log is missing or
> unusable,
> > recover stops there.
> > We keep the week's RMAN backups on disk. Presumably if we
> had a
> > failure, RMAN would have what it needs on disk. Before a backup is
> deleted
> > from disk it is written to tape as part of the regular full system
> > backups.
> > I was having RMAN archive the archivelogs, but I couldn't
> figure
> out
> > what this was buying me and it doubled the amount of disk needed
> for the
> > archive logs. If we were using a media manager so RMAN was writing
> to
> > tape,
> > then this would be great, but since we are only backing up to disk,
> I
> felt
> > it wasn't needed.
> > I hope this gives you the details you need. As I said, I
> am an
> RMAN
> > novice, but always willing to answer more questions as I am able.
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> >
> >
> > -----Original Message-----
> > Sent: Thursday, January 17, 2002 11:46 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Dennis,
> > Could you please share your regular backup strategies with me for
> me to
> > understand this better?
> >
> > Thanks
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Thursday, January 17, 2002 9:00 AM
> >
> >
> > >
> > > Dennis,
> > >
> > > I hope you can clarify something in your plan for me.
> > >
> > > Why are you backing up to disk? By doing so, you are losing one
> of the
> > > chief benefits of RMAN. RMAN keeps a catalog of the tapes and
> knows
> > > which tapes to request to restore a backup, and which files to
> retrieve
> > > from those tapes.
> > >
> > > Do you backup the disk files to tape without the benefit of any
> tape
> > > management software? Do you manually label the tapes?
> > >
> > > Thanks,
> > >
> > > Jared
> > >
> > >
> > >
> > >
> > >
> > > DENNIS WILLIAMS
> > > <DWILLIAMS_at_LIFE To: Multiple
> recipients
> of
> > list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > TOUCH.COM> cc:
> > > Sent by: Subject: RE:
> Disaster
> > recovery using RMAN
> > > root_at_fatcity.co
> > > m
> > >
>
=== message truncated ===
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jan 18 2002 - 08:46:35 CST
