Today we had a major data corruption happen from a user process and had to
roll back production to before the process happened.

What I thought I did was this:

1. Copy Prod to Test as of the point in time of the rollback decision.
(5/2/2012 16:00)
2. Recover Prod to the requested point in time (5/2/2012 11:00)

This then would give the users a system to look into in order to make sure
that other data unrelated to the corruption could be re-entered without
anything being missed.

However, I just realized that I screwed up the time on the test duplication
and not all the data is there.

Since at the end of the prod recovery I did a resetlogs, I have a new
incarnation of the database - I'm pretty sure the backup chain before the
resetlogs is invalid and I can't just go and duplicate until time to a point
in time before the resetlogs - I haven't tested it because I don't want to
mess anything up.

I found a white paper about restoring a database when you only have the
backup files, but that's not quite what I need.

I need to be able to duplicate a database (create test, from prod backups)
to a point in time before the reset logs, just using the backup files. I
have the backups of spfile, control files and the full, incremental and
archive logs on disk from the last 14 days.

Haven't been able to find instructions on this one yet and I really would
prefer to have the correct version of the test database available in the

Anyone have some pointers on this one ?


Search Discussions

  • Steve Wales at May 3, 2012 at 3:13 am
    Was data that was updated incorrectly beyond the ability to repair manually
    on a massive scale.

    Already done recovery from backup in prod, new incarnation, so can't
    flashback anything past RESETLOGS

    And my test DB copy that I did before the restore didn't go far enough into
    the future


    -----Original Message-----
    From: Kevin Jernigan
    Sent: Wednesday, May 02, 2012 8:50 PM
    To: sjwales@comcast.net
    Cc: oracle-l@freelists.org
    Subject: Re: Using RMAN to recover a copy of a database from backup files

    How about using flashback query to view the affected table(s) right before
    they were screwed up? Or is this a physical and not logical corruption?

  • Steve Wales at May 3, 2012 at 6:34 am
    Missed it in the initial post (hit send too early) - it was 11gR2.

    I found something in the documentation that showed me how it should be able
    to be done, but I'm getting errors about incarnations that RMAN isn't

    Raised an SR with support a few hours ago, hopefully they'll get back to me
    tomorrow and just for the sharing of knowledge thing, I'll send the
    resolution out when I get it worked out.

    Thanks all for your replies to date.



    From: Niall Litchfield
    Sent: Wednesday, May 02, 2012 11:51 PM
    To: sjwales@comcast.net
    Cc: oracle-l@freelists.org
    Subject: Re: Using RMAN to recover a copy of a database from backup files

    Steve, version of the database is quite important here as steps available to
    you vary by version. In addition it sounds like you would be well advised to
    engage support on this one. The short and good answer though is that so long
    as you have the required backups and arch logs you can achieve your goal.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
postedMay 3, '12 at 1:12a
activeMay 3, '12 at 6:34a

1 user in discussion

Steve Wales: 3 posts



site design / logo © 2022 Grokbase