Comments below.
HJR
--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources: http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------
"Scott Watson" <rscottwatson_at_hotmail.com> wrote in message
news:W%4H5.4635$My1.182524_at_wagner.videotron.net...
> See comments....
>
>
> <susana73_at_hotmail.com> wrote in message
news:8sijks$fdj$1_at_nnrp1.deja.com...
> > Hi there,
> >
> > I am doing cold backup in archive mode on my production database. I
> > have two questions regarding recovery:
>
> Why are you archiving if you are only doing a cold backup.
>
Scott, this comment (and the others below) is/are total gibberish. There
are perfectly good reasons to be taking archives (ie, the ability to
guarantee recovery to the time of failure), totally independent of the
manner in which you choose to take backups. All taking archives means is
that you have the *choice* of doing hot or cold backups. Without archives,
you have no choice -you *must* do cold backups. With archives, it's
entirely up to you what you do (and cold backups have the distinct advantage
of being a total doddle to perform).
> >
> > 1.If one of the datafiles corrupted, can I just replace that
> > particular file from the backup and then apply the archive logs?
> >
> Not from a cold backup you need to perform a hot backup. (eg alter
> tablespace begin backup ....)
>
Utter crap.
>
> > 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?
> >
> Again no, you cannot apply archive log files to a cold backup.
>
Even worse crap.
Scott: please go learn something about backup and recovery before you start
dispensing "advice" to the general public. Mistakes are something we all
make from time to time: for ignorance, there is no excuse.
HJR
> > Thanks in advance,
> >
> > Susan
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Wed Oct 18 2000 - 05:42:36 CDT
