Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]:Fwd: please help

Re[2]:Fwd: please help

From: <dgoulet_at_vicr.com>
Date: Thu, 03 May 2001 06:18:09 -0700
Message-ID: <F001.002F834B.20010503060023@fatcity.com>

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____________________
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: 
  INET: dgoulet_at_vicr.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).
Received on Thu May 03 2001 - 08:18:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US