Lee H. Marzke on 18 Oct 2011 11:28:45 -0700


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

[PLUG] ZFS talk followup, Oracle backup


At last nights talk on ZFS / OpenStorage the question was raised about how to
backup Oracle databases ( or a database in general ) with ZFS.

With the NexentaStor implementation,  there are plug-ins available for
assisting with Oracle.  See  [1]

- oracle backup: a plugin for nexenta allowing backup of remote oracle servers.
- remsnap:  perl script calling Nexenta API,  allowing remote devices to trigger
                   a ZFS snapshot.  Useful for any remote client side to trigger a DB
                   checkpoint and then a ZFS snapshot.

Install oracle plugin:

nmc$ setup plugin install oracle-backup

Flush Oracle buffers and do backup
   setup db oracle begin-backup
   create snapshot
   setup db oracle end-backup

[1]
http://www.nexenta.com/corp/nexentastor-faq-table/331-how-to-make-consistent-snapshot-of-a-database


Lee


--
"Between subtle shading and the absence of light lies the nuance of iqlusion..."  - Kryptos

Lee Marzke,  lee@marzke.net     http://marzke.net/lee/
IT Consultant, VMware, VCenter, SAN storage, infrastructure, SW CM
+1 800-393-5217  office         +1 484-348-2230               fax
+1 610-564-4932  cell           sip://8003935217@4aero.com    VOIP




BEGIN:VCARD
VERSION:3.0
FN:Lee Marzke
N:Marzke;Lee;;;
ADR;TYPE=home,postal,parcel:;;119 Pepper Dr.;Collegeville;PA;19426;
TEL;TYPE=cell,voice:610 564 4932
TEL;TYPE=work,voice:800 393 5217
EMAIL;TYPE=internet:lmarzke@4aero.com
EMAIL;TYPE=internet:lee@marzke.net
ORG:4aero
TITLE:Infrastructure Consultant
CATEGORIES:Family
REV:2011-10-16T11:01:11Z
UID:f5f810f6-3347-4915-9a40-567cf4591450:86081
END:VCARD
___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug