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

Recommendations for restore of an offline backup

Hi guys

We are about to go to Go-Live production of the implementation of ECC 6.0 on AIX 6.1/Oracle 10.2.

The backups are running SAP with an option to backups type Offline for the transaction DB13 and tapes are made daily.

We want to test restore of our backups to make sure everything is working properly before they start operations in the system.

Tests have already been completed restoration of the OS and SAP (application and database) with filesystem-level backup and everything worked properly.

Now let us restore testing with SAP Offline Backups. Already configured the init.sap with the - m full for backups.

I would make sure that these are the steps to restore the test:

1 .- Shutdown SAP.

2 .- Shutdown Database.

3 .- In the directory sapbackup already exists last backup session.fft

3 .- Run the command: brrestore -b xxxx.fft -m full

4 .- After the restore, open the database and test

We will not apply the offline redo because the client wanted only to have offline backups daily and are aware that data loss is one day.

As explained SAP (help.sap.com) is not required to restore the redolog offline, because an offline backup I have a consistent database until the backup was performed: "After an offline backup of the complete database, you have a backup of the database that is consistent. If you work with the database after the backup, the backup is no longer up-to-date. In this case, you have to recover the database after you restore the backup, using the redo log files"

I would like to know if this procedure is correct or I may be missing something??

Thanks for your recommendations

Desiré

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 Oct 06, 2010 at 07:38 AM
    except the point 2. Wherein we need the DB to be in mount stage and not shutdown

    Can you clarify....how you can restore test backup without shutting down your DB and keeping in mount stage.

    Suggest you to go through official Database recovery doc or Homogenous system copy guide

    Regards,

    Nick Loy

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Eric Brunelle

      Hi Eric I have no other server available for this test.

      But last week we tested recovery of the production system with full backup of all filesystems and were satisfactory.

      Before this test, we also perform backups of the filesystems (cold backup) in case I fail the offline backup of SAP.

      Thanks for your suggestion.

      Desiré

  • Posted on Oct 06, 2010 at 04:22 PM

    > We will not apply the offline redo because the client wanted only to have offline backups daily and are aware that data loss is one day.

    Hi,

    but hopefully this does not mean, you are running NoArchive mode?

    Before you do the actual restore to your live system, you can run a brbackup with verify option.

    In this case after the backup each datafile is restored to sapreorg one by one and either

    compared to the saved file (usefull for offline backup) or dbv-erified (usefull for online backup).

    Volker

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Desirée Cárdenas,

      Its good to hear that u have successfully recovered the DB.

      Thanks for updating the issue u have faced and its resolution step. This will help the fellow SCN members/SAP users for sure one day or other.

      Regards,

      Varadharajan M

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2010 at 06:09 AM

    Hi,

    All the procedures mentioned by you are fine except the point 2. Wherein we need the DB to be in mount stage and not shutdown.

    As mentioned in the online help, the offline backup is complete and consistent and thus u do not need a redo log recovery after the restore of offline backup. But if u r not recovering the latest offline redo logs u will loose the data/changes.

    In case if u r performing a restore test using an offline backup then u can go ahead and open the DB without applying the redo logs.

    If u r recovering the DB from a backup on a live production environment then u need to recover the redo logs to avoid data loss.

    Hope this helps and clarifies.

    Regards,

    Varadharajan M

    Add a comment
    10|10000 characters needed characters exceeded

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.