DR server with maxdb

[Former Member]

Hi All,

we can configured dr server with oracle in this way very easily.

1) install sap on target system (DR)

2) copy offline data file oracle control files and redolog files from source

3)past at same location of target (DR)

4) start mount db

5) recover db using backup control file.

auto

Please guide how we configure DR with maxdb, in this way or there is an other way.

Best Regards

Khan

[markus_doehr2]

> Please guide how we configure DR with maxdb, in this way or there is an other way.

The procedure is basically the same.

http://wiki.sdn.sap.com/wiki/display/MaxDB/HowTo-StandbyDBlog+shipping

Markus

[Former Member]

Thanks Master,

Please Guide.

1) Install SAP on target system (DR) with same DB version as source

2) take complete backup of source system (PRD)

3) restore on target (DR) using DBMGUI...> restore ..... db admin mode ?

4) copy log from source to target

5) command for apply log ?

[former_member188883]

Hi Imran,

you can refer SAP installation guides from service.sap.com/instguides for SAP installation on respective OS/DB platforms.

The same can be identified for MaXDB database.

Regards,

Deepak Kori

[Former Member]

Hi Imran,

Please follow in given sequence.

dbmcli -u <MaxDB User>,<Its password> -d <DB SID>

1. To bring Database in admin mode

dbmcli prompt>db_admin -f

dbmcli prompt>util_connect

1. To start resoration of Datafile

dbmcli prompt>db_activate RECOVER <media name> DATA

##Use the media name which you have defined with complete path of Data backup location

1. Import the first log backup

dbmcli prmot>recover_start <log Media name> LOG 976

##use the media name which you have defined with complete path of Log backup location, where log file names were like XYZ_log.976

1. Import any more log backups, provide full pathname as well.

dbmcli prompt>recover_replace <log Media name> /sapdb/BACKUP/tempLogRestore/XYZ_log 977

1. When all logs are restored

dbmcli prmot>recover_ignore

1. To bring Database online

dbmcli prmot>db_online

Hope this helps.