> -----Original Message-----
> From: Mischa Orlowski [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 05, 2004 1:48 PM
> To: [EMAIL PROTECTED]
> Subject: several log questions #2
>
>
> Hi there,
>
> unfortunately nobody answered my last question. I hope this
> try is more successfull. Thank u. #### At first, i am using
> SAPDB 7.4.3 Build 014-000-037-95 on different Linux platforms.
>
> First question:
> Can u please give me an example on how to create a mirrored
> logfile. I know to set log_mirrored to yes, but both
> param_addvolume(database creation) and db_addvolume
> (afterwards) always fail.
>
> example:
> dbmcl>help db_addvolume
> OK
> db_addvolume <mod> <nam> <typ> <siz> <mnam> <mtyp>
>
> ---
> dbmcli>db_addvolume mlog /home/sapdb/duplexlog/log01 f 2621
> ERR
> -24996,ERR_PARAM: wrong parameter
Hi,
if you create a new database-instance, then it should be sufficient
to do a param_addvolume and set LOG_MIRRORED to YES.
During the instanciation-process afterwards the mirroring
should be setup correctly.
If you want to change the logmode from single to mirrored
for an exisiting database instance, then you have to execute
some more steps:
db_admin
param_addvolume ....
param_startsession
param_put LOG_MIRRORED YES
param_checkall
param_commitsession
db_offline
db_admin
and then while you get a volumename by
util_execute GET BAD LOG VOLUME
execute a
util_execute RESTORE LOG VOLUME 'insert here the volume name'
after this restart the database.
The command db_addvolume really adds only a volume to
an existing configuration. This expecially means that
it does not change the LogMode to mirrored.
regards, Martin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
