IDES is not start after system restart

[former_member182034]

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

[former_member182034]

there is only one solution which is installation.

[markus_doehr2]

Did you shut down the database before you rebooted the system? The files seem to be corrupt.

Markus

[former_member182034]

Hi Marku,

I did not shutdown the database.

[markus_doehr2]

This is not done automatically by the system. It's crucial to always shut down the database before you reboot the system, otherwise processes may be just "killed" and things like you see with happen.

Your database is corrupt, you either have to use a backup to restore or reinstall (if it's an IDES system shouldn't be a problem but time).

Markus

[former_member204746]

your have 2 choices:

1. you repair the DB, refer to SAP note 365481

2. you restore from last backup

[former_member182034]

ok Markus and thanks for your statement.

fyi.... we have chat on this

Daily Backup of Production on Disaster Recovery

post... and unfortunately i forgot the password of that profile. i made this profile(majamil).

please have a look on above post.... because i want to up our DR server...please tell me Something that is required in advance....

thanks and regards;

majamil