Versions Compared

Old Version 4

changes.mady.by.user naveen

Saved on

compared with

New Version Current

changes.mady.by.user naveen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When creating a new database, ensure that that subnet it is being launched in is a private subnet.

Perform following to create auto scaling configuration :

  1. Login to the OCI console at https://www.oracle.com/cloud/sign-in.html.

  2. Create on demand DB system backup

    1. In navigation, Click Oracle Database.

    2. Click Bare Metal, VM, and Exadata.

    3. Choose your Compartment.

    4. In the list of DB systems, click the name of the system that contains the database that you want to work with.

    5. In the list of DB systems, click the name of the system that contains the database to work with.

    6. On the DB system details page, find the database in list of databases and click the display name.

    7. Under Resources, click Backups.

    8. Click Create Backup.

  3. Create DB system from the backup created above

    1. In navigation, Click Oracle Database.

    2. Click Bare Metal, VM, and Exadata.

    3. Choose your Compartment.

    4. Click Standalone Backups under Bare Metal, VM, and Exadata.

    5. In the list of standalone backups, find the backup you want to use to create the database.

    6. Click the Actions menu for the backup you are interested in, and then click Create Database.

    7. In the Create Database from Backup dialog, select Create a new DB system.

    8. Click Create.

    9. In the Create Database from Backup dialog, Enter following information

      • compartment, Name for DB system, shape type, shape, Total Node Count, Database Software Edition, Storage management software, Available storage, SSH keys, License Type.

    10. Specify the network information enter following

      • Virtual Cloud Network, Client Subnet - select the private network, Network Security Groups, Hostname Prefix, Private IP address - Select the IP address which is unused in the private subnet.

    11. Configure Advance options Fault Domain, Time Zone, Tags.

    12. Click Next.

    13. On the Database Information page , enter following information

      • Database name, Database unique name suffix, Database unique name, Database image, Password for SYS and SYSTEM, Enter the source database's TDE wallet or RMAN password.

    14. Click Create DB System.

  4. Once the new DB system is up and running, Terminate the old DB system.

    1. In navigation, Click Oracle Database.

    2. Click Bare Metal, VM, and Exadata.

    3. Choose your Compartment.

    4. To terminate DB system, click  Actions menu and then click Terminate.

Important:

  •  The subnet for DB system cannot overlap with 192.168.16.16/28, which is used by the Oracle Clusterware Cluster ware private interconnect on the database instance.

Reference: