Re: Backup & Recovery Strategy

I am sorry, I have never done that. We have always restored/recovered in the same place.

I am posing this to the lists in hopes that you will get an answer from someone else who has done this.

Ruth
----- Original Message -----
From: Jim Beachy <jbeachy_at_kimball.com>
To: 'Ruth Gramolini' <rgramolini_at_tax.state.vt.us> Sent: Friday, May 12, 2000 10:32 AM
Subject: RE: Backup & Recovery Strategy

> Ruth, we have used EBU extensively, and have done hundreds of test
> recoveries as part of our testing plan and training. Generally we do this
> to a dedicated recovery server. (HPUX 10.20, Oracle 7.3.4)
>
> We are now doing RMAN with 8.0.6, again using a master catalog. We have
> done a number of test restores to the same server where the database sits,
> but have not yet done any to an alternate server.
>
> With EBU, we need to do a number of things in order to accomplish the
> restore/recovery to an alternate server - Legato Networker settings,
> environment settings, path setups, etc. I assume that this will need to
be
> the case for RMAN as well.
>
> Might you have a set of 'Restore/recover database to an alternate server'
> instructions that we could start with?
>
> Thanks.
>
>
>
> -----Original Message-----
> From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
> Sent: Wednesday, May 10, 2000 7:41 AM
> To: Hamid Niazi
> Cc: oracledba_at_lazydba.com
> Subject: Re: Backup & Recovery Strategy
>
>
> RMAN does easy online backups as part of it's incremental strategy (5
levels
> of incrementals). In order to do rman incrementals you have to do a full
> backup , level 0, and all of the incrementals are based on that.
>
> I have used rman since the beginning and it has only gotten better with
> later releases. 8.0.5.1 is very stable.
>
> Ruth B. Gramolini
> ORACLE DBA
> VT Dept. of Taxes
> ph# 802.828.5708
> fax# 802.828..3754
> rgramolini_at_tax.state.vt.us
> ----- Original Message -----
> From: Henry O'Keeffe <Henry.O'Keeffe_at_ft.com>
> To: Hamid Niazi <HamidN_at_eo.net>
> Cc: <oracledba_at_lazydba.com>
> Sent: Wednesday, May 10, 2000 8:17 AM
> Subject: Re: Backup & Recovery Strategy
>
>
> > I think you should start backing up the whole lot from the begining.
> You'll
> > have to do so eventually.
> >
> > H.
> >
> >
> >
> >
> > Hamid Niazi <HamidN_at_eo.net> on 05/10/2000 01:19:05 PM
> > To: oracledba_at_lazydba.com
> > cc: (bcc: Henry O'Keeffe/PSD/LONDON/FTI)
> >
> > Subject: Backup & Recovery Strategy
> >
> >
> >
> > Dear DBAs
> >
> > Any advice on the following sceneario.
> > 50 Gig DB,
> > 24/7,
> > Practically empty but due to go into full use in the comming weeks
> > and will gradually fill up.
> >
> > I don't feel like backingup 50G of empty datafiles as would occur
> > with pure online backups.
> >
> > I was considering using RMAN in conjunction with online bachups
> > in order to take advantage of incremental backups and compressed
> > backups (only data blocks written to are backed up and empty blocks
> > are ignored).
> >
> > Anyone have any advice on RMAN or any othewr useful strategies.
> >
> > Regards,
> > Hamid
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated
> > daily)
> > to unsubscribe, send a blank email to
oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> >
> >
> >
> >
> >
> >
> > *********************************************************************
> > * Please visit the web site of the Financial Times at: *
> > * http://www.ft.com *
> > * *
> > * This E-Mail is intended for the use of the addressee only and may *
> > * contain confidential information. If you are not the intended *
> > * recipient, you are hereby notified that any use or dissemination *
> > * of this communication is strictly prohibited. *
> > * If you receive this transmission in error, please notify us *
> > * immediately then delete this E-Mail. *
> *
> > * *
> > * postmaster_at_ft.com *
> > *********************************************************************
> >
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to
oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> >
> >
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
Received on Fri May 12 2000 - 09:57:07 CDT