Re: Database error and couldn't be opened

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Sun, 28 Dec 2014 18:11:51 +0000
Message-ID: <CAPMSPxMhxm+80PmLsOd5W7WCh+XyNOrJbO8h+OWvgGMGfOvN3w_at_mail.gmail.com>

Hi
Try to use rman to do a block level recovery. If that does not work and you do have an Oracle support contract, contact support to get help on extracting what data can be saved from the database. Oracle support have tools that can read the database files, I cannot remember what they are called as its been a long time since I was were you are and things will have changed.

Good luck.

Pete

On 28 December 2014 at 07:13, Mostafa Eletriby <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>
>
>
>

-- 
Regards

Pete

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

Received on Sun Dec 28 2014 - 19:11:51 CET