Hermann Himmelbauer wrote:
On Friday 26 September 2003 20:07, Andrzej Ka�mierkiewicz wrote:this is LOG mirroring not DATA mirroring.
I created my database like this (with dbmcli):I use sapdb server 7.4.3.027 and dbmgui 7.4.3.10
I would like to have two devspaces - Master and Mirrored
---------- snip -------------- param_startsession param_init OLTP param_put LOG_MIRRORED YES param_put MAXUSERTASKS 5 param_put MAXCPU 2 param_checkall param_commitsession param_addvolume 1 LOG /scratch2/kandb/LOG_001 F 3000 param_addvolume 1 MLOG /scratch1/kandb/MLOG_001 F 3000 param_addvolume 1 DATA /home/sapdb/kandb/DAT_001 F 5000 db_admin util_connect
This is indeed again supported from 7.4.3 on with 7.4 SAP DB family and also with all 7.3.0 and smaller.
DATA mirroring is no longer supported by SAP DB since 7.4, sorry.
With 7.3 it was/is possible but as I read from development, it's not recommended also.
Therefore often the different versions of the DBMGUI are not supporting mirrored DATA devspaces/volumes in the correct way so that you may not be able to add more devspaces etc. when using DATA mirroring never the less.
Sometimes it's even not possible to get rid of it with the instance -> install when you have only a backup of data mirroring source database and take over the database parameter set from the backup. Then you have to delete the involved parameters of the data mirroring e.g. mirrored devspace definition etc. with dbmcli to get the right numbers of devspaces/volumes and so on.
The usual recommendation here is to use mirroring with operating system help or better equivalent or in most cases better hardware solutions.
Cheers Ralf
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
