Btrfs devel - Feb 2012 - support for Oracle db consistent backups with btrfs snapshoting?

Will there be support for consistent backups á la NetApp when using
snapshots on btrfs filesystems that contain Oracle databases?

Im not that familiar with NetApp, and don''t know whether there needs
to be "extra support" for the Oracle bits for their snapshoting to
work, so please forgive me if this is a silly question.

Andrew
--
To unsubscribe from this list: send the line "unsubscribe linux-btrfs"
in
the body of a message to majordomo@vger.kernel.org
More majordomo info at  http://vger.kernel.org/majordomo-info.html

On 02/20/2012 07:49 PM, Andrew Henry wrote:
> Will there be support for consistent backups á la NetApp when using
> snapshots on btrfs filesystems that contain Oracle databases?
>
> Im not that familiar with NetApp, and don''t know whether there
needs
> to be "extra support" for the Oracle bits for their snapshoting
to
> work, so please forgive me if this is a silly question.
>
> Andrew
> --
> To unsubscribe from this list: send the line "unsubscribe
linux-btrfs" in
> the body of a message to majordomo@vger.kernel.org
> More majordomo info at  http://vger.kernel.org/majordomo-info.html
Hi Andrew,

I don''t know how exactly oracle db implements consistent backups, but I
can imagine how.
Oracle db probably runs some sort of script after commit of a database 
snapshot which commands NetApp filer to create a snapshot.
If that is so, I don''t see the oracle/btrfs configuration to be much 
different either. The oracle-side scripts can be made to run btrfs 
snapshot creation commands in this case.

Hope that helps.

Thanks,
Shyam
--
To unsubscribe from this list: send the line "unsubscribe linux-btrfs"
in
the body of a message to majordomo@vger.kernel.org
More majordomo info at  http://vger.kernel.org/majordomo-info.html

Hi,

I''m no NetApp expert, but as far as I know they have their own piece of
software which integrates their snapshots with oracle.

Creating consistent backups of a database isn''t a problem that a 
filesystem should solve at all. A simple approach for your problem would 
be "Put DB in hot backup mode and then create a snapshot".
I''m not sure
if there is a way to integrate RMAN backups with btrfs snapshots. Maybe 
an oracle expert could help out.

Kind regards,
Felix Blanke

On 2/20/12 4:29 PM, Shyam Prasad N wrote:
> On 02/20/2012 07:49 PM, Andrew Henry wrote:
>> Will there be support for consistent backups á la NetApp when using
>> snapshots on btrfs filesystems that contain Oracle databases?
>>
>> Im not that familiar with NetApp, and don''t know whether there
needs
>> to be "extra support" for the Oracle bits for their
snapshoting to
>> work, so please forgive me if this is a silly question.
>>
>> Andrew
>> --
>> To unsubscribe from this list: send the line "unsubscribe
linux-btrfs" in
>> the body of a message to majordomo@vger.kernel.org
>> More majordomo info at http://vger.kernel.org/majordomo-info.html
> Hi Andrew,
>
> I don''t know how exactly oracle db implements consistent backups,
but I
> can imagine how.
> Oracle db probably runs some sort of script after commit of a database
> snapshot which commands NetApp filer to create a snapshot.
> If that is so, I don''t see the oracle/btrfs configuration to be
much
> different either. The oracle-side scripts can be made to run btrfs
> snapshot creation commands in this case.
>
> Hope that helps.
>
> Thanks,
> Shyam
> --
> To unsubscribe from this list: send the line "unsubscribe
linux-btrfs" in
> the body of a message to majordomo@vger.kernel.org
> More majordomo info at http://vger.kernel.org/majordomo-info.html
--
To unsubscribe from this list: send the line "unsubscribe linux-btrfs"
in
the body of a message to majordomo@vger.kernel.org
More majordomo info at  http://vger.kernel.org/majordomo-info.html