SAP DR site - Oracle dataguard 10g

[Former Member]

Dear Gurus,

We need to setup DR server for below environment using oracle dataguard:

OS : Red hat Linux

DB : Oracle 10g

SAP : ECC 6.0

SID : PRD

ABAP + JAVA system

We have Installed fresh SAP on DR site and now are planning to restore the DB and further steps to configure oracle dataguard.

I have gone through lot of forums and documents but I have below queries :

1. Can we use online backup and log backup to restore the DB ? in ABAP + JAVA case also same approach is OK ?

2. Is oracle dataguard already installed with Oracle 10g enterprise edition or will it be a separate installation ? How to access its console ?

3. I have found document for 11G but no detailed doc for 10G, if anyone of you can point me to correct detailed steps then it will be very helpful.

Regards,

SG

[former_member206552 · Accepted solution]

Hi SG

1) yes you can use the online backup to restore

From the primary host, perform an RMAN backup of the primary database that places the backupset into the staging directory:

[oracle@vmlinux1 ~]$ rman target sys/MySysPassword@modesto    RMAN> backup device type disk format '/u04/oracle/dg_staging/%U' database plus archivelog;

source : http://www.idevelopment.info/data/Oracle/DBA_tips/Data_Guard/DG_40.shtml

2) Oracle Data Guard is included with the Enterprise Edition and Personal Edition of the Oracle database software

source : http://docs.oracle.com/cd/B19306_01/server.102/b14230/install.htm

3) hope these help

http://docs.oracle.com/cd/B19306_01/server.102/b14239.pdf

http://www.dbazone.com/docs/oracle_10gDataGuard_overview.pdf

Best Regards

Marius

[Reagan]

Hello

1. Can we use online backup and log backup to restore the DB ? in ABAP + JAVA case also same approach is OK ?

Kindly be aware SAP J2EE systems hold the configuration data like hostname, SID, etc at the file system (/usr/sap/SID/DVEBMGS00 or /usr/sap/SID/JC00) level and also in the database.

So just keeping the standby database in sync with the primary database wouldn't be sufficient for the Java stack.

You will need to keep the file systems in sync as well.

Regards

RB