Database replication only in one server from 3 different SAP servers

[former_member277815]

Dear Experts,

Our client have only one server for 3 SAP Database replication.

ECC 6.0, another is for CRM 7.0 and last one is DBM 4 (Dealer business management).

CRM, DBM and ECC could run on the same server . We have already allocated /oracle , /oracle/client/ , /oracle/stage/102_64 to ECC . Hence we can not have similar file systems mounted for CRM and DBM . We will have /oracleCRM , /oracleCRM/client/ , /oracleCRM/stage/102_64 for CRM and /oracleDBM , /oracleDBM/client/ , /oracleDBM/stage/102_64 for DBM . Since we dont have an SAP application, we need to install fresh oracle in these file systems and replicate the database . The data file structure is the same like our production server.

Now they replicated ECC 6 Properly, and now my responsibility is to replicate the CRM & DBM servers into same server.

Server Details:

HP UX 11.31

Oracle 10.2.0.4.0

abap stack only

Please tell me the steps from the starting for replication the 2 more database into same server.

Regards.

Rishi

[Former Member · Accepted solution]

Hi Rishi,

We are running on the same scenario like yours. So, you need to install a new Oracle home for each primary system, at the standby site. In that case, you should install 3 different Oracle home for CRM, DBM and ECC. Please find the folder structure, below;

/oracle/CRM

/oracle/DBM

/oracle/ECC

Each installation will have its own configuration. But, you should configure the different listener port number for each listener.

Best regards,

Orkun Gedik

[former_member277815 · Accepted solution]

Thanks Orkun for your quick reply.

Can you please tell me in detail, only the problem is this will be my first replication.

if possible please let me know step by steps..

e.g.

Create file system same as PRD.

Install SAP with same SID & SCHEMA.

Take offline backup of PRD & Restore to DR.

Keep DR Database at mount condition.

Copy archive logs to DR

Apply logs

Thanks,

Rishi

[Former Member · Accepted solution]

Hi Rishi,

You can find the major steps, below;

1) Install Oracle. For example; CRM -> /oracle/CRM, DBM -> /oracle/DBM, ECC -> /oracle/ECC

2) Install SAP system. At this stage, do not forget to set different listener ports for each SAP system

3) Copy SAP profiles into the directories on the standby site

4) Restore database

5) Create password file and copy to the standby site

6) Apply the offline redologs

7) Create control file and copy to the standby

😎 Mount the database to "STANDBY DATABASE"

9) Be sure that the systems is started the log shipment

Perform these steps, for each installation. In short install Oracle and SAP systems on the same host and give different listener port for each system.

Check the document below, for the further information;

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm

Best regards,

Orkun Gedik

[former_member277815 · Accepted solution]

Dear Orkun,

Thank you very much for your quick feeds,,

SIDs are as follows..

PE2 (DBM)

PM1 (CRM)

PE1 (ECC)

1. we created the mount point in our server..

i.e.

/oracle/PE2

/oracle/PM1

/oracle/PE1

2. is it really required 2nd and 3rd point (because we dont need SAP application in this server)

most important : should we need to install same oracle 10.2.4.0 and Oracle Client?

Should we need to install 3 times (installation of oracle) in one server for each SID?

or can we copy oracle installation mount folder from primary server?

if possible to copy from primary servers what should we need to change in standby server?

Thanks in Advance

Rishi

[Former Member · Accepted solution]

Rishi,

Yes you should perform separated Oracle installations for each SID. If you don't install them separately, how do you configure which standby is correspond to which primary server?

So, each standby installation have to have its own listener and profile files. Under this circumstance, even if you don't install the SAP on standby, you have to perform separate installations.

After this clarification, let's come back to the questions;

>> most important : should we need to install same oracle 10.2.4.0 and Oracle Client?

Yes, you should. You can share "bin" folder, but not recommended.

>> Should we need to install 3 times (installation of oracle) in one server for each SID?

Yes

>> or can we copy oracle installation mount folder from primary server?

Technically you can, but it is easier to install new one

>> if possible to copy from primary servers what should we need to change in standby server?

You should change environment variables, change the profiles.

Best regards,

Orkun Gedik

[former_member277815 · Accepted solution]

Hi Orkun and Experts,

I did these steps in my Primary Database.

Step 1. Install Oracle with patch 10.2.0.4.0 in standby server (NSRVR502)

Step 2. Create a Backup Copy of the Primary Database Data files

Step 3. Enable forced logging on your primary database:

SQL> ALTER DATABASE FORCE LOGGING;

Step 4. Create a password file this is already existing in "$ORACLE_HOME/dbs/orapwPM1"

So I check by run the following command:

SQL> select * from v$pwfile_users;

USERNAME SYSDB SYSOP

-

---

-

---

-

---

SYS TRUE TRUE

SYSTEM TRUE FALSE

Step 5. Create control file as follows below command.

SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/PM1.ctl';

Step 6. Create pfile from spfile for the primary database:

SQL> create pfile=u2019/tmp/pfilePM1.orau2019 from spfile;

Step 7. Configure a Standby Redo log.

1) The size of the standby redo log files should match the size of the current Primary database online redo log files. To find out the size of your online redo log files:

I ran below command

SQL> select bytes from v$log;

Result :

SQL> select bytes from v$log;

BYTES

-

---

52428800

52428800

52428800

52428800

Step 8. for determining our current log file groups:

I ran below command.

SQL> select group#, member from v$logfile;

Result :

GROUP#

-

---

MEMBER

-

---

1

/oracle/PM1/origlogA/log_g11m1.dbf

1

/oracle/PM1/mirrlogA/log_g11m2.dbf

2

/oracle/PM1/origlogB/log_g12m1.dbf

GROUP#

-

---

MEMBER

-

---

2

/oracle/PM1/mirrlogB/log_g12m2.dbf

3

/oracle/PM1/origlogA/log_g13m1.dbf

3

/oracle/PM1/mirrlogA/log_g13m2.dbf

GROUP#

-

---

MEMBER

-

---

4

/oracle/PM1/origlogB/log_g14m1.dbf

4

/oracle/PM1/mirrlogB/log_g14m2.dbf

8 rows selected.

Step 9. for Create standby Redo log groups.

I ran below command:

result :

SQL> alter database add standby logfile '/oracle/PM1/origlogA/log_g11m1.dbf' size 52428800;

alter database add standby logfile '/oracle/PM1/origlogA/log_g11m1.dbf' size 52428800

*

ERROR at line 1:

ORA-01577: cannot add log file '/oracle/PM1/origlogA/log_g11m1.dbf' u2013 file already part of database

Please tell me what should we do now? tell me next step so that we can replicate our data in real-time.

I already copy our all datafiles and redolog files into standby server, is there any problem?

Do we need to change anything in any file like: pfilePM1.ora, control file and password file. If yes what should we need to change?

Is this will be same in standby server.. db_unique_name=PM1

Regards,

Rishi

[Former Member · Accepted solution]

Hi,

Find the title "Creating standby redo log files" the in the guide, below;

http://www.oracle.com/us/solutions/sap/wp-ora4sap-dataguard11g-303811.pdf

alter database add standby logfile '/oracle/PM1/origlogA/log_g11m1.dbf' size 52428800 reuse;

>> Do we need to change anything in any file like: pfilePM1.ora, control file and password file. If yes what should we need to change?

Check the document. It has not so much different configuration steps between 10g and 11g

Best regards,

Orkun Gedik

[former_member277815 · Accepted solution]

Hi experts,

Please tell me how to configure multiple SID with single listener.

I configured the DR setup of two databases in single server. Now the problem is, if I start one listener from orapm1(CRM), my data is replicating only for CRM, and if I am going to start my listener from oraPE2 user (DBM), error is coming u201C listener is already startu201D but DBM is not replicating with DR site.

And when I stop the listener from oraPM1, and start listener from user oraPE2(DBM), my DBM is replicating properly, I want to start both in parallel with one listener.

Right now I have only one port for both database (1527) and only one LISTENER, should I need to change the port for one server e.g DBM (primary and standby), and then change in listener files. For both side (primary and standby)

If I am correct please let me know the steps, what precautions we need to take.

And what change I need to do in listener file.

2nd) Can I work on same port for both SIDs, if yes please tell me the steps.

My CRM is working properly so I need to change in DBM part.

I am attaching listener file from both users in same server (10.11.230.12)

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER_PE2 =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = PE2.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = PE2)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = 10.11.230.12)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PE2)

(ORACLE_HOME = /oracle/PE2/102_64)

)

)

pm1 listener file

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = PM1.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = PM1)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = 10.11.230.12)

(PORT = 1527)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PM1)

(ORACLE_HOME = /oracle/PM1/102_64)

)

)

Thanks in advance.

[former_member277815]

change the listener name in standby and change the port no. in both (primary and standy) servers.

both listener is up now..