Re: Database can't open / corruption at system01 datafile

From: Mostafa Eletriby <m_etrib_at_yahoo.com>
Date: Wed, 22 Oct 2014 03:52:07 -0700
Message-ID: <1413975127.96710.YahooMailNeo_at_web162405.mail.bf1.yahoo.com>

There is no metalink support.

---

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-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: data file 1: '/oraData/<SID>/system01.dbf'

On Wednesday, October 22, 2014 12:45 PM, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:  

That's what you pay support fees for. Definitely log a P1 SR with Oracle if you haven't already.

To offer any help we'd need version, platform and exact error messages. Even then you might not want to take recovery advice from strangers on the internet.

On Wed, Oct 22, 2014 at 11:36 AM, Mostafa Eletriby <dmarc-noreply_at_freelists.org> wrote:

Dear All,
>Please I have a problem at database startup as it can only be mounted while there isn't any backup taken before , corruption at system01 datafile.
>Please advice
>
>
>
>
>Best Regards,
>Mostafa Eletriby
>Oracle DBA

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info 
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 22 2014 - 12:52:07 CEST