Re: Production Database stays up; copies will not recover

Hi!

Oracle can only guarantee database consistency and sanity when it's underlying layers like OS and disk controllers do not fail. Try:

Startup mount;
select distinct resetlogs_change# from v$datafile_header;

Do you see only one distinct change#?

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 01, 2003 8:34 PM

> Tru64 5.1
> 8.1.7.3
> We had a disk controller fail last week, but redundant hardware let the
> system stay up until it could be replaced over the weekend. The
production
> database restarted without any problems, trace files, or alert log errors.
>
> The problem is that the reporting copy of production, taken from a disk
> mirror break (hot backup, mounted on a seperate system) will not recover.
I
> get an ORA-1190 'controlfile or data file 1 is from before the last
> RESETLOGS' but the last resetlogs was over a month ago. First attempt to
> solve was to use a slightly older copy of the SYSTEM datafile from an
> earlier backup disk mirror break (hot backup). Results were the same. I
> then assumed something was wrong with the controlfile, so I tried to
rebuild
> that. No luck, the Create controlfile command returned a ORA1189 'file is
> from a different RESETLOGS than previous files' against file#2 (even
though
> I replaced the file# 1's datafile with the original [neither copy of #1
was
> opened]).
>
> My worries are two-fold; 1) that there is a subtle error in the control
file
> or SYSTEM datafile that only an attempted recovery exposes and 2) any
backup
> taken after the hardware failure last week will not be viable.
>
> Any suggestions as how to proceed to either prove or disprove this.
>
> Thanks,
> Mike Hand
> Polaroid Corp
>
> P.S. I had hoped to go on vacation at the end of the week leaving a
stable
> database behind (for a change).
>
> This transmission is intended only for use by the addressee(s) named
herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hand, Michael T
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).