1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to workaround ora-27072 ora-01110 ora-01115

Discussion in 'Server Administration and Options' started by 13478, Mar 6, 2017.

  1. 13478

    13478 Active Member

    Messages:
    41
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Louisana
    Hello,


    Database is 11.2.0.2.0 in Linux x86_64

    sqlplus> startup
    ORACLE instance started.

    Total System Global Area 8551575552 bytes
    Fixed Size 2243608 bytes
    Variable Size 1459618792 bytes
    Database Buffers 7079985152 bytes
    Redo Buffers 9728000 bytes
    Database mounted.
    ORA-01115: IO error reading block from file 117 (block # 1)
    ORA-01110: data file 117: '/db2/oradata/data/db7_perf/MF_AGING_RPT_2008_01.DBF'
    ORA-27072: File I/O error
    Linux-x86_64 Error: 5: Input/output error
    Additional information: 4
    Additional information: 1
    Additional information: -1

    This database is not important, we have no rman backups.
    now databse is mounted but not open.
    Is there a way to quickly force database open (ignore this db block corruption, losing some data is acceptable)?

    Thank you very much.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,645
    Likes Received:
    372
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You've received the only answer available in the OTN Oracle General Database forum; there is no other answer anyone can provide. You need to replace the disk and make an attempt to either work without that data file or rebuild the database. Since you have no backups of any kind I seriously doubt you can rebuild it.
     
  3. androidrobo

    androidrobo Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    chennai
    Hello,
    After getting the following error ,Our production oracle db server is crashed,we cant access the dbs.after reboot the server only we can access the db,Any body can tell the resolution for this issue.
    OS:Linux
    oracle db version :10.2,11.2

    ORA-01115: IO error reading block from file ORA-01115: IO error reading block from file 83 (block # 639938)
    ORA-01110: data file 83: '/oradata/prod/prod_data04.dbf'
    ORA-27091: unable to queue I/O
    ORA-27072: File I/O error
    Linux-x86_64 Error: 14: Bad address
    Additional information: 4
    Additional information: 639937
    Additional information: -1
    ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
    ORA-06512: at "SYS.DBMS_ADVISOR", line 186
    ORA-06512: at "SYS.DBMS_SPACE", line 1500
    ORA-06512: at "SYS.DBMS_SPACE", line 1566
    (block # )