Re: Applying redo - recovery fundamentals
- From: orcl <orcl@xxxxxxxxxxx>
- Date: Sun, 27 Nov 2005 21:42:17 -0500
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
Other related posts: