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

From: Howard Latham <howard.latham_at_gmail.com>
Date: Wed, 22 Oct 2014 12:03:49 +0100
Message-ID: <CAPCNhx32TMO+=pH7_EnZ79c97n2iyLSd4nnReJ0NCjhVFFGduA_at_mail.gmail.com>

This is a common error when trying to copy or create standbys of databases. However I wouldn't want to take on the responsibility of advising you on the net what to do we might be talking about £1B worth of data . Talk to Oracle Support! .

On 22 October 2014 11:52, 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
>
>

-- 
Howard A. Latham
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 22 2014 - 13:03:49 CEST