Re: Applying redo - recovery fundamentals

From: orcl <orcl_at_comcast.net>
Date: Sun, 27 Nov 2005 21:42:17 -0500
Message-ID: <438A6E89.6070307@comcast.net>

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

Received on Sun Nov 27 2005 - 20:54:07 CST