RE: Applying redo - recovery fundamentals

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <orcl@xxxxxxxxxxx>
  • Date: Mon, 28 Nov 2005 11:49:33 -0500

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@xxxxxxxx
36 West Street
Lebanon, NH 03766-1239
tel: (603) 448-1803
------------------------------------


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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

 >
--
//www.freelists.org/webpage/oracle-l



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


Other related posts: