Refreshing an existing development Autonomous Database (ADB) with data from a production ADB without creating a new database can help ensure your development environment has the latest data. This process involves using Oracle Cloud's tools to clone and replace the data in your development database with data from your production database. Below are the detailed steps:
#### Prerequisites
- Oracle Cloud account with necessary permissions.
- Autonomous Database instances for both production and development.
- Oracle SQL Developer or another SQL client tool.
### Step 1: Login to Oracle Cloud Console
1. **Open your web browser** and navigate to the [Oracle Cloud Console](https://cloud.oracle.com/).
2. **Login** with your Oracle Cloud credentials.
### Step 2: Navigate to the Autonomous Database Section
1. In the Oracle Cloud Console, go to the **hamburger menu** in the top-left corner.
2. Select **Autonomous Database** under the **Database** section.
### Step 3: Identify Your Production and Development Databases
1. In the Autonomous Database section, identify your **production** and **development** databases.
### Step 4: Create a Backup of the Production Database
1. Click on the **production database** to open its details.
2. Go to the **Backup** tab and click **Create Backup**.
3. Name your backup and click **Create Backup**.
### Step 5: Restore the Production Backup to the Development Database
1. Go back to the **Autonomous Database** section and select your **development database**.
2. Click on **More Actions** and select **Restore**.
### Step 6: Configure Restore Options
1. Choose **Restore to Existing Database**.
2. Select the backup you created from the production database.
### Step 7: Confirm and Start the Restore Process
1. Review the restore settings to ensure that the backup from the production database is selected.
2. Click **Restore Autonomous Database** to start the process.
3. The restore process will overwrite the data in your development database with the data from the production backup. Monitor the progress in the Autonomous Database section.
### Step 8: Verify the Data in the Development Database
1. Once the restore is complete, use SQL Developer or another SQL client to connect to the development database.
2. Run queries to verify that the data has been correctly restored and matches your production environment.
### Conclusion
By following these steps, you can refresh your development Autonomous Database with data from your production database on Oracle Cloud without creating a new database. This ensures that your development environment is always up-to-date with the latest data, facilitating accurate testing and development.
Feel free to adapt these steps to fit your specific requirements and organizational policies. If you need further customization or assistance, Oracle Cloud support is a great resource.
Comentarios