Our production environment is running on AWS cloud. At web layer we're running Apache, App- running in tomcats, Oracle-Standard edition running in EC2.
In our current backup and restore process, we take logical backup using Oracle DataPump Tool, as our Schema size is more than 100 GB it take more than 15-20hrs to complete the backup because compressing that backup itself takes more than 5-6 hrs. Our maintenance window is only 2hrs. Also, we take EBS snapshot backups of live servers after every 4hrs of all prod instances(web/app/db).
Many times we faced errors when we used EBS snapshot restored backup with our applications and our developers suspected that EBS Snapshot backups are not consistent and we should take backup when instances are in static and steady state.
Could someone please advice a better way to achieve consistent backups.
PS : I heard RMAN can be a better option but I don't know much about it.