Hi,
I have an issue with my ASE 11.9.2 installation and I want some
advice.
My database is spread across four drives with one drive having tempdb
devices. Now, I had created the db with 18 data dev. and 5 log dev's.
But after loading it I found that one of the log device i.e sub_log05
has been added as a data dev and one of the data device sub_dat18 has
been added as a log device. Now, the first problem is as I have said
earlier that I have divided the data devices across two drives to get
better I/O and have placed all the log dev on one drive. The layout is
as follows --
/sda -- sub_dat01 to sub_dat08-- All these devices are in default
segment
/sdb -- sub_dat09 to sub_dat18 -- All these devices are placed in
xref_seg segment
/sdg -- tempdb devices
/sdf -- log devices

Now, sub_log05 being a data device has been placed in a wrong drive
and the log device sub_dat18 being a log device has been placed on a
drive exclusively meant for data devices. I don't think it will cause
any problems as long as the drives donot get corrupted. How do I
change the device names and move them to the proper drive. I was
thinking of mirroring for eg. mirror sub_dat18 which is now located in
/sdb to /sdf and then unmirror the primary side so that the permanent
location after unmirroring it remains as /sdf. and doing the same
thing with sub_log05. Will this help??? Am I going to lose any data
because of this??? Also, how do I rename these devices????

Please help.

Thanks

Subhas

dba_sybase2003 (AT) yahoo (DOT) com (Subhas) wrote in message news:<d7ca327.0401050757.1ea546ba (AT) posting (DOT) google.com>...
I haven't used the disk mirroring since shifting to RAID devices, the
disk mirror/unmirror method has worked for me with no data loss. Try
it on a test server.