Re: datafile corrupt, shutdown abort, datafile online

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 26 Apr 2007 20:31:28 +0200
Message-ID: <f0qr0g$3b9$1@news2.zwoll1.ov.home.nl>

Steve Robin schreef:
> 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
>

??? - it actually is "offline" (not opened) right now. And, until you restored the previous backup, it will stay that way.

What datafile is corrupted (as the db crashed ("shutdown abort"?), I suspect your system tablespace - you're hosed if it is!)?

You could take that offline, and subsequently take the tablespace offline.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Thu Apr 26 2007 - 13:31:28 CDT