Create a DB System from a Backup Using the Console

You can create a new virtual machine DB system from a backup using the console by using the following steps.

Before you begin, note the following:
  • When you create a DB system from a backup, the availability domain is the same as where the backup is hosted.
  • The shape you specify must be the same type as the database from which the backup was taken. For example, if you are using a backup of a single-node database, then the DB system you select as your target must also be a single-node DB system.
  • The Oracle database software version you specify must be an equal or greater version than that of the backed up database.
  • If you specify a virtual machine DB system shape, then the Available Storage Size will default to the data size of the backup, rounded up to the closest storage size option. However, you can specify a larger storage size.
  • If you are creating a new DB system from an Object Storage, you may choose any level 0 weekly backup, or a level 1 incremental backup created after the most recent level 0 backup. For more information on backups, see Back Up and Recovery in Base Database Service.
  • If the backup being used to create a DB system is in a security zone compartment, the DB system cannot be created in a compartment that is not in a security zone. For a full list of policies that affect Database service resources, see Security Zone Policies.

Procedure

  1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. Navigate to the backup or standalone backup you want to use to create the new DB system:

    Tip:

    If you are creating a database from an automatic backup, you may choose any level 0 weekly backup, or a level 1 incremental backup created after the most recent level 0 backup.
    • To select a daily automatic backup or on-demand full backup as the source
      1. Find the DB system where the database is located, and click the system name to display details about it.
      2. From the Databases list, click the source database name.
      3. Find your desired backup in the Backups list. If you don't see the backups list on the database details page, click Backups in the Resources menu.
      4. Click the Actions menu for the backup, and then click Create Database.
      5. In the Create Database from Backup dialog, select Create a new DB system.
      6. Click Create.
    • To select the last archived redo log automatic backup as the source
      1. Find the DB system where the database is located, and click the system name to display details about it.
      2. Find the database associated with the backup you wish to use, and click its name to display details about it.
      3. On the database details page, click Create Database from Backup.
      4. In the Create Database from Backup dialog, select the following:
        • Create database from last backup
        • Create a new DB system
      5. Click Create.
    • To specify a timestamp for a point-in-time copy of the source
      1. Find the DB system where the database is located, and click the system name to display details about it.
      2. Find the database associated with the backup you wish to use, and click its name to display details about it.
      3. On the database details page, click Create Database from Backup.
      4. In the Create Database from Backup dialog, do the following:
        1. Select Create database from specified timestamp.
        2. In the Restore timestamp field, enter a timestamp. The restore timestamp determines the most recent data that will be included in the restored version of the database.
        3. Select Create a new DB system.
        4. Click Create.
    • To select a standalone backup as the source
      1. Click Standalone Backups under Oracle Base Database.
      2. In the list of standalone backups, find the backup you want to use to create the database.
      3. Click the Actions menu for the backup you are interested in, and then click Create database.
      4. In the Create Database from backup dialog, select Create a new DB system.
      5. Click Create.
  4. In the Create Database from Backup dialog, enter the following DB system information.
  5. Select a compartment: Select a compartment for your new DB system. By default, the DB system is created in your current compartment and you can use the network resources in that compartment.
  6. Name your DB system: A non-unique, display name for the DB system. An Oracle Cloud Identifier (OCID) uniquely identifies the DB system. Avoid entering confidential information.
  7. Select a shape type: The shape type you select sets the default shape and filters the shape options in the next field. Select Virtual Machine. Note: Creating new bare metal DB system is not supported.
  8. Configure shape: The shape determines the type of DB system created and the resources allocated to the system. By default, AMD VM.Standard.E4.Flex shape with 4 OCPUs is selected.
  9. To specify a shape other than the default, click Change shape, and select an available shape from the list.

    Note:

    For a complete list of virtual machine shapes, see Available Shapes and How It Determines the Resources Allocated topic in the About Virtual Machine DB Systems article.
  10. Shape series: Select AMD or Intel processor in the processor group.
    • AMD: Shapes that use current generation AMD processors. The AMD shapes are flexible.
    • Intel: Standard and optimized shapes that use current-generation Intel processors. Both fixed and flexible Intel shapes are available.

    Note:

    If you select an AMD or Intel X9 flexible shape, the memory, network bandwidth, and the maximum theoretical IOPS scale proportionally.
  11. Configure OCPU: Choose the number of OCPUs you want to allocate to this instance. For AMD and Intel X9 flexible shapes, you can choose the number of OCPUs by using the slider in the Number of OCPUs per node field. You can select from a minimum of 1 OCPU to a maximum of 64 OCPUs for AMD shape and a minimum of 1 OCPU to a maximum of 32 OCPUs for Intel X9 shape. The following resources scale proportionately to the number of OCPUs you selected.
    • Memory (GB): The amount of memory you want to allocate to this instance.
      For AMD and Intel X9 shapes, the memory will scale proportionally based on the number of OCPUs selected. For each OCPU, 16 GB of memory is allocated.

      • For AMD shape, a minimum of 16 GB and a maximum of 1024 GB of memory is allocated.

      • For Intel X9 shape, a minimum of 16 GB and a maximum of 512 GB of memory is allocated.
    • Network bandwidth (Gbps): The amount of network bandwidth you want to allocate to this instance.
      For AMD and Intel X9 shapes, the bandwidth will scale proportionally based on the number of OCPUs selected. For each OCPU, 1 Gbps of network bandwidth is allocated.
      • For AMD shape, a minimum of 1 Gbps and a maximum of 40 Gbps of network bandwidth is allocated.
      • For Intel X9 shape, a minimum of 1 Gbps and a maximum of 32 Gbps of network bandwidth is allocated.
    • Theoretical max IOPS: The amount of input/output per second (IOPS) you want to allocate to this instance. Theoretical max IOPS is also dependent on the storage you choose.
      For AMD and Intel X9 shapes, the theoretical max IOPS will scale proportionally based on the number of OCPUs selected. For each OCPU, 16K theoretical max IOPS is allocated.
      • For AMD shape, a minimum of 16K and a maximum of 640K theoretical max IOPS is allocated.
      • For Intel X9 shape, a minimum of 16K to a maximum of 512K theoretical max IOPS is allocated.
  12. Click Select a shape.
  13. Configure storage: To specify storage other than the default, click Change storage and select an available storage from the list.
  14. Choose storage management software: Select one of the following:
    • Oracle Grid Infrastructure to use Oracle Automatic Storage Management (recommended for production workloads)
    • Logical Volume Manager to quickly provision your DB system using Logical Volume Manager storage management software.

    Note:

    The Available storage (GB) value you specify during provisioning determines the maximum total storage available through scaling. The total storage available for each choice is detailed in the Storage Scaling Considerations for Virtual Machine Databases Using Fast Provisioning topic in the About Virtual Machine DB Systems article.
  15. In the Configure storage performance section, in the Storage volume performance, select one of the following:
    • Balanced for most workloads that require a good balance between performance and cost savings.
    • Higher performance for large databases and workloads with high I/O requirement. It is the default performance level.

    In the Available data storage (GB), select the amount of BlockStorage in GB to allocate to the virtual machine DB system. Availablestorage can be scaled up or down as needed after provisioning your DBsystem.

    The read-only Recovery area storage (GB) field displays the amount of storage available for recovery log data (RECO storage). The recovery area storage is determined based on the storage selected. However, you can change the recovery area storage independently after provisioning. For more information on changing the recovery area storage, see Scale the DB System article.

    The read-only Expected theoretical max IOPS for data storage displays the maximum theoretical IOPS that is achievable for storage you have selected.

  16. Click Save changes.
  17. Provide the following details in the Configure the DB system section.
  18. Total node count: The number of nodes in the DB system, which depends on the shape you select. For virtual machine DB systems, you can specify either one or two nodes, except for VM.Standard2.1 and VM.Standard1.1, which are single-node DB systems.
  19. Oracle Database software edition: The database edition supported by the DB system. The database edition cannot be changed and applies to all the databases in this DB system. Virtual machine DB systems support only one database.
  20. Total storage (GB): Read-only field. It displays the total amount of storage that will be used by the DB system, including storage required by Oracle's DB system software. The size of the backup determines the minimum value for available storage.
  21. Cluster name: Displays only for two node DB systems to allow you to specify the cluster to store the node.
  22. Theoretical max IOPS: Displays the maximum IOPS that is supported for your instance. It is the minimum of the network IOPS and storage IPOS you selected in the Configure Shape and Configure storage sections.

    Note:

    Maximum theoretical IOPS is calculated based on database with 8K blocksize.
  23. IOPS limiting factor: Displays either Storage or Network based on which the theoretical max IOPS is determined. It helps identify if you need to increase storage or increase the network bandwidth (by increasing the number of OCPUs proportionally) for your shape if more IOPS are required.
  24. Add SSH key: Add the public key portion of each key pair you want to use for SSH access. Select on of the following options:
    • Generate SSH key pair: Use this option to create a new SSH key pair. Click both Save Private Key and Save Public Key when using this option. The private key is downloaded to your local machine, and should be stored in a safe location. You cannot download another copy of the private key generated during this operation after completing the operation.
    • Upload SSH key files: Select this option to browse or drag and drop your existing public key (.pub) files.
    • Paste SSH keys: Select this option to paste in individual public keys. To paste multiple keys, click + Another SSH Key, and supply a single key for each entry.
  25. Choose a license type: The type of license you want to use for the DB system. Your choice affects metering for billing.
    • License included means the cost of this Oracle Cloud Infrastructure Database service resource will include both the Oracle Database software licenses and the service.
    • Bring Your Own License (BYOL) means you will use your organization's Oracle Database software licenses for this Oracle Cloud Infrastructure Database service resource. For more information, see Bring Your Own License.
  26. Provide the following details in the Specify the network information section.
  27. Virtual cloud network: The VCN in which to create the DB system. Click Change compartment to select a VCN in a different compartment.

  28. Client subnet The subnet to which the DB system attaches. For 1- and 2-node RAC DB systems: Do not use a subnet that overlaps with 192.168.16.16/28, which is used by the Oracle Clusterware private interconnect on the database instance. Specifying an overlapping subnet causes the private interconnect to malfunction.

    Click Change compartment to select a subnet in a different compartment.

  29. Network security groups: Optionally, you can specify one or more network security groups (NSGs) for your DB system. NSGs function as virtual firewalls, allowing you to apply a set of ingress and egress security rules to your DB system. A maximum of five NSGs can be specified.

    For more information, see Access and Security and Security Rules for the DB System.

    Note:

    If you choose a subnet with a security list, the security rules for the DB system will be a union of the rules in the security list and the NSGs.
    To use network security groups:
    1. Check the Use network security groups to control traffic check box. Note that you must have a virtual cloud network selected to be able to assign NSGs to your DB system.
    2. Specify the NSG to use with the DB system. You might need to use more than one NSG. If you're not sure, contact your network administrator.
    3. To use additional NSGs, click + Another network security group.
  30. Hostname prefix: Your choice of host name prefix for the DB system. The host name must begin with an alphabetic character, and can contain only alphanumeric characters and hyphens (-). The maximum number of characters allowed is 16.

    Note:

    The host name must be unique within the subnet. If it is not unique, the DB system will fail to provision.
  31. Host domain name: The domain name for the DB system. If the selected subnet uses the Oracle-provided Internet and VCN Resolver for DNS name resolution, then this field displays the domain name for the subnet and it can't be changed. Otherwise, you can provide your choice of a domain name. Hyphens (-) are not permitted.
  32. Host and domain URL: Combines the host and domain names to display the fully qualified domain name (FQDN) for the database. The maximum length is 64 characters.
  33. Private IP address: Optionally, for non-RAC DB systems, you can define the IP address of the new DB system. This is useful in development contexts where you create and delete a DB system over and over, and you need each new iteration of the DB system to use the same IP address. If you specify an IP address that is currently in use within the subnet, the provisioning operation will fail with an error message regarding the invalid IP address.

  34. Diagnostic collection: The diagnostics collection and notifications feature enables Oracle Cloud Operations and you to identify, investigate, track, and resolve guest VM issues quickly and effectively. Subscribe to events to get notified about resource state changes. You can enable or disable this feature at anytime.

    By default the options are selected for enabling. However, you can choose to un-select the diagnostic collection check boxes if you do not require the diagnostic feature.
    • Enable diagnostic events: Enables and allows Oracle to collect and send fault notifications about critical, warning, and information events for you.
    • Enable incident logs and trace collection: Enables and allows Oracle to receive event notifications and collect incident logs and traces for fault diagnosis and issue resolution.

    Note:

    • The Enable health monitoring diagnostics collection for Oracle Cloud operations viewing is not available for the Oracle Base Database service.
    • You are opting-in with the understanding that the list of events and log files can change in the future. You can opt-out of this feature at any time.
  35. Click Show advanced options to specify advanced options for the DB system and provide the following details.
  36. Fault domain: The fault domain(s) in which the DB system resides. You can choose which fault domain to use for your DB system. For two-node Oracle RAC DB systems, you can specify which two fault domains to use. Oracle recommends that you place each node of a two-node Oracle RAC DB system in a different fault domain. For more information on fault domains, see About Regions and Availability Domains.
  37. Time zone: The default time zone for the DB system is UTC, but you can specify a different time zone. The time zone options are those supported in both the Java.util.TimeZone class and the Oracle Linux operating system. For more information, see DB System Time Zone. The following options are available:
    • UTC: configures your DB system to use coordinated universal time.
    • Browser-detected: The console displays the time zone detected by your browser for this option.
    • Select another time zone: To manually specify a time zone, first make a choice using the Region or country selector to select a geographic region, then use the Time zone selector to select your desired time zone.

    Tip:

    If you want to set a time zone other than UTC or the browser-detected time zone, and if you do not see the time zone you want, try selecting "Miscellaneous" in the Region or country list.
  38. Tags: If you have permissions to create a resource, then you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. If you are not sure whether to apply tags, skip this option (you can apply tags later) or ask your administrator. For more information about tagging, see Resource Tags.
  39. Click Next to advance to the Database information screen and provide the following information for the initial database.
  40. Database name: The name for the database, also known as the DB_NAME. The database name must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.
  41. Database unique name suffix: Optional. The second portion of the database unique name. The complete database unique name is created by appending the database unique name suffix to the database name you specify.
  42. Database unique name: This read-only field displays the complete database unique name (DB_UNIQUE_NAME). The database unique name is a globally unique name for the database. Primary and standby databases in a Data Guard association can share the same database name, but must have different database unique names.

  43. Database image: Optional. You can specify what Oracle Database version is used for the database. You can mix database versions on the DB system, but not editions. By default, the same database software image as the source database is used (if still available).

    Click Change Database Image to choose a custom database software image that you or someone in your organization have created in your tenancy.

    Select a Compartment and a Database version. Then select a database image from the table of available images for the Oracle Database version you selected.

    After choosing a software image, click Select to return to the Database information Screen.

  44. In the Create administrator credentials section, a database administrator SYS user will be created with the password you supply.
  45. Username: SYS (This is a read-only field).
  46. Password: Supply the password for this user. The password must meet the following criteria:
    • A strong password for SYS, SYSTEM, TDE wallet, and PDB Admin.
    • The password must be 9 to 30 characters and contain at least two uppercase, two lowercase, two numeric, and two special characters.
    • The special characters must be _, #, or -.
    • The password must not contain the username (SYS, SYSTEM, and so on) or the word "oracle" either in forward or reversed order and regardless of casing.
  47. Confirm password: Re-enter the SYS password you specified.
  48. Enter the source database's TDE wallet or RMAN password:(Applies only to databases using Oracle-managed encryption keys). Enter either the TDE wallet password or the RMAN encryption password for the backup, whichever is applicable. The TDE wallet password is the SYS password provided when the database was created by using the Oracle Cloud Infrastructure Console, API, or CLI. The RMAN encryption password is typically required instead if the password was subsequently changed manually.
  49. Click Create DB system. The DB system appears in the list with a status of Provisioning. The DB system's icon changes from yellow to green (or red to indicate errors).

    After the DB system's icon turns green, with a status of Available, you can click the highlighted DB system name to display details about the DB system. Note the IP addresses. You'll need the private or public IP address, depending on network configuration, to connect to the DB system.

Related Topics