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.


--- [EMAIL PROTECTED] 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@mehish.       To:     Multiple recipients
> of list ORACLE-L <[EMAIL PROTECTED]>      
>                     co.il>               cc:                         
>                                             
>                     Sent by:             Subject:     RE: Disaster
> recovery using  RMAN                           
>                     [EMAIL PROTECTED]                                   
>                                             
>                     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
> [EMAIL PROTECTED]
> 
> > -----Original Message-----
> > From:         DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
> > 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.
> > [EMAIL PROTECTED]
> >
> >
> > -----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" <[EMAIL PROTECTED]>
> > 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@LIFE       To:     Multiple
> recipients
> of
> > list ORACLE-L <[EMAIL PROTECTED]>
> > >                     TOUCH.COM>            cc:
> > >                     Sent by:              Subject:     RE:
> Disaster
> > recovery using  RMAN
> > >                     [EMAIL PROTECTED]
> > >                     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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to