Re: Database error and couldn't be opened

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Sun, 28 Dec 2014 11:03:42 -0600
Message-Id: <6EFAFBA6-7D61-499F-B3B4-5E173B31DA43_at_gmail.com>

Dbverify (dbv) might fix this, also look at block recover. Both Oracle tools. They might be able to fix this.

Sent from my iPad

> On Dec 28, 2014, at 1:13 AM, Mostafa Eletriby (Redacted sender "m_etrib_at_yahoo.com" for DMARC) <dmarc-noreply_at_freelists.org> wrote:
>
> Hello DBAs,
> Please I need top resolve these errors at database as database is mounted but couldn't be open.
> There is no backup and database is in noarchivelog mode.
> Database version:- standard edition.
> O.s:- linux redhat v5
>
> Please check.
> Thanks
>
> SQL> select status from v$instance;
>
> STATUS
> ------------------------------------
> MOUNTED
>
> SQL>
> SQL> alter database open;
> alter database open
> *
> ERROR at line 1:
> ORA-01115: IO error reading block from file 7 (block # 44988)
> ORA-01110: data file 7: '/oraData/cdsdbdata/ENRPGEST.dbf'
> ORA-27072: File I/O error
> Linux-x86_64 Error: 5: Input/output error
> Additional information: 4
> Additional information: 44988
> Additional information: -1
>
>
> SQL>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Dec 28 2014 - 18:03:42 CET