on 09-17-2014 4:51 PM
Hi,
Please help us with the procedure to change the "saplog" path from one directory to other directory on MAXDB 7.8.
e.g., In my current situation, saplog directory path is H:/sapdb/DEV/saplog/, which we need to change to F:/sapdb/DEV/saplog.
Thank You
Regards,
Amit
Hi Amit,
You can use dbmrelocate command to change the log file path.
Refer to documentation below for detailed information
dbmrelocate - MaxDB - SCN Wiki
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak,
Thanks for your quick reply. I'm very new to MAXDB. Please let me know if you need to bring the database to any specific mode (just like mount/no mount in oracle). Also can you confirm below command will modify only log area or complete db path.
>dbmrelocate -d DEV -sourcedata "H:\sapdb\DEV\saplog\" -target "F:\sapdb\DEV\saplog"
Thank You
Regards,
Amit
Hello Amit,
dbmrelocate is to relocate the existing MaxDB installation to another installation. You cannot move LogVolumes
Refer to the Wiki section below on how to move MaxDB volumes:
Regards,
Yashwanth
Hello Amit,
as Yashwanth has put it correctly: you cannot use dbmrelocate for moving volumes...
But let me add that the above referred Wiki section describes changing the volume path with the GUI Database Manager only. Very good GUI guide, but a bit outdated since for newer database releases we have switched to MaxDB Database Studio.
If you want to, you can always use the command line as an alternative approach:
1. establish a dbmcli session via 'dbmcli -d <database name> -u <user,password>
2. bring the database to 'offline' state.
3. Identify the current location of the volume you want to move e.g. the path is part of the KnlMsg file or you can get it via the 'param_getvolsall' command.
4. Change the path via 'param_directput DataVolumeName...'.
Here is an example of moving data volume 1 from C: to F: (database is already in offline state):
dbmcli on tz79>param_getvolsall
OK
UseMirroredLog NO
MaxLogVolumes 2
MaxDataVolumes 64
LogVolumeName001 6400 F C:\sapdb\data\TZ79\volumes\log\DISKL0001 1
DataVolumeName0001 32000 F C:\sapdb\data\TZ79\volumes\data\DISKD0001
dbmcli on tz79>param_getvalue DataVolumeName0001
OK
C:\sapdb\data\TZ79\volumes\data\DISKD0001
dbmcli on tz79>param_directput DataVolumeName0001 F:\sapdb\data\TZ79\volumes\data\DISKD0001
OK
dbmcli on tz79>param_getvolsall
OK
UseMirroredLog NO
MaxLogVolumes 2
MaxDataVolumes 64
LogVolumeName001 6400 F C:\sapdb\data\TZ79\volumes\log\DISKL0001 1
DataVolumeName0001 32000 F F:\sapdb\data\TZ79\volumes\data\DISKD0001
Thorsten
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.