I have a scenario where I have several ORACLE databases. I'm trying to keep system downtime to a minimum for business reasons. I've created zpools on three devices, an internal 148 Gb drive (data) and two partitions on an HP SAN. HP won't do JBOD so I'm stuck with relying upon HP to give me a clean partition and do all the dirty work in the background. On the SAN I've got slow disk and fast disk. Hence, I've created the following:
data/zfs1 data/zfs2 fastsan/zfs3 fastsan/zfs4 slowsan/zfs5 slowsan/zfs6 I've got a script that brings down the databases, does a snapshot, then brings the databases back up. I'm left with # zfs list -t snapshot NAME USED AVAIL REFER MOUNTPOINT data/[EMAIL PROTECTED] 7.34G - 7.34G - data/[EMAIL PROTECTED] 7.34G - 7.34G - fastsan/[EMAIL PROTECTED] 368M - 1.59G - fastsan/[EMAIL PROTECTED] 3.57G - 3.57G - slowsan/[EMAIL PROTECTED] 3.57G - 3.57G - slowsan/[EMAIL PROTECTED] 658M - 1.13G - Then I use Legato Networker 7.3.2 to back up the server. As ALL tends to ignore the snapshot directories, I've hard coded the locations to be backed up including: / /usr /opt /var /export/home /data/zfs1/.zfs/snapshot/nightly /data/zfs2/.zfs/snapshot/nightly /fastsan/zfs3/.zfs/snapshot/nightly /fastsan/zfs4/.zfs/snapshot/nightly /slowsan/zfs5/.zfs/snapshot/nightly /slowsan/zfs6/.zfs/snapshot/nightly On restore, I'll just drop the files into their correct locations. Note that I am NOT backing up the databases directly. There's no point, they're up and running again. Is this workable? I don't have enough disk to do clones and I haven't figured out how to mount snapshots directly. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. _______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
