Procedure for Standby Database for SAP ERP 6.0

[vijayasaradhi_c]

Hello All,

We are using SAP ERP 6.0 with Oracle 10g with AIX 5.3.

We are planning to setup a standby database for our SAP ERP 6.0 production system as part of remote DR site using Oracle Data Guard.

I was under the assumption that i can first install an erp 6.0 (ABAP) system using homogeneous system copy from my erp 6.0 (ABAP) production system and then start configuring oracle dataguard.

But the System Copy Guide "System Copy for SAP Systems Based on SAP NetWeaver 7.0 SR3 ABAP" has mentioned that "You cannot create standby systems with a system copy".

Please suggest the best practise or the procedure for creating standby database for SAP ERP 6.0 system. Iam not looking at the steps for creating a pure oracle 10g standby database, but with SAP instances as well.

Thanks in advance.

CVS

[former_member204746 · Accepted solution]

you can only DR the Oracle part with Oarcle Data Guard.

you need to restore your last backup to offsite and apply redo logs ins standby mode

[Former Member]

Hi,

Please refer the below mentioned link for configuring data guard.

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10823/create_ps.htm

Below mentioned are the sequence of stpes, which needs to be followed for setting up data guard.

3.1 Configuring the Primary Database

3.1.1 Enable archiving and define a local archiving destination

3.1.2 Create a password file

3.1.3 Configuring the Oracle networking files

3.1.4 Set initialization parameters on the primary database

3.1.5 Take Offline/Online backup of the primary database

3.1.6 Create a control file for the standby database

3.1.7 Prepare initialization parameter file for the standby database and start the primary database with the changed pfile.

3.1.8 Copy all files from the primary host to the standby host

3.2 Configuring the Standby Database

3.2.1 Configuring the Oracle networking files

3.2.2 Create a INIT parameter file for the standby database

3.2.3 Copy the standby controlfile to the appropriate location

3.2.4 Create Oracle Password File

3.2.5 Start the physical standby database

3.2.6 Initiate log apply services

Regards,

Ranjith

[kishore_kumar59]

HI..

You have to create a standby controle file, before taking the backup,

and place this file in the standby server , and start your database as standby database and starting synchronizing your database with primary automatically / manually