RE: Block media recovery with standard edition

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 9 Dec 2015 00:01:45 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D9282B707C_at_EXMBX01.thus.corp>

Might it be possible to create an object that manages to overwrite that block ? CTAS No logging, pctfree 99 pctused 1.

Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Mladen Gogala [gogala.mladen_at_gmail.com] Sent: 08 December 2015 23:45
To: oracle-l-freelists
Subject: Block media recovery with standard edition

I ran into a corrupt block which makes rman backup fail:

released channel: backup_ch1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of backup plus archivelog command at 12/08/2015 01:58:24

RMAN-03009: failure of backup command on backup_ch1 channel at 12/08/2015 01:58:01 ORA-19566: exceeded limit of 0 corrupt blocks for file +DATA/prod/datafile/indexes.1030.873578613

OK, let's see what is it:

SQL> select file#,block# from v$database_block_corruption;

     FILE# BLOCK#
---------- ----------

        36 3650527

SQL> select owner,segment_name,segment_type   2 from dba_extents
  3 where file_id=36 and
  4 block_id<=3650527 and
  5 block_id+blocks>=3650527;

no rows selected

Great! No segments are affected! Let's fix it:

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: PROD (DBID=204240718)

RMAN> recover corruption list;

Starting recover at 08-DEC-15

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 12/08/2015 15:23:40 RMAN-05009: Block Media Recovery requires Enterprise Edition

RMAN>
_at_#$%! and standard edition! Does anyone have an idea how to fix it, short of taking the entire tablespace offline and recovering it? The tablespace contains indexes for the central application schema and such a procedure would amount to downtime, which would sit well with the customer. I cannot use DBMS_REPAIR because this repairs objects and the corrupt block is not in any segment. Backup validate datafile 36 still finds corrupt blocks, which means that the subsequent backup will fail.

--
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


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

Received on Wed Dec 09 2015 - 01:01:45 CET