Re: need to startup database without a datafile

"Yannis Markakis" <yannis_removethis_markakis_at_yahoo.com> wrote in message news:9rklr4$psv$1_at_usenet.otenet.gr...
> Hello all,
> I got this problem,
> a server on Windows 2000 with service pack is running an 8.1.7 oracle
> database. While trying to create a large materialized view the database
> crashed and wouldn't startup again. I found that the datafile which
consists
> a tablespace in which I was creating the materialized view is corrupted
and
> by now I can mount the database but not open it.
>
> I would rather drop that tablespace and the datafile which appears to be
> corrupted that go back to the whole database restore procedure. Is there a
> way that I can start the database without this one tablespace or datafile?
>
> Excuse me if that has been posted again. Any help would be very
appreciated.
>
> Yannis
>
>

Yannis,

You can also use:

svrmgrl> startup mount
svrmgrl> alter database <db_name> datafile '<datafile_name>' offline drop;

That will let you to open the db by skipping this datafile. It is not going to actually affect the datafile.

Then use:

svrmgrl> recover datafile '<datafile_name'>;

Hope that helps.

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com Received on Mon Oct 29 2001 - 18:47:29 CST