Re: question on cold backup(in archive mode)

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 18 Oct 2000 20:45:12 +1000
Message-ID: <39ed71a0@news.iprimus.com.au>

You said it nicer than me, Doug! But your last sentence here about says it all.

I'm copying for future use in Backup and Recovery courses (I hope there's no licensing fee), and I'm hoping that Scott will maybe show up at one!

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"Doug" <zuestra_at_hotmail.com> wrote in message
news:uq3qus4hlfrtldhoo2jrjgih7p5udbv59u_at_4ax.com...


> Uh.. by the way.. clearly scott is doing hot backups.  I hope he has a

> good reason.. For most shops without a 24x7 requirement, cold backups

> and archives are the way to go..

>

>

> On Tue, 17 Oct 2000 22:25:40 GMT, susana73_at_hotmail.com wrote:

>

> >Hi there,

> >

> >I am doing cold backup in archive mode on my production database.  I

> >have two questions regarding recovery:

> >

> >1.If one of the datafiles corrupted, can I just replace that

> >particular file from the backup and then apply the archive logs?

> >

> >2.If I recover ALL the datafiles from yesterday backup(the database

> >become valid in yesterday version), can I still apply the archive logs

> >so that I can get back all the updated data as of today?

> >

> >Thanks in advance,

> >

> >Susan

> >

> >

> >Sent via Deja.com http://www.deja.com/

> >Before you buy.

>

Received on Wed Oct 18 2000 - 05:45:12 CDT