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

Restore Online backup then offline archive log the Start SAP

Dear Team,

One of my standby Production Server in HP-Ux with Oracle 10.2.

I have restore from online backup.

sapprd1:oraprd 3> brrestore -m full -b bednolbd.fnt

After sucessfull restore

Now I want restore offline archive log then I want to start SAP.

I have archive log PRDarch1_37355_637623713.dbf to PRDarch1_37370_637623713.dbf

in other tape .

Now how I restore these archive log then start SAP.

reagrds

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 09, 2010 at 03:05 PM

    Hi,

    U are planning to go for DR for SAP system or copy of SAP system(DEMO/Training system)

    I conclude that you are not doing DR as you are trying to start SAP system

    In DR database should be in mount state and should not open at any cast until unless there is a switchover

    If you opened the DB it will go out of sink with actual DB

    for doing DEMO its not necessary to apply all logs which it asks while recovery

    check out the backup log file which you used for restoring in your source system

    note down the time at which that backup gets completed .

    use oracle recover command with option untill time and provide some time which is greater than the backup end time

    recovery will complete successfully .

    then you can start SAP instance

    Regards,

    navin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 28, 2010 at 07:58 AM

    One of my standby Production Server

    Are you sure? It may be worth to test restore procedure on the test server?

    You need to read archSID.log and check the og sequence numbers that you need to restore.

    After you can use for example

    brrestore -a XXX-YYY for restore

    Try to check

    http://help.sap.com/erp2005_ehp_04/helpdata/EN/bc/07503e30a9d549e10000000a114084/content.htm

    http://help.sap.com/erp2005_ehp_04/helpdata/EN/0d/d3077b4a0c11d182b80000e829fbfe/frameset.htm

    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.