Hi All, We have Oracle installed under ZFS. I've created snapshots and clones. They work as advertised. Say the DBAs want to upgrade to a new version of Oracle, without installing from scratch. I would like them to be able to take the clone, upgrade that, and then promote the clones to new file systems. But the way we have ZFS setup right now, you can't promote outside of the ZFS file system. For example, here's the current setup:
bash-3.00# zfs list NAME USED AVAIL REFER MOUNTPOINT r12_data 594G 65.4G 24.5K none r12_d...@10202008 0 - 24.5K - r12_data/.clone1 0 65.4G 24.5K none r12_data/d01 41.7G 4.32G 41.4G /opt/d01/oakwcr12 r12_data/d...@12042008 257M - 41.5G - r12_data/d01/.clone.12052008 0 4.32G 41.5G /opt/d01/oakwcr12/.clone.12052008 r12_data/d02 39.5G 2.53G 39.4G /opt/d02/oakwcr12 r12_data/d...@12042008 115M - 39.4G - r12_data/d02/.clone.12052008 0 2.53G 39.4G /opt/d02/oakwcr12/.clone.12052008 r12_data/d03 38.8G 3.23G 38.4G /opt/d03/oakwcr12 r12_data/d...@12042008 398M - 38.6G - r12_data/d03/.clone.12052008 0 3.23G 38.6G /opt/d03/oakwcr12/.clone.12052008 r12_data/d04 40.3G 3.69G 40.3G /opt/d04/oakwcr12 r12_data/d...@12042008 18.8M - 40.3G - r12_data/d04/.clone.12052008 0 3.69G 40.3G /opt/d04/oakwcr12/.clone.12052008 r12_data/d05 32.3G 9.73G 32.1G /opt/d05/oakwcr12 r12_data/d...@12042008 208M - 32.2G - r12_data/d05/.clone.12052008 0 9.73G 32.2G /opt/d05/oakwcr12/.clone.12052008 r12_data/d06 39.2G 2.84G 39.0G /opt/d06/oakwcr12 r12_data/d...@12042008 129M - 39.1G - r12_data/d06/.clone.12052008 0 2.84G 39.1G /opt/d06/oakwcr12/.clone.12052008 r12_data/d07 31.1G 10.9G 31.1G /opt/d07/oakwcr12 r12_data/d...@12042008 53.9M - 31.1G - r12_data/d07/.clone.12052008 0 10.9G 31.1G /opt/d07/oakwcr12/.clone.12052008 r12_data/d08 39.8G 2.22G 39.6G /opt/d08/oakwcr12 r12_data/d...@12042008 163M - 39.7G - r12_data/d08/.clone.12052008 0 2.22G 39.7G /opt/d08/oakwcr12/.clone.12052008 r12_data/d09 40.0G 2.03G 39.9G /opt/d09/oakwcr12 r12_data/d...@12042008 103M - 39.9G - r12_data/d09/.clone.12052008 17K 2.03G 39.9G /opt/d09/oakwcr12/.clone.12052008 r12_data/d10 41.7G 2.35G 41.5G /opt/d10/oakwcr12 r12_data/d...@12042008 112M - 41.5G - r12_data/d10/.clone.12052008 18K 2.35G 41.5G /opt/d10/oakwcr12/.clone.12052008 r12_data/d11 38.9G 3.14G 38.7G /opt/d11/oakwcr12 r12_data/d...@12042008 146M - 38.7G - r12_data/d11/.clone.12052008 18K 3.14G 38.7G /opt/d11/oakwcr12/.clone.12052008 r12_data/d12 14.1G 27.9G 13.4G /opt/d12/oakwcr12 r12_data/d...@12042008 700M - 13.4G - r12_data/d12/.clone.12052008 17K 27.9G 13.4G /opt/d12/oakwcr12/.clone.12052008 r12_data/d21 36.6G 5.42G 36.6G /opt/d21/oakwcr12 r12_data/d...@12042008 258K - 36.6G - r12_data/d21/.clone.12052008 17K 5.42G 36.6G /opt/d21/oakwcr12/.clone.12052008 r12_data/d22 40.1G 1.89G 40.1G /opt/d22/oakwcr12 r12_data/d...@12042008 373K - 40.1G - r12_data/d22/.clone.12052008 17K 1.89G 40.1G /opt/d22/oakwcr12/.clone.12052008 r12_data/d23 39.8G 2.16G 39.8G /opt/d23/oakwcr12 r12_data/d...@12042008 780K - 39.8G - r12_data/d23/.clone.12052008 17K 2.16G 39.8G /opt/d23/oakwcr12/.clone.12052008 r12_data/d24 39.9G 2.14G 39.9G /opt/d24/oakwcr12 r12_data/d...@12042008 582K - 39.9G - r12_data/d24/.clone.12052008 16K 2.14G 39.9G /opt/d24/oakwcr12/.clone.12052008 r12_logz 204K 13.7G 20K /opt/l01/oakwrc12 r12_l...@10202008 23.5K - 24.5K - r12_logz/.clone.12052008 15K 13.7G 18K /opt/l01/oakwrc12/.clone.12052008 r12_oApps 55.9G 22.3G 55.2G /opt/a01/oakwcr12 r12_oa...@10202008 369M - 55.2G - r12_oApps/.clone.12052008 365M 22.3G 55.2G /opt/a01/oakwcr12/.clone.12052008 r12_oWork 8.00G 31.1G 8.00G /opt/w01/oakwcr12 r12_ow...@10202008 24.5K - 8.00G - r12_oWork/.clone.12052008 16K 31.1G 8.00G /opt/w01/oakwcr12/.clone.12052008 r12_product 4.77G 13.8G 4.71G /opt/p01/oakwcr12 r12_prod...@10202008 28.8M - 4.71G - r12_product/.clone.12052008 28.3M 13.8G 4.71G /opt/p01/oakwcr12/.clone.12052008 bash-3.00# Say the DBAs want to go from R12 to R13. I suppose they could upgrade to R13, rename everything to R13/whatever, but then R12 is gone. How about keeping all the R12 along side the R13 and let both run Oracle. Is there a way of doing that? I thought of just creating one, gigantic file system for R12 and cloning that, but it becomes unwieldy with several hundred GB of data. All ideas, thoughts, and suggestions are welcome. _______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
