Re: Using RMAN

Ruth,
I have a couple of questions

1. As I understand from your email ,you do incremental level 0 backups in the morning and level 1 backups in the evening and night everyday using RMAN...right. You mentioned that you also take the backups (i.e level 0 and 2 level 1's for a day )on tape every morning. Do you use RMAN to take the tape backups? If not then RMAN doesn't remember the tape backup . If you had a failure in the evening then you would just restore the level 0 and then apply the subsequent level 1 backup and the archived logs ,...right?

My question is how big is your production database? How much time does it take to do
1. level 0 backup
2 level 1 backups

Also how resource intensive are the incremenatal level 0 and level 1 backups like in terms of CPU,I/O etc since you do it in the middle of the day.

Could you please tell me more about the tape backups that you do?Like what media magmt sortware are you using .We will be using Veritas Netbackup here.

Thanks
 Sona

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 17, 2002 11:55 AM

> We use rman to backup all of our databases. But most importantly, we use
it
> for production. Production databases are in archivelog mode. We do a
level
> 1 backup at the end of the work day and prior to nitely batch processing.
> We do a level 0 backup early in the morning after batch and before users
get
> on.
>
> We but a full days worth of backups, including the archivelog backups, on
a
> tape in the morning. There is one tape for each day of the week, Mon-Fri.
> We delete archivlogs from the archive log destination after backing them
up.
>
> Production is backed up while it is open. Test and developement databases
> are not in archivelog mode so we have to back them up while they are not
> available to users.
>
> HTH,
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, January 17, 2002 12:45 PM
>
>
> > See currently we are using Unix scripts to do our hot backups .We take
the
> > backup on disk and everynight after the disk backup we copy the backup
on
> > tape using Veritas Net Backup.
> > Presently we keep 2 days worth of backups on the disk and 3 days of
> archive
> > logs.That means at any point in time i have the last 2 days backup on
disk
> > (just for fatster recovery so that we can aviod going to tapes in case
of
> a
> > failure).
> > Now if we start using RMAN ,we would be taking hot backups (mostly using
> > increamental strategy) using RMAN.So for e.g. we start on say sunday
> taking
> > an incremental level 0 backup on disk.RMAN only remmbers the disk
backup
> > ...right???? Note that we will also be copying the backups on tape but
> that
> > will be independent of RMAN since it is not done using RMAN.
> > Say the next 3 days of the week ,we do increamental level 1 backups .On
> the
> > 3 rd day (i.e. Wednesday) i would have only Monday's and Tuesdays'
backup
> > on disk (which are the inceemental llevel 1 backups since the whole
ideas
> is
> > to keep last 2 days backup om disk).
> > So if we have a failure on Wednesday then RMAN would look for the
> > incremental level 0 backup of Sunday on the disk but that backup is not
> > present on the disk now.
> > I hope i have cleared it up enough.
> > Now my question is can we maintain the same policy of keeping 2 days
> backup
> > on disk by using RMAN.
> > What kind of backup strategies do RMAN users follow? Are RMAN backups
> > usually taken on tape directly ? Is it faster to take backups on tape
> rather
> > on disk while using RMAN?
> >
> > Could RMAN users share their backup/recovery strategies ,please.
> >
> >
> > TIA
> >
> >
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Thursday, January 17, 2002 5:55 AM
> >
> >
> > > If you are using a recovery catalog then rman keeps track of
everything
> > > there. He knows if you've been naughty, he know if you've been nice,
he
> > > knows....OOOPS I got carried away. But when you do a restore using
> rman
> > he
> > > will tell you what backup sets you will need.
> > >
> > > Ruth
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Wednesday, January 16, 2002 6:20 PM
> > >
> > >
> > > Hi
> > > Currently we are using Unix scripts to do backups.We keep last 2 days
of
> > > backups on the disk and also take the backups on tape daily.
> > > We are planning to use RMAN for backups and would like to maintain the
> the
> > > same policy of 2 days backup on disk and daily tape backups.
> > > Is it possible to implement this using RMAN? Which backup will RMAN
> > remember
> > > (while restore) the disk backup or the tape backup?
> > > If we try to use the incremental strategy ,then how would RMAN
remember
> > the
> > > last incremental level 0 backup ? It will not be present on disk since
> we
> > > only keep the last 2 days backup on it.
> > > How do i use RMAN to do restore/recovery in this case?
> > >
> > >
> > > I heard that taking backups on tape is faster than on disk when using
> > RMAN?
> > > Is it true?
> > >
> > > Could RMAN users share their backup/recovery strategies ,please.
> > >
> > > TIA
> > >
> > >
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Ruth Gramolini
> > > INET: rgramolini_at_tax.state.vt.us
> > >
> > > 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).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Sona
> > INET: sona_us_at_hotmail.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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sona
  INET: sona_us_at_hotmail.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).