Results 1 to 12 of 12
  1. #1
    Join Date
    Dec 2004
    Location
    Near Rome, Italy
    Posts
    8

    Unanswered: R E D - A L E R T !!!!!

    Hy guys, i have got a very big problem: yesterday i was working on a DB for a little bit of performance tuning (orace 8.1.7). After 3 hours, for my mistake, a datafile (on of three) of the tablespace who contains the rollback segments was deleted on D: driver. This is a tragedy for me, because, using BDA Studio, the DB is only mounted: it isn' t now openable because the system can' t find the datafile on D: driver.
    What can i do to bypass this datafile or to recovery the situation??????

    I tried to modify the control file in hexadecimal, but is very difficult and i stopped.

    Please Help me i dont need the damaged Tablespace (i can to create another Tablespace), it's enought and it's important to open the database



    Sorry For my english.
    Last edited by interceptor; 01-06-05 at 08:13.

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    This should answer all your questions:

    http://metalink.oracle.com/metalink/...p_id=1013221.6

    you will need a metalink login

    Alan

  3. #3
    Join Date
    Dec 2004
    Location
    Near Rome, Italy
    Posts
    8
    Quote Originally Posted by AlanP
    This should answer all your questions:

    http://metalink.oracle.com/metalink/...p_id=1013221.6

    you will need a metalink login

    Alan

    Thank you Alan ....

    I have got problem for the login, is it possible to copy the file and past here??? Sorry, but the website dont let me to login

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Someone should be able to get you a login as it is pretty essential for anyone dealing with Oracle stuff.

    Have removed the post as it may breach copyright.
    Last edited by AlanP; 01-07-05 at 05:44.

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    open the "recycle bin" on the desktop and restore the file
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  6. #6
    Join Date
    Dec 2004
    Location
    Near Rome, Italy
    Posts
    8
    Quote Originally Posted by The_Duck
    open the "recycle bin" on the desktop and restore the file

    It isn't possible, the file is definitely lost


    Thank you very much for the help Alanp. I' ll try to save the situation
    Last edited by interceptor; 01-06-05 at 11:13.

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use

    Posting copyright'ed material is not legal in some places on this planet.
    The moderators might want to remove the offending material.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  8. #8
    Join Date
    Dec 2004
    Location
    Near Rome, Italy
    Posts
    8
    Quote Originally Posted by anacedent
    > Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use

    Posting copyright'ed material is not legal in some places on this planet.
    The moderators might want to remove the offending material.

    it's the risk of the cut-paste activity

  9. #9
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Also, someone can't give you a login into metalink. It is oracles paid support login and you can only get one if you pay a lot of money to oracle. If someone want's to share their login, fine. However if oracle finds out, your support will most likely be dropped.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  10. #10
    Join Date
    Dec 2004
    Location
    Near Rome, Italy
    Posts
    8
    E X C E L L E N T

    My DB is OK now.


    Thank you sooooooooooooooooooooo much

  11. #11
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Interceptor, as a help to (future) users, maybe you could post what you did to make your Db OK again?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  12. #12
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Also, tell us where and when you find your next job. :-)
    NOTE: Please disregard the label "Senior Member".

Posting Permissions

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