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

Thread: Tablespace Read Only

  1. #1
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123

    Question

    Hello

    I am working on Oracle8i Enterprise Edition Release 8.1.7.0.0
    I have made a tablespace Offline using alter tablespace xxx ofline immediate . However when I try to make the same online I need to make media recovery but the problem is I have no hot backup of the DB only archive log backups .

    Please suggest how do I make the tablespace online ..........

    Thanks

    Afshin





  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Can you post the full text of error message?

    Sanjay

  3. #3
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    Hello

    alter tablespace xxx online ;
    ORA Message
    *****************************************
    ORA-01113: file 51 needs media recovery
    ORA-01110: data file 51: 'xxx.DBF'
    *************************************
    Hope this helps

    Thanks
    Afshin

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    because you used immediate clause Oracle did not checkpoint the datafiles when you put them offline, AFIAK the only way is to recover the tablespace

  5. #5
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    Hi Pando

    Thanks and the Tablespace is online again .

    Cheers
    Afshin

  6. #6
    Join Date
    May 2001
    Posts
    57
    Try using this
    ALTER DATABASE RECOVER TABLESPACE tblsp_name
    This should help you out.

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