DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: vert very urgent problem

  1. #1
    Join Date
    Aug 2001
    Posts
    267
    Hi Guru's ,

    Here is my problem ..One of my disk crashed . It got one datafile trans.dbf . I can't startup my database ..since it is missing . How can I recreate the file . We don't need the objects in that file . We don't have real production objects in that tablespace . This tablespace trans got only one datafile trans.dbf . I know it is my bad management that I don't have backup for this datafile . Can you help to recover my database.
    Raghu

  2. #2
    Join Date
    Jan 2002
    Posts
    474
    start the database with mount
    take the missing datafile offline
    open the database


  3. #3
    Join Date
    Aug 2001
    Posts
    267
    Thanks for the reply . Can you pass the correct syntax to move the datafile offline;

    I am trying

    alter database datafile ' ' offline;


    I am getting error ..nonexistent logfile,datafile,control file
    Raghu

  4. #4
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    alter database datafile ' / / /tbspace1.dbf' offline
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    offline/online work if you are in archivelog mode. Otherwise, you receive ORA-01145 error: offline immediate disallowed unless media recovery enabled. I don't believe raghud is in archivelog mode - is that correct?

  6. #6
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    specify the missing datafile with full path
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  7. #7
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    raghud,

    Perform an offline drop of the datafile(s) associated with that datafile and tablespace...

    Start the instance

    mount the controlfiles

    alter database datafile 'fully qualified datafile name' offline drop;

    open database


  8. #8
    Join Date
    Aug 2001
    Posts
    267
    many thanks for the reply .

    now I am getting error 'offline immediate disallowed unless media recovery enabled' ...
    Raghu

  9. #9
    Join Date
    Aug 2001
    Posts
    267
    alter database datafile 'fully qualified datafile name' offline drop;

    getting nonexistent datafile,logfile and tempfile
    Raghu

  10. #10
    Join Date
    Aug 2001
    Posts
    267
    yes true ..It is my another biggest mistake I am not running on archievelog mode ..
    Raghu

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