Hi,
your error more resembles a media failure than
anything else. Check the status column from
v$datafile. since this is the system datafile u seem
to have lost,you would need a closed full db recovery
.. i.e. is you care to recover your test db :)
Deepak
PS: did you delete the system datafile instead of the
system user?
- Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
wrote:
> hi ....
>
> I took risk in my test DB by dropping the user
> 'SYSTEM'. As you tested, the
> same steps i repeated in mine, all are fine, until
> before.
>
> Now i shutdown my database and startup again, here
> the problem arises.
> Oracle mount the database but while opening the
> database, the instance has
> been terminated by PMON.
>
> Sat Oct 20 10:57:45 2001
> PMON: terminating instance due to error 470
> Instance terminated by PMON, pid = 316
>
> Oracle posted the following error continuosly in the
> alert log:
>
> SMON: following errors trapped and ignored:
> ORA-00376: file 1 cannot be read at this time
> ORA-01110: data file 1:
> 'D:\ORACLE\ORADATA\ORCLSVR\SYSTEM01.DBF'
>
> Am crusious, come to know what type of problem you
> have faced?....
>
> Regards,
> Nirmal
> > -----Original Message-----
> > From: Jacques Kilchoer
> [SMTP:Jacques.Kilchoer_at_quest.com]
> > Sent: Friday, October 05, 2001 12:30 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Droping System User
> >
> > > -----Original Message-----
> > > From: Jared.Still_at_radisys.com [
> <mailto:Jared.Still_at_radisys.com>]
> > >
> > > Dropping the SYSTEM user is not really all that
> traumatic.
> > >
> > > In most cases it's just a DBA account that may
> own some pieces you'd
> > > rather not lose, but dropping SYSTEM will not be
> noticed by the users
> > > of the database.
> >
> >
> > That's the impression I get. When I looked at the
> objects owned by SYSTEM
> > in my test database before the drop, none of them
> seemed vital.
> >
> > On the other hand, dropping sys would probably be
> bad, but I wasn't able
> > to do that (insufficient privileges.)
> > Trying to drop sys tables like sys.user$ caused an
> ORA-00701.
> > So since I'm on a quest to wound this database, I
> tried this:
> >
> > SQL> delete from sys.user$ where name = 'SYS' ;
> > 1 ligne supprimée.
> > SQL> commit ;
> > Validation effectuée.
> >
> > So far no ill effects!
> >
>
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
INET: deepakthapliyal_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Oct 22 2001 - 11:48:07 CDT