Restore Online backup then offline archive log the Start SAP

[Former Member]

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

[former_member343727 · Accepted solution]

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

[Former Member]

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

[Former Member]

Dear

I have check the archPRD.log in Location /oracle/PRD/saparch

sapprd :/oracle/PRD/saparch#tail -20 archPRD.log

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. ........ ... .......... ........

#

#ARCHIVE.. 37490 /oracle/PRD/oraarch/PRDarch1_37490_637623713.dbf 2010-06-29 16.43.21 43860992 331957050 1

#SAVED.... aedogclw cds $PRD_ARC_05/40 2010-06-29 17.19.10 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. ........ ... .......... ........

#

#ARCHIVE.. 37491 /oracle/PRD/oraarch/PRDarch1_37491_637623713.dbf 2010-06-29 16.58.30 43845632 331969725 1

#SAVED.... aedogclw cds $PRD_ARC_05/41 2010-06-29 17.19.13 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. ........ ... .......... ........

#

#ARCHIVE.. 37492 /oracle/PRD/oraarch/PRDarch1_37492_637623713.dbf 2010-06-29 17.15.48 43845632 331981641 1

#SAVED.... aedogclw cds $PRD_ARC_05/42 2010-06-29 17.19.17 ........... ............

#COPIED... ........ ... ................. .......... ........ ........... ............

#DELETED.. ........ ... .......... ........

#

• PRD tape aedogclw cds 2010-06-29 17.16.52 2010-06-29 17.19.52 0 ........... 37468 37492 37454 37467 -hd 7.00 (18) @0637623713

#

sapprd :/oracle/PRD/saparch#

Now witch witch archive log file should we restore .

And after restore what activity we must do to start SAP,

Regards

[Former Member]

You not need to tail last 20 lines, try to find the last backup you doing (as you post online) and download all offline logs

backuped using redo log backup after whis online backup.

After whis you restore this number of logs using as example

brrestore -a 37490-37492

After you need use sqlplus to recover database , (are you have online redolog's fine or you want to restore it to?)

Depend's of your situation you can use one of this methods -->

http://help.sap.com/erp2005_ehp_04/helpdata/EN/65/cade3bd0c8545ee10000000a114084/frameset.htm

Also read about insomplete recovery(usually from online backup the procedure are incomplete )

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

Regards.