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

From: <hostetter.jay_at_gmail.com>
Date: Wed, 22 Oct 2014 11:12:45 +0000
Message-ID: 629618328-1413976367-cardhu_decombobulator_blackberry.rim.net-1621579851-_at_b17.c5.bise6.blackberry>

Make sure you aren't using an old init.ora or spfile.

Jay
Sent via BlackBerry by AT&T

-----Original Message-----
From: "Mostafa Eletriby" <dmarc-noreply_at_freelists.org> (Redacted sender "m_etrib_at_yahoo.com" for DMARC) Sender: oracle-l-bounce_at_freelists.org Date: Wed, 22 Oct 2014 04:00:24
To: niall.litchfield_at_gmail.com<niall.litchfield_at_gmail.com> Reply-To: dmarc-noreply_at_freelists.org Cc: oracle-l<oracle-l_at_freelists.org> Subject: Re: Database can't open / corruption at system01 datafile

Database version: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production Platform: Linux 5 2.6.18-164.el5 x86_64

On Wednesday, October 22, 2014 12:53 PM, Mostafa Eletriby <dmarc-noreply_at_freelists.org> wrote:  

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 - 13:12:45 CEST