Tablespace Offline
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Tablespace Offline

  1. #1
    Join Date
    May 2002
    Posts
    22

    Arrow Tablespace Offline

    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.

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Here it is

    Code:
    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

  4. #4
    Join Date
    May 2002
    Posts
    22

    Tablespace offline

    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.

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    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

  6. #6
    Join Date
    May 2002
    Posts
    22
    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,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width