Restore Procedure - online backup

[Former Member]

Dear all,

Our BI QA system got crashed and hence we need to restore the SAP on

the same machine , we have online backup.

Can any advise on the restore & recovery methods with the online backup.

Kindly provide Restore Steps .

Kindly suggest

Thanks & Regards,

[Former Member · Accepted solution]

Detailed query can give you immediate solution:

If you are using Oracle, just follow standard system copy method by using backup restore

OR

www.service.sap.com/systemcopy

Update your message with OS, DB details

Regards,

Nick Loy

[Former Member · Accepted solution]

Hi Nick,

we are using AIX , Oracle 10g, sapecc 6.0

kindly suggest.

[Former Member]

Hi,

Yes you can restore your old online+archivelog backup into crashed server.

However this depends on different things

1) Only if you have online+archivelog backup, you can restore and recover the DB

2) Only if you have SAP file systems on this server otherwise you have to create them manually

3) Only if you have your Oracle, otherwise you need to re-install

If you have all the above SAP FSs, Oracle and Online+archivelog backup then restoration is a simple process.

Regards,

Nick Loy

[Former Member]

Link may help you [http://www.sdn.sap.com/irj/sdn/ora?rid=/webcontent/uuid/1cc71b42-0d01-0010-7f91-f352b58078cf] [original link is broken];

[Former Member]

Someone had the same problem and got the solution;

[|]

Regards,

Nick Loy

[ashish_mishra2]

1: stop the database and SAP services running under <sidadm> and <orasid> users.

2: Empty your sapdatas

u2022 cd /oracle/<SID>

u2022 rm u2013r sapdata*

3: Delete control files from all of its three locations (whereever presents)

u2022 cd /oracle/<SID>/cntrl

u2022 rm *.dbf

4: confirm the name and presence of online backup logfile ( *.anf ) in sapbackup dir.

and same for arch<SID>.log in saparch dir.

5: Start restore on targetsystem in the foreground with:

u2022 su u2013 ora<sid>

u2022 for normal restore: brrestore -r init<source sid>.utl -b <backupfile> -m full u2013c

or Start restore in the background with:

u2022 as root

u2022 at now

su u2013 ora<sid> -c u201Cbrrestore -r init<source sid>.utl -b <backupfile>-m full u2013c forceu201D

^D

6: Once restore finishes, do not open the database. Start the database in mount state and apply the redologs till the

time you want the recovery of database or else

you must recover the database till the end time of databse backup as you have online backup only with you.

==> for end time of backup, check the *.anf file.

before starting recovery, make sure archive logs are available with you.

Syntax

sqlplus> recover database using backup controlfile until cancel;

or

sqlplus> recover database until time '2010-03-02:10:00:00' using backup controlfile;

First check if we can stop and start the system without problems.

Sqlplus> shutdown immediate

Sqlplus> startup

Also check the alert_SID.log for any errors.

7: once database recovery finishes, you may open the database and start SAP applications.

Cheers !!!

Ashish

[Former Member]

Dear all ,

i have Recent Online backup of crashed server . i want to restore sap with the help of Recent Crashed server Online Backup on the same server . is it possible to restore sap with the help of recent Onlne backup of crashed server

kindly suggest

[ashish_mishra2]

>

>

>

>. is it possible to restore sap with the help of recent Onlne backup of crashed server

>

Hi,

Please let me know what exactly is crashed ??

1: your profile files , kernel files or any configuration file is deleted ?

2 :your database is not opening because of some database errors? or

3: whole hardware is crashed.

well .. if your SAP configuration files are safe and only SAP applications are not able to start because of database errors

you can use the crashed server's backup and restore using above procedures.

If this does not help you then putting some lights on what exactly happened with SAP server we might help you.

Cheers !!!

Ashish

[Former Member]

Just search sdn/goolge Oracle backup restore method, you may find some of the links.

DR set up also can help you in this.

My inputs:

If you have brbackup of your source, just restore the backup from device to target by using brtools.

1)brrestore -n all_log(will restores the log files from your backup)

2)Just place them into their directories

3)brrestore -b filename(.ant for online backup) -m full

4)change the user/startup parameters if source and targer are different

5)start you db+SAP application

Regards,

Nick Loy