Re: datafile corrupt, shutdown abort, datafile online

From: gazzag <gareth_at_jamms.org>
Date: 26 Apr 2007 04:51:20 -0700
Message-ID: <1177588279.909306.278130@b40g2000prd.googlegroups.com>

On 26 Apr, 05:25, Steve Robin <ocma..._at_gmail.com> wrote:
> Well I know some of you will not like me asking this question.
> But I still ask because it will clear my doubt.
> My database is in NOARCHIVELOG mode, my datafile is corrupted and
> database is shutdown abort. Is there any way to start database without
> making it offline.
>
> Database : oracle 9i
> Operating System : any platform

As you're in NOARCHIVELOG, you must restore from an earlier consistent backup to open your database successfully.

HTH -g Received on Thu Apr 26 2007 - 06:51:20 CDT