Moving Log files from Data files location

[Former Member]

Hi All,

We have installed SAP BO + Sybase + Linux and used below file systems.

/sybase/SID/sapdata_1

/sybase/SID/saplog_1

But the datafile SID_data_001.dat  & log file --> SID_log_001.dat placed in /sybase/SID/sapdata_1 during the installation.

Please help  to move the Log file file SID_log_001.dat  from /sybase/SID/sapdata_1 into /sybase/SID/saplog_1.

Regards,

Karthik

[christoph_heimann]

Hello Karthik,

you can use the ASE "disk mirroring" feature for this task. Please have also a look into the documentation at

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36272.1572/html/commands/...

Example:

# enable disk mirroring

1> use master

2> go

1> sp_configure 'disable disk mirroring',0

2> go

# maybe a restart is required because this is a static parameter...

# mirror device to new location

1> disk mirror name="SID_log_001", mirror="/sybase/SID/saplog_1/SID_log_001.dat"

2> go

# break mirror and use mirror side for new location

1> disk unmirror name="SID_log_001", side="primary", mode="remove"

2> go

# control your new device location

1> sp_helpdevice

2> go

Please be aware that ASE will not remove the old SID_log_001.dat file from sapdata_1 directory. This has to be done manually after you are sure that mirroring was successful.

Best regards

Christoph