OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Tablespace offline (Oracle sqlplus, 10g, Windows XP)

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

Tablespace offline [message #488079]

Tue, 04 January 2011 09:59

getritesh
Messages: 235
Registered: July 2006
Location: INDIA

Senior Member

Hi,

I executed

ALTER TABLESPACE TS ONLINE;

It gave me ORA-0113 needs media recovery
ORA-01110 file 8 datafile : 'datafile path'

Regards,
Ritesh

Report message to a moderator

Re: Tablespace offline [message #488082 is a reply to message #488079]

Tue, 04 January 2011 10:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I executed ALTER TABLESPACE TS ONLINE;
>It gave me ORA-0113 needs media recovery ORA-01110 file 8 datafile : 'datafile path'

normal & expected behavior.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Tablespace offline [message #488083 is a reply to message #488082]

Tue, 04 January 2011 10:13

getritesh
Messages: 235
Registered: July 2006
Location: INDIA

Senior Member

Hi,

I executed

SQL> ALTER TABLESPACE TS ONLINE;

ORA-0113 needs media recovery
ORA-01110 file 8 datafile : 'datafile path'

Please guide me in this

Regards,
Ritesh

[Updated on: Tue, 04 January 2011 10:16]

Report message to a moderator

Re: Tablespace offline [message #488084 is a reply to message #488083]

Tue, 04 January 2011 10:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

is DB in archive mode?
do archived redo log file exist from when TS was taken offline?

Report message to a moderator

Re: Tablespace offline [message #488085 is a reply to message #488079]

Tue, 04 January 2011 10:33

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Try

recover datafile 8;

Regards
Michel

Report message to a moderator

Previous Topic:	oracle installation (merged 6)
Next Topic:	restarting the listener and database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:31:14 CST 2024