Skip to Content
author's profile photo Former Member
Former Member

Database Recovery

Hi Experts,

We lost eight(8) production archive files because of backup failure through HP Data protector

We are using the archive for DR restoration but now it's causing inconsistency and restoration is not possible.

Currently my DR is in stable condition till 4~5 day ago situation, now i need point in time recovery on DR server without lost archives.

Currently I have last week cold backup+yesterday online backup+archive after online backups.

Can you please suggest that it's possible to restore online backup on current situation using DP or I need to go through complete recovery procedure.

Either suggest the alternate way of point in time recovery.

Regards,

Vinay Shrimali

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 06:10 AM

    Hi All,

    We recovered from latest available (Online+Arch) logs, Thanks from your suggestion.

    Regards,

    Vinay Shrimali

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 05:03 AM

    Hi Vinay,

    If I understood correctly - You lost few of the archive logs hence you are not able to sync your database between primary and secondary.

    Then why you want to recover your database on secondary?

    I think your primary is working absolutely fine, then just take a fresh backup (online +archive log) and restore the same on secondary (DR site). It will restore full database into target then do post restore steps (enabling log shipping etc.).

    Regards,

    Nick Loy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2014 at 10:18 AM

    Hi Vinay

    If you have the Online Backup and all the archive logs since that , then you can use that backup for restore in the DR site and then apply the logs and activate the log shipping as per the usual process in your environment.

    Since some Logs are missing , hence you need to do another DB recovery as the current database in the DR site , will be not be able to be in sync with the actual PROD system ...

    Thanks

    Rishi

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Vinay,

      thank you for providing the necessary information.

      > I don’t understand the question but we are using the backup tool which is HP DP V 7.0

      HP Data Protector is just the MML (media management library) / third party backup software. You can perform Oracle database backups the old "OS based" fashion way or you can use Oracle RMAN. In case of Oracle RMAN there are possibilities for full backup, level 0 full backup, incremental backup, etc.

      > but since last backup we lost some of archives so I am looking for the option to build up the disaster recovery site as normal.

      .. then my previous suggestion is the way to go: RMAN Incremental Backups to Roll Forward a Physical Standby Database

      Regards

      Stefan

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.