Applying redo - recovery fundamentals 2005-11-27 - By orcl
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 (See ORA-00279.ora-code.com): change 4157085 generated at 11/27/2005 21:31:00 needed for
thread 1
ORA-00289 (See ORA-00289.ora-code.com): suggestion : J:\ARCHIVE_DEST\ORCL\ORCL_1_69_575366883.ARC
ORA-00280 (See ORA-00280.ora-code.com): change 4157085 for thread 1 is in sequence #69
ORA-00278 (See ORA-00278.ora-code.com): 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
|
|
