RE: problem with recovery
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 22 Aug 2004 16:57:55 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Adams, Matthew (GE
Consumer & Industrial)
Sent: Sunday, August 22, 2004 4:11 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mladen Gogala
Sent: Sunday, August 22, 2004 4:04 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
