Applying redo - recovery fundamentals 2005-11-28 - By Mark W. Farnham
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@(protected)
36 West Street
Lebanon, NH 03766-1239
tel: (603) 448-1803
-- ---- ---- ---- ---- ---- ---- ---
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]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 (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
--
http://www.freelists.org/webpage/oracle-l
|
|
