Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to open the database, getting error ORA-01110

Rizwan ShaukatOct 29 2013 — edited Oct 29 2013

SQL> SELECT STATUS FROM V$INSTANCE;

STATUS

------------

MOUNTED

SQL> ALTER DATABASE OPEN ;

ALTER DATABASE OPEN

*

ERROR at line 1:

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-01110: data file 32: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ERPDB\CINVD04.DBF'

ORA-01115: IO error reading block from file 32 (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).

i have issue the command, "RECOVER DATABASE USING BACKUP CONTROLFILE" but no gain.

Pl suggest, what should i do

Regards,

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2013
Added on Oct 29 2013
7 comments
1,560 views