OraFAQ Forum: Linux » System tablespace datafiles

Home » Infrastructure » Linux » System tablespace datafiles ( oracle 10g installation on OREL 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

System tablespace datafiles [message #556625]

Tue, 05 June 2012 13:51

thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai

Senior Member

Hi to all ;

Recently i added two datafiles under "SYSTEM TABLESPACE"
Physically i removed the path what i additionally added (system02.dbf, system.03.dbf')
after i checked file_name  from dba_data_fies.
Still it shows removed file name but physically removed.

" Please Review attached screen shot "
" I know system tablespace cant offline. I removed only addition data files i mean what i added for testing purpose"

Thanks in advance
Thiyagusham.G

Attachment: doubt1.png
(Size: 152.17KB, Downloaded 1885 times)

Report message to a moderator

Re: System tablespace datafiles [message #556630 is a reply to message #556625]

Tue, 05 June 2012 14:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> I removed only addition data files i mean what i added for testing purpose"

was the testing successful?

Report message to a moderator

Re: System tablespace datafiles [message #556647 is a reply to message #556630]

Tue, 05 June 2012 20:27

thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai

Senior Member

@ blackswan

Not finished yet. Waiting for your Reply.

Thanks

[Updated on: Tue, 05 June 2012 20:31]

Report message to a moderator

Re: System tablespace datafiles [message #556648 is a reply to message #556647]

Tue, 05 June 2012 20:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

restore the DB from backups

Report message to a moderator

Previous Topic:	Oracle 11gR2 Installation on RHEL 6.2 with VMWARE
Next Topic:	os autentication error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 29 04:07:28 CDT 2026