RE: Backup to AWS Using RMAN
- From: <correo@xxxxxxxxxxxxx>
- To: "'angelo'" <angelolistas@xxxxxxxxx>
- Date: Tue, 17 Apr 2018 14:50:45 -0500
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@xxxxxxxxx>
Sent: Monday, April 16, 2018 6:43 PM
To: correo@xxxxxxxxxxxxx
Cc: david.barbour1@xxxxxxxxx; oracle-l mailing list <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx <
mailto:correo@xxxxxxxxxxxxx> >
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@xxxxxxxxxxxxx <
mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx <
mailto:oracle-l-bounce@xxxxxxxxxxxxx> > On
Behalf Of David Barbour
Sent: Monday, April 16, 2018 12:29 PM
To: oracle-l mailing list <oracle-l@xxxxxxxxxxxxx
<
mailto:oracle-l@xxxxxxxxxxxxx> >
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
Other related posts: