This discussion is archived
5 Replies Latest reply: Feb 21, 2013 6:16 AM by Mihael RSS

RMAN Point in time recovery

902332 Newbie
Currently Being Moderated
hi all,

i have oracle 11gr2 database on linux 5.5

i have the performed level 0 rman backup on 15th feb 2013, and after that i have incremental 1 and archives and controlfile backup. Before this no backup is the database.

Now i want to restore it to 12th feb 2013.

so is there any ways to restore the database to that point time.

and one more question.

can we restore controlfile to point in time.

Please let me know if you have any idea about this.

thanks
  • 1. Re: RMAN Point in time recovery
    Mihael Pro
    Currently Being Moderated
    i have the performed level 0 rman backup on 15th feb 2013, and after that i have incremental 1 and archives and controlfile backup. Before this no backup is the database.

    Now i want to restore it to 12th feb 2013.

    so is there any ways to restore the database to that point time.
    how you can restore if backup is made after this time ?
    and one more question.

    can we restore controlfile to point in time.
    you should have controlfile backups
  • 2. Re: RMAN Point in time recovery
    902332 Newbie
    Currently Being Moderated
    yes i have backup of controlfile also. that is also prepared on 15th only
  • 3. Re: RMAN Point in time recovery
    EdStevens Guru
    Currently Being Moderated
    899329 wrote:
    hi all,

    i have oracle 11gr2 database on linux 5.5

    i have the performed level 0 rman backup on 15th feb 2013, and after that i have incremental 1 and archives and controlfile backup. Before this no backup is the database.

    Now i want to restore it to 12th feb 2013.

    so is there any ways to restore the database to that point time.

    and one more question.

    can we restore controlfile to point in time.

    Please let me know if you have any idea about this.

    thanks
    No matter how many times you ask it, you cannot restore a database to a point in time prior to your backup.

    Re: RMAN restore to point in time

    What do we want? Time travel.
    When do we want it? It doesn't matter.
  • 4. Re: RMAN Point in time recovery
    asahide Expert
    Currently Being Moderated
    Hi,
    i have the performed level 0 rman backup on 15th feb 2013, and after that i have incremental 1 and archives and controlfile backup. Before this no backup is the database.
    Now i want to restore it to 12th feb 2013.
    I think It's impossible..
    If you want to restore to 12th feb, You have to have backup backed up before 12th feb.

    Regards,
  • 5. Re: RMAN Point in time recovery
    Mihael Pro
    Currently Being Moderated
    You can try to restore using other methods - flashback query, LogMiner.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points