Re: Database can't open / corruption at system01 datafile
- From: Maclean Liu <maclean_007@xxxxxxx>
- To: dmarc-noreply@xxxxxxxxxxxxx
- Date: Wed, 22 Oct 2014 19:02:32 +0800
The problem is whether backup is available ? If not , you may try some
force open database option including some hidden parameter , the last
resort will be DUL-like tools.
By setting _ALLOW_RESETLOGS_CORRUPTION=TRUE, certain consistency checks are
SKIPPED during database open stage. This basically means it does not check
the datafile headers as to what the status was before the shutdown and how
it
was shutdown. The following cases mention few of the checks that were
skipped.
Although this option can be marked as unsupported by oracle support.
Maclean Liu
Oracle Database Administrator
Oracle Certified 10g/11g Master
http://www.oracledatabase12g.com
On Wed, Oct 22, 2014 at 7:00 PM, Mostafa Eletriby <
dmarc-noreply@xxxxxxxxxxxxx> wrote:
> 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@xxxxxxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxxx> 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
>
>
>
>
>
Other related posts:
