FAQ
Hi please I get an error recovering a datafile, previously I got an ora 600
12700 (corruption on data block), I identified it was a datablock, not an
index block, and recovered the datafile from one month ago and then tried to
recover and got this message.

The customer don't have oracle support, is there some way to solve this
situations?

Could be the problem in the archivelog file, because recover always hang in
the same archivelog. Or the solution is to recover a backup enough old, so
that block get recreated?

Thanks in advance.

--

http://www.oracleboliviaspecialists.com/

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

10 years of experience from Oracle 7 to Oracle10g and developer 6i

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

Search Discussions

  • Bobak, Mark at Oct 11, 2006 at 4:10 pm
    Juan,


    Check MetaLink Doc ID 30866.1


    Hope that helps,


    -Mark

    --

    Mark J. Bobak

    Senior Oracle Architect

    ProQuest Information & Learning

    There is nothing so useless as doing efficiently that which shouldn't be
    done at all. -Peter F. Drucker, 1909-2005



    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Juan Carlos Reyes
    Pacheco
    Sent: Wednesday, October 11, 2006 12:01 PM
    To: Oracle-L Freelists
    Subject: Please Help ora-600 3020 12764964 1 2522 2464 373

    Hi please I get an error recovering a datafile, previously I got an ora
    600 12700 (corruption on data block), I identified it was a datablock,
    not an index block, and recovered the datafile from one month ago and
    then tried to recover and got this message.


    The customer don't have oracle support, is there some way to solve this
    situations?


    Could be the problem in the archivelog file, because recover always hang
    in the same archivelog. Or the solution is to recover a backup enough
    old, so that block get recreated?


    Thanks in advance.


    --

    http://www.oracleboliviaspecialists.com/

    Oracle Certified Profesional 9i 10g
    Orace Certified Professional Developer 6i

    10 years of experience from Oracle 7 to Oracle10g and developer 6i

    --
    http://www.freelists.org/webpage/oracle-l
  • Juan Carlos Reyes Pacheco at Oct 11, 2006 at 4:32 pm
    Thank you Mark a lot
    On 10/11/06, Bobak, Mark wrote:

    Juan,

    Check MetaLink Doc ID *30866.1*
    **
    Hope that helps,

    -Mark

    ***--*

    *Mark J. Bobak*

    *Senior Oracle Architect*

    ***P****ro****Q****uest Information & Learning*

    There is nothing so useless as doing efficiently that which shouldn't be
    done at all. �Peter F. Drucker, 1909-2005



    ------------------------------
    *From:* oracle-l-bounce_at_freelists.org [mailto:
    oracle-l-bounce@freelists.org] *On Behalf Of *Juan Carlos Reyes Pacheco
    *Sent:* Wednesday, October 11, 2006 12:01 PM
    *To:* Oracle-L Freelists
    *Subject:* Please Help ora-600 3020 12764964 1 2522 2464 373


    Hi please I get an error recovering a datafile, previously I got an ora
    600 12700 (corruption on data block), I identified it was a datablock, not
    an index block, and recovered the datafile from one month ago and then tried
    to recover and got this message.

    The customer don't have oracle support, is there some way to solve this
    situations?

    Could be the problem in the archivelog file, because recover always hang
    in the same archivelog. Or the solution is to recover a backup enough old,
    so that block get recreated?

    Thanks in advance.



    --
    ----------------------------------------
    http://www.oracleboliviaspecialists.com/

    Oracle Certified Profesional 9i 10g
    Orace Certified Professional Developer 6i

    10 years of experience from Oracle 7 to Oracle10g and developer 6i
    --
    ----------------------------------------
    http://www.oracleboliviaspecialists.com/

    Oracle Certified Profesional 9i 10g
    Orace Certified Professional Developer 6i

    10 years of experience from Oracle 7 to Oracle10g and developer 6i

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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 11, '06 at 4:01p
activeOct 11, '06 at 4:32p
posts3
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase