Another Server also got down

[Former Member]

Dear all,

Another SAP server (SAND BOX) got down due to Power failure .

I have tried to start SAP , but not able to start , then i have tried to startdb from SQL.

i got the below error .

SQL> connect /as sysdba

Connected.

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1035993088 bytes

Fixed Size 1252880 bytes

Variable Size 528482800 bytes

Database Buffers 503316480 bytes

Redo Buffers 2940928 bytes

Database mounted.

ORA-01113: file 4 needs media recovery

ORA-01110: data file 4: 'D:\ORACLE\C11\SAPDATA1\SR3_1\SR3.DATA1'

Kindly advise

Edited by: satheesh0812 on Sep 17, 2010 9:12 AM

[Former Member · Accepted solution]

Hi,

ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: 'D:\ORACLE\C11\SAPDATA1\SR3_1\SR3.DATA1'

Due to abrupt shutdown, the database requires a recovery. Connect to SQL and then proceed as follows,

startup mount;
recover database;
alter database open;
shutdown immediate;
startup;

Hope this solves ur issue.

Regards,

Varadharajan M

[Former Member · Accepted solution]

Dear Varathu ,

Thanks for your update ...

I have resolved my DB issue , now my question is i will plan to change ip address of my SAP Server .

let me know what should i do before changing ip address ?

Kindly advise

[former_member204746 · Accepted solution]

for IP address, open up a new topic.

for your database issue, was your database being backed up online when it crashed? if so, all you had to do is "alter database end backup". no recovery would have been needed.

[Former Member · Accepted solution]

Satheesh,

Mark this thread as answered if ur issue is resolved. If the contributor's reply solved ur issue then mark that reply as "Solved" instead of marking the reply as "most helpful answer". I stress this because other users with the same issue may get benifitted from this thread.

Hope u understand. Also as Eric said, open a new thread for new issues.

Regards,

Varadharajan M