Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

IDES is not start after system restart

Hi All,

the IDES 6.0 became stuck, so i restart IDES server from Button and when i want to start database then i m getting below error:

C:\Documents and Settings\idsadm>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Sep 23 23:23:20 2008

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  805306368 bytes
Fixed Size                  1292048 bytes
Variable Size             499124464 bytes
Database Buffers          301989888 bytes
Redo Buffers                2899968 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'G:\ORACLE\IDS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'


SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 60: 'G:\ORACLE\IDS\SAPDATA1\SR3700_1\SR3700.DATA1'
ORA-01110: data file 60: 'G:\ORACLE\IDS\SAPDATA1\SR3700_1\SR3700.DATA1'
ORA-01115: IO error reading block from file 60 (block # 1)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).

while when i tried to start SAP from SAPMMC then Dispatcher changed in yellow from Green.

how can i resolve above prolme.... thanks in advance.

regards,

majamil

Not what you were looking for? View more on this topic or Ask a question