Re: Oracle 8i crashed: system ts needs more recovery - how do I recover from this?

From: De DBA <dedba_at_tpg.com.au>
Date: Fri, 01 Nov 2013 11:05:30 +1000
Message-ID: <5272FE5A.8000203_at_tpg.com.au>

There was a backup script, which simply used xcopy to copy the entire Oracle installation, including the database, to a mounted drive. For some reason that has been failing since 25/7 and no-one noticed.. I'm fairly positive that it ran, as the database was shutdown and restarted every day.

I tried to apply the redo logs, which made me even more wary of mixed file versions: the last log file contains an expected sequence number, but the penultimate redo log contains a sequence number that was generated on 9 August. The alertlog clearly shows that the redo logs have been switching normally until a few days before the crash (the tail of the file is unfortunately severely corrupted..) Something very fishy has been going on with this filesystem.

Cheers,
Tony

On 01/11/13 00:19, Jared Still wrote:
> On Thu, Oct 31, 2013 at 6:40 AM, Jared Still <jkstill_at_gmail.com> wrote:
>> Have you tried applying the redo logs?
>> Oracle cannot, due to the controlfile issues
>>
> Never mind - I missed the bit about the restored files from July along the
> way.
>
> Really, no backups?
>
> Hopefully that situation is changing soon...
>
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> Oracle Blog: http://jkstill.blogspot.com
> Home Page: http://jaredstill.com
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 01 2013 - 02:05:30 CET