Re: Help with database corruption issue
From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Fri, 3 Aug 2012 11:49:48 +0100
Message-ID: <CAPMSPxNmXzLz4CeaDZUWCcJj49EzJo94z8OzpcNi0FgOwdoYEQ_at_mail.gmail.com>
Hi,
Well for some reason the ext4 file system had errors, leading to lost data. That impacts the undo tablespace data file and Oracle could not recover. All I can think is that at some point in time the ext4 file system was not 100% OK and then when you made the data file copy is had been fixed. What sort of disk layout do you have, maybe the error was corrected by way of a disk mirror or some other RAID set-up protection?
Date: Fri, 3 Aug 2012 11:49:48 +0100
Message-ID: <CAPMSPxNmXzLz4CeaDZUWCcJj49EzJo94z8OzpcNi0FgOwdoYEQ_at_mail.gmail.com>
Hi,
Well for some reason the ext4 file system had errors, leading to lost data. That impacts the undo tablespace data file and Oracle could not recover. All I can think is that at some point in time the ext4 file system was not 100% OK and then when you made the data file copy is had been fixed. What sort of disk layout do you have, maybe the error was corrected by way of a disk mirror or some other RAID set-up protection?
Regards
Pete
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 03 2012 - 05:49:48 CDT