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

From: Jared Still <>
Date: Thu, 31 Oct 2013 06:40:37 -0700
Message-ID: <>

On Thu, Oct 31, 2013 at 1:23 AM, De DBA <> wrote:
> online redo logs were too new, and are now stale anyway (due to
> controlfile recreate)

Have you tried applying the redo logs?
Oracle cannot, due to the controlfile issues

SQL> recover database using backup controlfile until cancel

Then specify the redo logs, rather than archive logs

You may get lucky and not need the redo log with the corrupt header.

A colleague and I have restored 3 production databases this year using that method,
and I've used it a few times in the pas as well.

Two of those emergency restores subsequently became clients. :)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: Home Page:

Received on Thu Oct 31 2013 - 14:40:37 CET

Original text of this message