Oracle Database Online Backup and Restore in Amazon Web Services

Owned by Jenni Wallin
Last updated: Jun 14, 2023
1 min read

Amazon RDS provides two different methods for backing up and restoring your Amazon database instances, automated backups and database snapshots. Automated backups automatically back up your database instance during a specific, user-definable backup window, and keeps the backups for a limited, user-specified period of time (called the backup retention period); you can later recover your database to any point in time during that retention period. database snapshots are user-initiated backups that enable you to back up your database instance to a known state, and restore to that specific state at any time. Amazon RDS keeps all database snapshots until you delete them. 

For more information about these methods, see the Amazon Web Services documentation.

To restore the database from a backup:

  1. Shut down .

  2. Restore the database according to the Amazon Web Services documentation.
    If you are restoring from an automated backup, see  http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIT.html.
    If you are restoring from a snapshot, see  http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.html.

    Note!

     This step requires that a new database instance is created.

  3. Update property url in the standard service storage-dispatcher.

    mzsh topo set topo://services:standard/val:storage-dispatcher.storage-dispatcher1.\
config.url "<jdbc connection string>"

    Example - JDBC connection string

    mzsh topo set topo://services:standard/val:storage-dispatcher.storage-dispatcher1.\
config.url "jdbc:oracle:thin:@myhost:1521:orcl"


  4. Start .