Problem with data file

[Former Member]

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

[Former Member · Accepted solution]

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.

[Former Member]

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

[Former Member]

Hi,

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

regards

Umesh K

[Former Member]

Hi

i did not find any roll, can u please check the code below.

1. ONLINE ROLLBACK SEGMENTS

#rollback_segments = PRS_1 PRS_2 PRS_3

transactions_per_rollback_segment = 20

max_rollback_segments = 400

thank u

[Former Member]

Hi,

Use Oracle Enterprise Manager Console to create the roll_2 file

Regards

Umesh K

[Former Member]

Hi,

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

Please reinstall SAP.

Regards

ben