RE: Backup to AWS Using RMAN

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 <http://www.python.org/download/> Python 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 <mailto: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 <mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org <mailto: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 <mailto: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. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link> www.avast.com  

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


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