Skip to Content
author's profile photo Former Member
Former Member

Problem with data file

Hi

my MMC is not starting.

when i checking through SAPDBA in command mode, i got that one data file is missing. roll file are in "oracle/<sid>/sapdata2".

few days back i created a data file <b>roll_2</b> for PSAPROLL through SAPDBA.

yester day i deleted that roll_2 data file.

i delete <b>roll_2</b>, as right click and delete from normal windows deletion.

when i through SAPDBA, i got that was the problem.

i don't have any back up.

i thought that the problem will solve, only when i create that data file.

and SAPDBA Table space administration is not working, because instance in not started.

please help me on this.

thank u

Message was edited by:

Madhu M

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 10, 2007 at 04:46 AM

    hi

    Thank you guys, responding to my query.

    but, unfortunately i got problems with <b>alert log</b> file and i can't even log on to <b>sqlplus</b>.

    so, i got frustrate and reinstall that.

    ok

    thank you.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 08:48 AM

    Hi,

    from initsid.ora delete this roll_2 from Rollback_segments and start the db using this pfile

    regards

    Umesh K

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 08:37 AM

    Hi,

    If you don't have backup, no one can help you.

    Please reinstall SAP.

    Regards

    ben

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2007 at 11:58 PM

    Madhu,

    What version of Oracle are you using? If you are using Oracle 9i or higher, you need to use PSAPUNDO. I would then create PSAPUNDO and modify the init(sid).ora or spfile to enable PSAPUNDO and disable the roll back segments.

    create undo tablespace PSAPUNDO datafile '/oracle/SID/sapdata2/undo_1/undo.data1' size XXXm;

    (note: create the subdir as orasid (undo_1))

    alter system set undo_management = auto scope = spfile;

    alter system set undo_tablespace = PSAPUNDO scope = spfile;

    alter system set undo_retention = 3600 scope = spfile;

    alter system reset rollback_segments scope = spfile sid = '*';

    create pfile='/oracle/SID/920_64/dbs/initSID.ora' from spfile;

    or vi your init(sid).ora file add the first three, comment out rollback segements.

    stop/start your system, then drop the PSAPROLL table.

    Regards,

    Mike Heath

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.