Re: [zfs-discuss] Is this a workable ORACLE disaster recovery solution?

2007-05-11 Thread Matthew Ahrens

Bruce Shaw wrote:

Mark J Musante [EMAIL PROTECTED] wrote:


Maybe I'm misunderstanding what you're saying, but 'zfs clone' is

exactly
the way to mount a snapshot.  Creating a clone uses up a negligible
amount
of disk space, provided you never write to it.  And you can always set
readonly=on if that's a concern.

So something like:

zfs snapshot fastsan/[EMAIL PROTECTED]
zfs clone fastsan/[EMAIL PROTECTED] fastsan/zfs3/night
zfs set readonly=on fastsan/zfs3/night

...do backup...

zfs destroy fastsan/zfs3/night


Yep.  Don't forget to destroy the snapshot as well, if you want your 
space back ('zfs destroy fastsan/[EMAIL PROTECTED]').


That said, if it works to point Legato at the .zfs/snapshot/nightly 
directory, then that seems like less steps.


--matt
___
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss


Re: [zfs-discuss] Is this a workable ORACLE disaster recovery solution?

2007-05-10 Thread Mark J Musante
On Thu, 10 May 2007, Bruce Shaw wrote:

 I don't have enough disk to do clones and I haven't figured out how to
 mount snapshots directly.

Maybe I'm misunderstanding what you're saying, but 'zfs clone' is exactly
the way to mount a snapshot.  Creating a clone uses up a negligible amount
of disk space, provided you never write to it.  And you can always set
readonly=on if that's a concern.


Regards,
markm
___
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss


RE: [zfs-discuss] Is this a workable ORACLE disaster recovery solution?

2007-05-10 Thread Bruce Shaw
Mark J Musante [EMAIL PROTECTED] wrote:

Maybe I'm misunderstanding what you're saying, but 'zfs clone' is
exactly
the way to mount a snapshot.  Creating a clone uses up a negligible
amount
of disk space, provided you never write to it.  And you can always set
readonly=on if that's a concern.

So something like:

zfs snapshot fastsan/[EMAIL PROTECTED]
zfs clone fastsan/[EMAIL PROTECTED] fastsan/zfs3/night
zfs set readonly=on fastsan/zfs3/night

...do backup...

zfs destroy fastsan/zfs3/night

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


Re: [zfs-discuss] Is this a workable ORACLE disaster recovery solution?

2007-05-10 Thread Wade . Stuart






[EMAIL PROTECTED] wrote on 05/10/2007 02:19:17 PM:

 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:





I do not get it -- your goal is to keep downtime to a minimum and you are
forgoing hot (online) backups? Even with snap/clones you are still
thrashing the same volume and db performance will be degraded as the data
is read from disk for the backup,  you really gain little going to cold
state.



http://orafaq.com/faqdbabr.htm#HOW



Networker has an oracle hot backup extension -- or you can do it on the
cheap with a pre/post script (google rman).

http://software.emc.com/products/software_az/networker_module_for_oracle.htm



-Wade


___
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss