Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: corrupt sysaux file - best way to fix

Re: corrupt sysaux file - best way to fix

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 29 Mar 2005 11:29:28 -0800
Message-ID: <1112124361.811974@yasure>


SG wrote:

> Hi all.
> I posted some time ago about corrupt redo logs and still am working on
> finding the cause. I did find that the sysaux datafile also has corrupt data
> per the logs. What is the best way to correct this without backups?
> Dbrepair? I ask this because the original dba setup a routing to purge
> backups older than 7 days since the data is not needed after so many days.
> This is more of a dynamic database application and not for historical
> purposes. However, if the sysaux datafile is corrupt, we are most likely
> skipping or backing up a corrupt sysaux file, correct? Any insights? This is
> on Redhat v3, 10g Standard v10.1.0.2. Can this be at all linked to having
> random corrupt redo logs? Do we need to rebuild the database from scratch as
> a best approach to fixing the sysaux corruption, which we did once with a 1
> month success time frame, only to start getting corrupt redo logs again? Any
> ideas are greatly appreciated. TIA.
>
> SG

http://metalink.oracle.com

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Tue Mar 29 2005 - 13:29:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US