Re: Re[2]:Fwd: please help

DIck,

Totally agree. I just wanted to make sure that the newbies out there understand the implications.

Of course, they should read 'Oracle Backup & Recovery Handbook' cover to cover and do all the exercises.

Jared

On Thursday 03 May 2001 05:57, dgoulet_at_vicr.com wrote:
> Jared,
>
> I agree, The online redo logs should never be restored back onto a
> system that is otherwise running. But the intent is to make a hot backup
> that could be restored to a completely blank system, which I believe was
> being done here. In that case you need the online logs if for nothing else
> so that they are there.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Subject: Re:Fwd: please help
> Author: Jared Still <jkstill_at_cybcon.com>
> Date: 5/2/2001 4:55 PM
>
>
> Dick,
>
> Backing up the redo logs can have some serious consequences.
>
> Let's say you are restoring the database files, and a number of
> archived logs to roll forward through.
>
> Following that, you are going to roll forward through all archived logs
> that are still online, and then through your current redo logs for a
> complete recovery.
>
> Restoring old redo logs would render this strategy ineffective.
>
> Backing them up can be a good thing, but it would be very easy
> to inadvertently wipe out the current ones when restoring from tape.
>
> Best practice of course is to make a backup of your database in
> it's current condition prior to restoring it.
>
> It would also be prudent to make copies of the redo logs locally
> so you don't have to restore them from tape.
>
> Jared
>
> On Wednesday 02 May 2001 07:24, dgoulet_at_vicr.com wrote:
> > Jonathan,
> >
> > It would appear that your friend has hit upon one of the problems of
> > hot backups that everyone misses and actually Oracle recommends against.
> > That is backing up your online redo log files and doing that LAST. The
> > reason is that there are more than likely active transactions that were
> > recorded therein and those logs are not available. Can he complete the
> > recovery, maybe if he has the remaining logs from the active system, I'm
> > assuming he is recovering to somewhere other than his production system.
> > Otherwise his only recourse is OTS.
> >
> > Dick Goulet
> > Oracle Certified 8i DBA
> >
> > ____________________Reply Separator____________________
> > Author: Jonathan Gennick <jonathan_at_gennick.com>
> > Date: 5/1/2001 8:55 PM
> >
> > Fellow list members, I received the following email from a
> > reader a few minutes ago. If you skip down to where he talks
> > about backup, you'll see that he's in trouble with a
> > database that won't recover. I've already suggested that he
> > open a TAR, and that he supply more specifics as to error
> > messages and the like, but maybe someone on this list can
> > draw some conclusions from what he's told me so far. If
> > you're good at recovery, have a look at what he says. I'll
> > post his email address later if he says its ok, and I'll
> > pass on any advice/suggestions I receive in the meantime.

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