RE: problem with recovery

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Sun, 22 Aug 2004 16:57:55 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKGEPNFDAA.mwf@rsiz.com>

hmm. The files online are the unrestored files, right? In that case they are *not* fuzzy, and you should be doing thing where you insist they are not in backup mode (ie. are not fuzzy). If your UNDO is not broken, then the alter open reset logs should work and roll things back.

Hope you saved images of the online logs before you did anything.

Rolling forward from an older file set and cancelling before the destroyed log block should also work.

What vintage database? If it is anything like recent, I bet Bill Bridge, et. al. will be interested. 'tain't sposa happen.

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Adams, Matthew (GE Consumer & Industrial)
Sent: Sunday, August 22, 2004 4:11 PM
To: oracle-l_at_freelists.org
Subject: RE: problem with recovery

We'll do that if we need to. I took a backup before I did anything else

Now, I'm restoring the hot backup from Aug 14. I'm going to roll it up to a point about 1 hour before the alert.log went nuts. =20

---

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com If C gives you engouth rope to hang yourself, then C++ gives you enough rope to hang yourself, your dog, your co-workers, and everyone in your neighborhood.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mladen Gogala Sent: Sunday, August 22, 2004 4:04 PM
To: oracle-l_at_freelists.org
Subject: Re: problem with recovery

On 08/22/2004 03:13:33 PM, "Adams, Matthew (GE Consumer & Industrial)" = wrote:
> Can't open with "RESETLOGS", says SYSTEM tablespace
> still needs more recovery. Guess we're up the=3D20
> creek with the proverbial means of propulsion.

Matt, if more recovery is needed, then there is a dirty and dangerous = trick.
You can set _allow_resetlogs_corruption=3DTRUE,=20

            _allow_read_only_corruption=3DTRUE then do alter database read_only resetlogs; and immediately do full export from the database. That way, you can = salvage the data=20
or what's left of it. I'm not a member of oracle support, these are = undocumented
parameters, you can do it, on your own risk.=20 --=20
Mladen Gogala
Oracle DBA

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sun Aug 22 2004 - 15:53:48 CDT