Tablespace Offline

[sethi_kapi]

Hello All,
I have a small problem.In my database,i have made a tablespace offline with alter tablespace userdata offline immediate command.When i try to make it online, i am getting error that related file require recovery.how i can this tablespace online.
Thanks.

[jovery]

If you take a tablespace offline with the immediate clause the associated datafiles are not checkpointed. Therefore as the error implies you will need to perform a media recovery (using recover datafile ...) on the datafile before bringing online.

regards

[Sameer]

Here it is

SQL> insert into scott.delme values ('delete me');
1 Zeile verarbeitet.
SQL> insert into scott.delme values ('delete me');
1 Zeile verarbeitet.
SQL> insert into scott.delme values ('delete me');
1 Zeile verarbeitet.
SQL> insert into scott.delme select * from scott.delme;
8 Zeilen verarbeitet
SQL> select tablespace_name from all_tables where table_name = 'DELME';
TABLESPACE_NAME
------------------------------
USERS
1 Zeile ausgewShlt.
SQL> alter tablespace users offline immediate;
Anweisung verarbeitet
SQL> alter tablespace users online;
alter tablespace users online
*
ORA-01113: Fnr Datei '3' ist DatentrSger-Recovery notwendig
ORA-01110: Datendatei 3: 'D:\ORACLE\ORADATA\ORCL\USERS.DBF'
SQL>
SQL>
SQL> alter database recover tablespace users;
Anweisung verarbeitet
SQL> alter tablespace users online;
Anweisung verarbeitet
SQL>

HTH

[sethi_kapi]

Thanks Sameer,for ur reply.I have got this error
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-00281: media recovery may not be performed using dispatcher
when i try to perform
alter database recover tablespace userdata;
what should i do know.

[hrishy]

Hi

In order to these kind of activites you need a dedicated session.I c that you are connecting using MTS..

ORA-00281: media recovery may not be performed using dispatcher

get a dedicated connection..

regards
Hrishy

[sethi_kapi]

Thanks for such a prompt replies to all of you.but i am running my server in dedicated mode.it is not in shared server mode.so,what can be the cause that it showing this type of error of dispatcher.Yes i am having two databases on my machines and there are two instances running.it can be the reason.
Thanks and Regards,