RE: Applying redo - recovery fundamentals

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Mon, 28 Nov 2005 11:49:33 -0500
Message-ID: <KNEIIDHFLNJDHOOCFCDKMELCHEAA.mwf@rsiz.com>

Slight quibble.

As the first step of restore, if you preserve the CURRENT online redo logs (perhaps in a directory called "try_again") and something goes very wrong in the recovery that includes pollution of the online redo logs, then you will be able to try again. I agree that you should not restore something over the top of the CURRENT online redo logs from backup tapes or online backups that is older than the CURRENT online redo logs unless a cold previous version of your database is what you intend to produce.

This handles the case, for example, where you typed in a time a little to near the present in your "recover until" statement or failed to cancel soon enough and proceed through "open resetlogs." As you curse yourself for making the mistake, at least you will be able to try again.

Regards,

Rightsizing, Inc.
Mark W. Farnham
President
mwf_at_rsiz.com
36 West Street
Lebanon, NH 03766-1239
tel: (603) 448-1803

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of orcl Sent: Sunday, November 27, 2005 9:42 PM
Cc: oracle-l
Subject: Re: Applying redo - recovery fundamentals

NEW pop.tiscali.de wrote:

>You shouldn't be copying the online redo logs in any case, backup or
>restore. You only need to backup archived redo logs.
>
>Try step 4 without copying back the online redo logs.
>
>

OK, I see the error. I was copying the online redo logs AND control files. The only files needed were the *.dbf Shoudl have known/researched that.

Recovery worked perfectly

thanks!

.............

ORA-00279: change 4157085 generated at 11/27/2005 21:31:00 needed for thread 1

ORA-00289: suggestion : J:\ARCHIVE_DEST\ORCL\ORCL_1_69_575366883.ARC
ORA-00280: change 4157085 for thread 1 is in sequence #69
ORA-00278: log file 'J:\ARCHIVE_DEST\ORCL\ORCL_1_68_575366883.ARC' no

longer needed for this recov
ery

Log applied.
Media recovery complete.
>
> alter database open resetlogs;

Database altered.

> select count(*) from bitmap_count;

COUNT(*)

140000

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 28 2005 - 10:52:13 CST