Moving Oracle Database between AWS instance.
When moving an Oracle database between two Amazon ec2 instances, we can easily accomplish it without backup/restore or Rman duplication as below. Setup - Oracle 11.2.0.1 Running on Amazone ec2 Linux 6.4 Requirment - Moving above oracle database from one Amazone ec2 instance (A) to another (B). Restrications - Need to Shutdown the database on source instance. (A) Step 1. In source ec2 instance, Take control file create statement to trace using below command, alter database backup controlfile to trace; Create pfile from spfile. create pfile from spfile Step 2. In source ec2 instance, Shutdown the oralce database. (In order put all data files on consistent state) Identify the volumes (EBS) which are storing the data files and take snapshot of each of the volume. (If you are dealing with large volumes, take a full AMI (Machine Image) prior to taking volume snapshots. Then after db shutdown take the volume snapshot. This will reduce the snapshot time) Ste