Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Am considering Amazon RDS to host our Oracle database. Ideally, I'd like to have my daily backup and as many of the transaction logs as possible since copied to an external location in case of Amazon failure. Although they've automated the backup/restore process, I can't rely totally on that and don't see a way to create an offsite backup of my data. The closest thing I can find is in their announcement for cross-region snapshot copies:

"Once a DB Snapshot is copied to a specific AWS Region, any subsequent copy operations of the DB Snapshots of the same DB Instance to that Region will only transfer the data that has changed since the last copy. Thus the subsequent copy operations transfer fewer amounts of data and complete faster."

Seems to imply that I could copy a snapshot multiple times a day, obviously a hack. Anyone have a solution for this?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.