Recovery of DataFile of Temporary Tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Recovery of DataFile of Temporary Tablespace

  1. #1
    Join Date
    Sep 2000
    Posts
    1

    Red face

    Hello There,

    can somebody pl. help me to sort the problem of recovery.

    Database was set up by earlier DBA working here, and i dont have much cuel about the same.

    Details of Database on Window NT

    Oracle8i Release 8.1.5.0.0 - Production
    PL/SQL Release 8.1.5.0.0 - Production
    CORE Version 8.1.5.0.0 - Production
    TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
    NLSRTL Version 3.4.0.0.0 - Production

    Have database backup in Archieve mode on
    log_archive_dest e:\oracle\ora81\database\archive\bed1
    log_archive_dest_1
    log_archive_dest_2
    log_archive_dest_3
    log_archive_dest_4
    log_archive_dest_5
    log_archive_dest_state_1 enable
    log_archive_dest_state_2 enable
    log_archive_dest_state_3 enable
    log_archive_dest_state_4 enable
    log_archive_dest_state_5 enable
    log_archive_duplex_dest
    log_archive_format ARC%S.%T
    log_archive_max_processes 5
    log_archive_min_succeed_dest 1
    log_archive_start TRUE
    standby_archive_dest %ORACLE_HOME%\RDBMS

    And Following is details related to datafile of Temp tablespace
    THis datafile has grown over the days nobody know why and since when?


    STATUS ENABLED
    RECOVER READ WRITE

    And as this datafile need to be recovered, and is not online
    we cant make any modification and if we try to compile anything in production it fails.

    Can somebody help me and tell me what do i need to do for getting this data file online, i know i need to use Recovery manager but can someone take me thru the steps to do the same

    Hoping that somebody will reply .
    Thanks



  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342

    Unhappy

    you can change you users to use another tablespace for there temporary segments.
    This does not resolve you problem, but your users can work again.

    alter user <ausername> temporary tablespace <anotherTS>;

    Gert

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    temporary tablespace shouldnt be tricky, create another temporary tablespace and alter all users to use that new temporary tablespace, then you can drop the faulty temporary tablespace

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