Thursday, March 7, 2013

AWS EC2 Oracle Database backup

The two most common approaches for backing up Oracle databases hosted on EC2/EBS:  
1. The Oracle Secure Backup Cloud Module allows Oracle's Recovery Manager (RMAN) to backup/restore directly to/from S3.  https://aws.amazon.com/backup-storage/gsg-oracle-rman/ 
2. DBAs can put their tablespaces in hot backup mode, issue EBS snapshots using the EC2 CLI (http://docs.aws.amazon.com/AWSEC2/latest/CommandLineReference/OperationList-cmd.html), and then take the Oracle database out of hot backup mode as soon as the EC2 EBS snapshot API call returns.  While in hot backup mode, Oracle logs the full block images to the online and archived redo logs. There is a write up here on how this works:

1 comment:

  1. Hi,

    Nice post! You can also see another post in our web site about Oracle backup on EC2:

    http://www.n2ws.com/blog/ec2_consistent_oracle_backup.html

    -Uri

    ReplyDelete