Re: Backup to AWS Using RMAN

We use AWS file gatway to mount an S3 bucket to our servers. Some servers are on prem and some on AWS itself... Works flawlessly and is also POSIX complaint as well from blob storage standpoint.

On Thu, Apr 19, 2018, 2:53 PM angelo <angelolistas_at_gmail.com> wrote:

>
> Thank you, Fernando
>
> I´ll try to make a poc, maybe fit to our needs
>
> we have a small database (less than 30 GB), not running on asm
>
>
>
> On 17 April 2018 at 16:50, <correo_at_fjandrade.com> wrote:
>
>> Hi Angelo
>>
>>
>>
>> Doing this is not that complicate.
>>
>>
>>
>> First what I’m going to explain is for a small database (around 100G) and
>> the datafiles and the FRA are located on a filesystem not ASM, and the
>> server has access to AWS.
>>
>> First open an AWS account, create your credentials, and create a bucket.
>>
>> Install S3 CLI on the server and configure the client access, it needs
>> Python <http://www.python.org/download/> 2.6.5; on some old servers
>> that’s a problem.
>>
>> Once you have everything just sync your FRA with your bucket, the sync
>> command works like rsync so it will only copy what is left on the bucket,
>> just put that on the crontab.
>>
>> https://docs.aws.amazon.com/cli/latest/reference/s3/sync.html
>>
>> Back on AWS configure the retention policy for the bucket so old backups
>> get delete or moved to cold storage.
>>
>>
>>
>> And that’s it. I think is a lot more complex and a complete solution use
>> the storage gateway for AWS.
>>
>> If your FRA is on ASM maybe implementing a virtual VTL is a good idea.
>>
>> But this works for me and for a small database.
>>
>>
>>
>> FJA
>>
>>
>>
>> *From:* angelo <angelolistas_at_gmail.com>
>> *Sent:* Monday, April 16, 2018 6:43 PM
>> *To:* correo_at_fjandrade.com
>> *Cc:* david.barbour1_at_gmail.com; oracle-l mailing list <
>> oracle-l_at_freelists.org>
>> *Subject:* Re: Backup to AWS Using RMAN
>>
>>
>>
>> hola Fernando, hello folks
>>
>>
>>
>> How did you do that ? syncing the fra from the fs as source
>>
>>
>>
>> >I do S3 backups for a small client that uses >filesystem not ASM. I
>> simply sync the FRA >with S3.
>>
>>
>>
>> are you using some client for s3? linux or windows environment
>>
>>
>>
>> Is the Oracle server in aws too?
>>
>>
>>
>> regards,
>>
>>
>>
>> angelo
>>
>>
>> On Monday, 16 April 2018, <correo_at_fjandrade.com> wrote:
>>
>> Hi David
>>
>>
>>
>> I do S3 backups for a small client that uses filesystem not ASM. I simply
>> sync the FRA with S3.
>>
>> On S3 I tiered the storage so we have only 1 month on hot storage, all
>> the rest on cold and backups older than 3 months gets deleted automatic, we
>> have a couple of TBs of storage and the bill is no high at all.
>>
>> I have done some restores and works flawlessly, just sync the backup of
>> the day you want.
>>
>> I don´t use the catalog, I just sync the autobackup for the controlfiles.
>>
>> This is enough for a small company.
>>
>>
>>
>> I do know that Amazon has a storage gateway and Virtual Tape Libraries.
>>
>> I didn´t try it yet.
>>
>> https://aws.amazon.com/es/storagegateway/vtl/
>>
>>
>>
>> Regards
>>
>>
>> FJA
>>
>>
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
>> Behalf Of *David Barbour
>> *Sent:* Monday, April 16, 2018 12:29 PM
>> *To:* oracle-l mailing list <oracle-l_at_freelists.org>
>> *Subject:* Backup to AWS Using RMAN
>>
>>
>>
>> Good Morning,
>>
>>
>>
>> We have had a number of incidents with Oracle Cloud Storage and are not
>> planning on renewing when our contract expires. Currently - and for the
>> past 10 days - we have not been able to perform backups as we have for the
>> second time in less than six months experienced an 'account issue' where
>> our contracted 20TB of space has been re-allocated to zero.
>>
>>
>>
>> I'd like to be able to back up to AWS, but cannot even think of
>> approaching management with either the cost or thought of purchasing an
>> Oracle product such as Oracle Secure Backup at this point.
>>
>>
>>
>> Has anyone used RMAN to back up to AWS EC2, EBS, EFS or S3 in conjunction
>> with a catalog?
>>
>>
>>
>> Seems to me there are several ways to approach this. It would be a great
>> help if anyone has some insight.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon>
>>
>> Virus-free. www.avast.com
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link>
>>
>>
>>
>>
>>
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> Virus-free.
>> www.avast.com
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link>
>> <#m_-6341385931925898674_m_-5693500372785310186_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
>
>

--
http://www.freelists.org/webpage/oracle-l