Re: Oracle backups integrate with Swift
From: rick stehno <rs350z_at_me.com>
Date: Sun, 13 Nov 2016 14:27:29 -0500
Message-id: <FAE757CE-9AEE-41A6-B021-CCF918EB6BF2_at_me.com>
>> On Nov 11, 2016, at 2:47 PM, avramil_at_avramil.cnc.net wrote:
>>
>> Hi folks,
>>
>> I'm currently working on a private cloud project, using OpenStack.
>> For our Oracle databases, we are planning to build a Multitenant database on Sun Solaris hardware, alongside the Openstack tenants. In this environment, we are planning on using Swift for backups.
>>
>> What we woudl like to do is integrate RMAN with Swift Object Storage.
>> I believe that this be similar to what Oracle currently does with their own cloud implementations.
>>
>> The Oracle Database Cloud Backup Module appears to do this, so if might be possible on a private cloud:
>>
>> https://docs.us-phoenix-1.oraclecloud.com/Content/Database/Tasks/backingupOS.htm
>>
>> Note that in the configuration of the SBT_TAPE RMAN channel, a library file is referenced:
>>
>> "Configure RMAN to use the SBT device and point to the config file that was created when you installed the backup module. A sample command for a version 12 database is shown here.
>>
>> RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/home/oracle/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/home/oracle/config)'; "
>>
>> Has anyone out there tried to integrate Oracle/RMAN into a private Swoftstack?
>>
>> Thanks,
>> Lou
Date: Sun, 13 Nov 2016 14:27:29 -0500
Message-id: <FAE757CE-9AEE-41A6-B021-CCF918EB6BF2_at_me.com>
> Another possible suggestion if you are using Openstack is to use ceph as the backend storage for your backups. In the past, quite a few companies used Ceph as the backend storage for swift. Now the latest Openstack allows you to use Ceph without going thru the other stacks. > If you have a ceph cluster installed, It is very easy to setup RBD on the database server that allows you to point RMAN to a mounted device just like your current rman backups. RBD is RADOS Block Device, which allows a remote application to access Ceph as a block device. > I’m in the middle of publishing some papers that show how to hook up databases using Ceph as the backend storage instead of using a typical storage array with very good performance. For backups/archiving, Ceph would be an excellent choice. >
>> On Nov 11, 2016, at 2:47 PM, avramil_at_avramil.cnc.net wrote:
>>
>> Hi folks,
>>
>> I'm currently working on a private cloud project, using OpenStack.
>> For our Oracle databases, we are planning to build a Multitenant database on Sun Solaris hardware, alongside the Openstack tenants. In this environment, we are planning on using Swift for backups.
>>
>> What we woudl like to do is integrate RMAN with Swift Object Storage.
>> I believe that this be similar to what Oracle currently does with their own cloud implementations.
>>
>> The Oracle Database Cloud Backup Module appears to do this, so if might be possible on a private cloud:
>>
>> https://docs.us-phoenix-1.oraclecloud.com/Content/Database/Tasks/backingupOS.htm
>>
>> Note that in the configuration of the SBT_TAPE RMAN channel, a library file is referenced:
>>
>> "Configure RMAN to use the SBT device and point to the config file that was created when you installed the backup module. A sample command for a version 12 database is shown here.
>>
>> RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/home/oracle/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/home/oracle/config)'; "
>>
>> Has anyone out there tried to integrate Oracle/RMAN into a private Swoftstack?
>>
>> Thanks,
>> Lou
> > Rick Stehno > >
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Nov 13 2016 - 20:27:29 CET