Re: Backup to AWS Using RMAN

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_-5693500372785310186_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>

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