Monday 11 April 2011

ASE : Striping Dump Devices

Sybase (prior to version 12) has a 2 GB dump file size limitation for most
platforms. Getting around this is easy - simply stripe the dumps across multiple
files or devices. The examples below use file names instead of device names.

dump database hr_db to '/usr2/dumps/remote/db_hr05121318.dmp'
stripe on '/usr2/dumps/remote/db_hr_S1_05121318.dmp'
stripe on '/usr2/dumps/remote/db_hr_S2_05121318.dmp'
go

load database hr_db from '/usr2/dumps/remote/db_hr05121318.dmp'
stripe on '/usr2/dumps/remote/db_hr_S1_05121318.dmp'
stripe on '/usr2/dumps/remote/db_hr_S2_05121318.dmp'
go
online database hr_db
go

No comments:

Post a Comment