OraFAQ Forum: Linux » System tablespace datafiles

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

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

Switch to threaded view of this topic

Create a new topic

Submit Reply

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 20 times)

Report message to a moderator

Send a private message to this user

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

Tue, 05 June 2012 14:20

BlackSwan
Messages: 20086
Registered: January 2009

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

Send a private message to this user

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

Send a private message to this user

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

Tue, 05 June 2012 20:54

BlackSwan
Messages: 20086
Registered: January 2009

Senior Member

restore the DB from backups

Report message to a moderator

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

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: Sat May 18 23:07:34 CDT 2013

Total time taken to generate the page: 0.06634 seconds