Skip navigation

By Joel Peréz ACED.gifSkant Gupta

 

Hi Readers

 

Due to the success of this article, it was moved to our company blog

Click here to read, Thank you very much:

Oracle 18c: RAC New Features.. What’s NEWS.. – Enmotech Blog

 

Happy Reading!

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

By Joel Peréz ACED.gifSkant Gupta

 

Hi Readers

 

Due to the success of this article, it was moved to our company blog

Click here to read, Thank you very much:

Oracle 18c: RMAN New Features.. What’s NEWS.. – Enmotech Blog

 

Happy Reading!

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

By Joel Peréz ACED.gifSkant Gupta

This article is brought by en.enmotech.com

new0345.jpg

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Before starting, if you want to read about how to build an Oracle Dataguard Configuration in Cloud, you can read here:

#1 Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS )

#2 Oracle Cloud (DBaaS): Switchover, Failover & Reinstate Operations on Oracle Data Guard using DBCS Console

#3 Oracle Cloud (DBaaS): Reinstating a Failed Primary Database using dbaascli utility ( Oracle Data Guard on Cloud )

#4 Oracle Cloud (DBaaS): Using dbaascli Utility for Switchover & Failover Operations on Oracle Data Guard

 

Now, Let's start to read..

 

Oracle Data Guard is an Oracle solution that seems will improve in a endless way. Every Oracle Release we have new features that perhaps we never expected to have.

Oracle 18c is not the exception, we have amazing new features, So.. Let's see..

 

New Broker VALIDATE commands

Personally, at the time to check or correct Oracle Data Guard configurations, one of the most common problems is the network configuration. Sometimes we are building RAC-RAC configurations with many servers.. many IPs.. etc.. and it's natural we can miss a name.. and IP.. etc.. at the end we can have some problems when this configuration is working and we have to start the tedious job to check every single detail.. ( Network Configuration.. Parameters.. etc.. ) to find where it's the problem.. With these 3 following commands we will be able to save a lot of time when we face that kind of difficulties..

 

VALIDATE DATABASE SPFILE

  • Validate parameters settings between the Primary and a Standby database.

VALIDATE NETWORK CONFIGURATION

  • Validate the network setup between all databases in the configuration

VALIDATE STATIC CONNECT IDENTIFIER

  • Verifies the static connect identifier setup in Single Instance databases the do not have Oracle Restart.

 

Multi-Instance Redo Apply

- Multi-Instance Redo Apply allows all standby nodes to participate in recovery

- In-memory DB (IMC) on Active Data Guard allows:

  • Creation of IMC tables and columns for analytics on Active Data Guard
  • Population with different data than production database
  • Offloading even more to your standby!

- IMC now works with Multi-Instance Redo Apply!

- Multi-Instance Redo apply also works with BCT

* Available only on Exadata and Oracle Cloud Offerings

 

18c: RMAN and Data Guard Enhancements

Active Data Guard Sync

 

  • New RECOVER STANDBY DATABASE FROM SERVICE
  • One command to refresh the standby database
  • Refreshes controlfile, datafile, restores newly added datafiles
  • Start RMAN and connect as target to the physical standby database.
  • Roll forward the physical standby database using the RECOVER STANDBY DATABASE command with the FROM SERVICE clause

 

RECOVER STANDBY DATABASE FROM SERVICE primary_db;

 

Creating GTTs on Active Data Guard

- Creating GTTs today will fail when executed on Active Data Guard

- In Oracle Database 18c CREATE GLOBAL TEMPORARY TABLE on an Active Data Guard standby will:

  • Create the GTT on the Primary
  • Wait for the GTT to be replicated and applied to the Active Data Guard standby
  • Return control to the user

 

Transient tables useful for reporting applications

 

Global temporary tables

Persistent, shared (global) table definition

Temporary, private (session-based) data content

  • Data physically exists for a transaction or session
  • Session-private statistics

Private temporary tables (18c)Temporary, private (session-based) table definition

  • Private table name and shape

Temporary, private (session-based) data content

  • Session or transaction duration

 

Executing DML on Active Data Guard

- DML Re-direction automatically performed from Active Data Guard standby to the Primary without compromising ACID

  • Standby ADG session waits for updates to show up on ADG via redo apply
  • DML data re-directed by an ADG session is only visible to that session before commit
  • DML data re-directed is visible to all sessions after ADG session commits
  • Enabled by setting parameter _enable_proxy_adg_redirect=TRUE and appropriate connectivity parameters
  • Respects ACID properties of a database for ADG session
  • Targeted for “Read Mostly Occasional Updates” applications

 

Keep Buffer Cache at Role Change

How often we did not dream for having a switchover without losing some transactions because of that..

Well, part of that dream "come true"..

- The database buffer cache state will be maintained on an ADG standby during a role change

ima2034.jpg

- Automatic, nothing to set up.

  • Services need to be configured correctly

 

Control login attempts

- The ADG_ACCOUNT_INFO_TRACKING parameter extends the control of user account security information and reaction.

  • ‘LOCAL’ (default value) continues to enforce the existing behavior
    • Maintains local copy of users account information in the Standby's in-memory view.
      • Login failures are only tracked locally on a per database basis and login denied when the failure maximum is reached.

 

- ‘GLOBAL’ triggers the new secure behavior

    • Maintains a single global copy of users account info across all Data Guard databases
      • Login failures across all databases in the Data Guard configuration count towards the maximum count and logins anywhere will be denied when the count is reached.

 

Data Guard and No Force Logging

How often you have been in the situation to repair/reinstate an Standby Database because a load was done in "No Logging mode".

It was really a hard situation for many companies to know that some specific loads could be done very efficient and fast in "No Logging mode" but sometimes there was not another option if we wanted to preserve the health state of our standby databases. Now, we have a new feature to make more versatile some specific loads in "No Logging mode"

 

 

  • Extended to provide better support in an Active Data Guard environment without significantly increasing the amount of redo generated.
  • Two new modes are added as alternatives to the existing nologging mode
    • Standby Nologging for Load Performance
      • Ensures that standbys will receive the nonlogged data changes with the minimum impact to the speed of loading at the primary
        • The standby can transiently have nonlogged blocks. These nonlogged blocks will be automatically resolved by managed standby recovery.
    • Standby Nologging for Data availability
      • Ensures all standbys have the data when the primary load commits but at the cost of throttling the speed of loading data at the primary
      • The standbys will never have any nonlogged blocks.

 

In Oracle Release 12.1 & 12.2 there a lot of new features that perhaps you have not experimented up to now. Here we have a list of all them so that you can differentiate to what release belongs the new features you will use.

 

RMAN

Oracle 18c: RMAN New Features.. What’s NEWS..

 

Review - Data Guard 12.1 New Features Summary

Data Guard

  • SYSDG Role for Data Guard specific operations
  • Multitenant Database Standbys
  • Default Real Time Apply
  • Transparent Online Data file movement
  • Single SQL*Plus Switchover command
  • No Primary instance shutdown for switchover
  • FastSync (SYNC NOAFFIRM)
  • Enhanced Extended Datatype Support for upgrades
  • Logical Standby support for additional data types
    • XMLType data for all storage models, Oracle Spatial, Oracle Multimedia, Oracle Text, Objects and Collections (including VARRAYs and nested collections), Database File System (DBFS), XDB, Oracle SecureFiles (deduplication), and User-defined types.
  • DBMS_SCHEDULER support for Rolling Upgrades
  • Broker VALIDATE DATABASE capability
  • Enhanced Broker configuring with RedoRoutes
  • Broker Resumable switchover
  • New Broker Observer properties and capabilities
  • Broker support of Cascading Redo destinations

Active Data Guard

  • Real Time Cascading Redo destinations
  • WAN Distance Zero Data Loss with Far Sync
  • Global Temporary Table DML on a standby
  • Sequences (global and session) on a standby
  • DBMS_ROLLING automated rolling upgrades
  • Support for Oracle Application Continuity
  • Support for Oracle Global Data Services

 

Review - Data Guard 12.2 New Features Summary

Data Guard

  • Use DBCA and EMCLI to create Standbys
  • Use RMAN and Enterprise Manager to create Far Sync Instances in addition to Standbys
  • Rest Interface to the Data Guard Broker
  • Chef tools to create and manage Data Guard standbys
  • Scripting with the Broker DGMGRL  command line interface
  • Easily creating Subset Standby databases in Multitenant
  • Migrate and Failover PDBs with the Broker
  • Automatic Password File management
  • Easy repair of No Logging operations
  • Data File Block Comparison between Primary and Standby
  • Multiple FSFO Targets  and Observers
  • FSFO in Maximum Protection mode
  • Zero Data Loss Failovers in any mode with Storage Failures
  • Enhanced control of Alternate destinations
  • Convert to TDE easily with little or no downtime

Active Data Guard

  • Using all your Standby Instances to apply redo
  • Data Guard Broker Support and involvement in DBMS_ROLLING controlled rolling upgrades
  • Use the In Memory Column Store on your Standby
  • Use AWR and SQL Tuning Advisor to diagnose and tune Redo Apply and Query issues on your Active Data Guard Standby
  • Move users transparently during role change with Session Draining on the Primary and Preserving existing connections at the Active Data Guard Standby
  • More protection with Auto Block repair enhancements

 

this is the end of this article, we hope it can be useful.. Stay tune for more Oracle Database Cloud articles.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

By Joel Peréz ACED.gifSkant Gupta

 

This article is brought by en.enmotech.com

Subscribe to our Oracle Cloud Blog: blog.enmotech.com

Follow us in Enmotech LinkedIn Page: https://www.linkedin.com/company/1856106/

 

Hi Readers

 

Due to the success of this article, it was moved to our company blog

Click here to read, Thank you very much:

#14 Oracle 18c: Oracle 18c.. New Features.. What’s NEWS.. – Enmotech Blog

 

Happy Reading!

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

By Joel Peréz ACED.gifSkant Gupta

 

This article is brought by en.enmotech.com

Subscribe to our Oracle Cloud Blog: blog.enmotech.com

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

In this article we will show you how to access oracle cloud instance in GUI mode.

 

Create the new Cloud Database Service

a) Login to your Oracle cloud services account, go to the "Oracle Database Cloud Service" page and create a new service.

  • For Service Name, select PREMISE.
  • From the Service Level list, select Oracle Database Cloud Service.
  • From the Metering Frequency list, select whatever frequency is appropriate for your environment.
  • From the Software Release list, select Oracle Database 11g Release2.
  • From the Software Edition list, select Enterprise Edition.
  • From the Database Type list, select Single Instance.

 

Then click Next to continue.

1.JPG

Figure1. Creating a new service (Cloud-Mig12c)

 

b) In the Service Details screen, do the following:

  • For DB Name (SID), enter ORCL.
  • Set an administrative password of your choice and confirm the password (this will be your sys password).
  • For Usable Database Storage (GB), enter 25.
  • From the Compute Shape list, select OC3 -1 OCPU, 7.5GB RAM (this is the bare minimum required).
  • For SSH Public Key, enter rsa-key-20170111.pub.

 

Then click Next to continue.

2.JPG

Figure 2. Specifying the service details

 

c) Finally, review the configuration and click Create to create your cloud database.

3.JPG

Figure 3. Creating the cloud database instance

 

c) After a few minutes, the cloud database instance has been created successfully.

4.JPG

Figure 4. The cloud database has been created

 

d) Click the service name (PREMISE) to open the main page of the database.

5.JPG

Figure 5. Main page of the cloud database

 

Connect the Cloud Database

1. Open the instance of the PuTTY executable and connect to the machine using SSH public key.

6.jpg

Figure 6. Connecting to machine using PuTTY

 

Login to Putty with OPC user

 

1. Login with OPC user and sudo to root

Using username "opc".

Authenticating with public key "rsa-key-20170425"

Passphrase for key "rsa-key-20170425":

[opc@PREMISE ~]$ sudo su

[root@PREMISE opc]#

 

2. Installing RPM with YUM

  • yum groupinstall "X Windows System"
  • yum groupinstall "X Window System" -y
  • yum groupinstall "Desktop" -y
  • yum groupinstall "Desktop Platform" -y
  • yum groupinstall "General Purpose Desktop" -y
  • yum groupinstall "Graphical Administrator Tools" -y
  • yum groupinstall "Graphical Adminstration Tools" -y
  • yum groupinstall "Graphical Administration Tools" -y
  • yum install tigervnc-server
  • yum install tigervnc-server -y
  • yum install gnome-panel -y
  • yum install firefox–y

 

2. Installing RPM with YUM

[root@PREMISE opc]# yum groupinstall "X Windows System"

[root@PREMISE opc]# yum groupinstall "X Window System" -y

[root@PREMISE opc]# yum groupinstall "Desktop" -y

[root@PREMISE opc]# yum groupinstall "Desktop Platform" -y

[root@PREMISE opc]# yum groupinstall "General Purpose Desktop" -y

[root@PREMISE opc]# yum groupinstall "Graphical Administrator Tools" -y

[root@PREMISE opc]# yum groupinstall "Graphical Adminstration Tools" -y

[root@PREMISE opc]# yum groupinstall "Graphical Administration Tools" -y

[root@PREMISE opc]# yum install tigervnc-server

[root@PREMISE opc]# yum install tigervnc-server -y

[root@PREMISE opc]# yum install gnome-panel -y

[root@PREMISE opc]# yum install firefox -y

[root@PREMISE opc]#

 

3. Creating the password for VNCServer.

[root@PREMISE opc]# vncserver :1 -depth 16 -alwaysshared -geometry 1600x720 -s off

You will require a password to access your desktops.

Password:

Verify:

xauth:  file /root/.Xauthority does not exist

New 'PREMISE:1 (root)' desktop is PREMISE:1

Creating default startup script /root/.vnc/xstartup

Starting applications specified in /root/.vnc/xstartup

Log file is /root/.vnc/PREMISE:1.log

[root@PREMISE opc]#

 

Creating Tunnels with PuTTY

1. Open the PuTTY executable and click on Tunnels.

For Source port,enter6905.

For Destination,enter141.144.32.52:5901.

 

Then Click on Add.

7.JPG

Figure 7. Connecting to PuTTY

 

2. Click on Open

8.JPG

Figure 8. Add tunnels

 

Connecting with VncServer

Create New Connection in VNCServer.

9.jpg

Figure 9. New connection in Vncserver

 

2. Create New Connection in VNCServer.

For VNC Serverenterlocalhost:6905.

For Encryption, select Prefer off.

10.jpg

Figure 10. entering details

 

3. Connect in VNCServer.

11.jpg

Figure 11. Connect to vnc server

 

4. Enter the Password and then click on OK.

12.jpg

Figure 12.password window

 

5. Now we are able to GUI Mode.

13.JPG

Figure 13. GUI Mode of VNC

 

Conclusion

So now you know that it is very easy to access GUI Mode in Cloud Instance.

Well.. Until here, this article. We hope it can be useful for making grow your knowledge about Oracle Database Cloud.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

By Joel Peréz ACED.gifSkant Gupta

 

This article is brought by en.enmotech.com

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

This method can be used only if the on-premises platform is little endian, and the database character sets of your on-premises database and Oracle Database Cloud Service database are compatible.

 

To migrate an Oracle Database 12c PDB to a PDB in an Oracle Database 12c database on an Oracle Database Cloud Service deployment using the RMAN cross-platform transportable PDB method, you perform these tasks:

 

1.- On the on-premises database host, invoke SQL*Plus and close the on-premises PDB.

2.- On the on-premises database host, execute the ALTER PLUGGABLE DATABASE UNPLUG command to generate an XML file containing the list of datafiles that will be plugged in on the cloud database.

3.- On the on-premises database host, invoke RMAN and connect to the root. Execute the BACKUP FOR TRANSPORT PLUGGABLE DATABASE command.

4.- Creating the Database Cloud Service database

5.- Use a secure copy utility to transfer the XML file and the backup set to the Database Cloud Service compute node.

6.- On the Database Cloud Service compute node, invoke RMAN and connect to the root. Execute the RESTORE ALL FOREIGN DATAFILES command.

7.- the Database Cloud Service compute node, invoke SQL*Plus and connect to the root. Execute the CREATE PLUGGABLE DATABASE command.

8.- the Database Cloud Service compute node, execute the ALTER PLUGGABLE DATABASE OPEN command.

 

On-premises database to Cloud Using RMAN Cross-Platform Transportable PDB: Example

This example is to migrate an On-premises database to Cloud Using RMAN Cross-Platform Transportable PDB

In this example, the on-premises database is on a Linux host.

 

1.- On the on-premises database host, invoke SQL*Plus and close the on-premises PDB.

 

a) On the on-premises database host, invoke SQL*Plus and log in to the on-premises database as the SYS user.

[oracle@cloud ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jun 4 11:47:11 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

 

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

 

SQL>

 

b) Close the on-premises PREM_PDB PDB.

SQL> ALTER PLUGGABLE DATABASE pdb_prem CLOSE;

Pluggable database altered.

SQL>

 

2. On the on-premises database host, execute the ALTER PLUGGABLE DATABASE UNPLUG command to generate an XML file containing the list of datafiles that will be plugged in on the cloud database.

 

a) Create a directory for creating the xml and backup file.

[oracle@cloud ~]$ mkdir –p /u01/app/dpump/

[oracle@cloud ~]$

 

b) Unplug the PDB. The following command generates the XML file.

SQL> ALTER PLUGGABLE DATABASE pdb_prem UNPLUG INTO '/u01/app/dpump/PDB_PREM.xml';

Pluggable database altered.

 

SQL>

 

3.- On the on-premises database host, invoke RMAN and connect to the root. Execute the BACKUP FOR TRANSPORT PLUGGABLE DATABASE command.

 

a) On the on-premises database host, invoke RMAN and log in to the on-premises database as the SYS user.

[oracle@cloud admin]$ rman target /

 

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Jun 8 22:33:05 2017

 

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

 

connected to target database: CDBPREM (DBID=1893698667)

 

RMAN>

 

b) Take the backup

RMAN> BACKUP FOR TRANSPORT AS COMPRESSED BACKUPSET PLUGGABLE  DATABASE  'PDB_PREM'  FORMAT  '/u01/app/dpump/PDB_PREM.dfb';

Starting backup at 08-JUN-17

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=82 device type=DISK

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00011 name=/u01/app/oracle/oradata/CDBPREM/PDB_PREM/example01.dbf

input datafile file number=00009 name=/u01/app/oracle/oradata/CDBPREM/PDB_PREM/sysaux01.dbf

input datafile file number=00008 name=/u01/app/oracle/oradata/CDBPREM/PDB_PREM/system01.dbf

input datafile file number=00010 name=/u01/app/oracle/oradata/CDBPREM/PDB_PREM/SAMPLE_SCHEMA_users01.dbf

input datafile file number=00012 name=/u01/app/oracle/oradata/CDBPREM/fsindex01.dbf

input datafile file number=00013 name=/u01/app/oracle/oradata/CDBPREM/fsdata01.dbf

channel ORA_DISK_1: starting piece 1 at 08-JUN-17

channel ORA_DISK_1: finished piece 1 at 08-JUN-17

piece handle=/u01/app/dpump/PDB_PREM.dfb tag=TAG20170608T223310 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:35

Finished backup at 08-JUN-17

 

RMAN>

 

4.- Creating the new Cloud Database Service

a) Login to your Oracle cloud services account, go to the "Oracle Database Cloud Service" page and create a new service.

  • For Service Name, select Cloud-Mig12c.
  • From the Service Level list, select Oracle Database Cloud Service.
  • From the Metering Frequency list, select whatever frequency is appropriate for your environment.
  • From the Software Release list, select Oracle Database 12c Release1.
  • From the Software Edition list, select Enterprise Edition.
  • From the Database Type list, select Single Instance.

 

Then click Next to continue.

fig 01.JPG

Figure1. Creating a new service (Cloud-Mig12c)

 

b) In the Service Details screen, do the following:

  • For DB Name (SID), enter PRODDB.
  • Set an administrative password of your choice and confirm the password (this will be your sys password).
  • For Usable Database Storage (GB), enter 25.
  • From the Compute Shape list, select OC3 -1 OCPU, 7.5GB RAM (this is the bare minimum required).
  • For SSH Public Key, enter rsa-key-20170111.pub.

 

Then click Next to continue.

fig 02.JPG

Figure 2. Specifying the service details

 

c) Finally, review the configuration and click Create to create your cloud database.

fig 03.JPG

Figure 3. Creating the cloud database instance

 

After a few minutes, the cloud database instance has been created successfully.

fig 04.JPG

Figure 4. The cloud database has been created

 

d) Click the service name (Cloud-Mig12c) to open the main page of the database.

fig 05.JPG

Figure 5. Main page of the cloud database

 

e) Before trying to connect to the primary database instance on the cloud machine, you have to enable the dblistener access rule. Do the following:

a. Open the database service and select Access Rules from the menu.

fig 06.JPG

Figure 6. Selecting the Access Rules item

 

b. For the ora_p2_dblistener rule, select Enable from the Actions menu.

fig 07.JPG

Figure 7. Enabling the ora_p2_dblistener rule

 

Connect the Cloud Database

1. Open the instance of the PuTTY executable and connect to the machine using SSH public key.

fig 08.JPG

Figure 8. Connecting to machine using PuTTY

 

5.- Use a secure copy utility to transfer the XML file and the backup set to the Database Cloud Service compute node.

 

a) On the Database Cloud Service compute node, create a directory for the backup set and dump file.

[oracle@Cloud-Mig12c ~]$ mkdir –p /u01/app/on_premise/

[oracle@Cloud-Mig12c ~]$

 

b) Before using the scp command to copy files, make sure the SSH private key that provides access to the Database Cloud Service compute node is available on your on-premises host.

 

c) On the on-premises database host, use the SCP utility to transfer the backup set and the dump file to the Database Cloud Service compute node.

[oracle@cloud ~]$ scp -i rsa-key-20170111.ssh /u01/app/dpump/PDB_PREM.xml oracle@129.144.149.23:/u01/app/on_premise

Enter passphrase for key 'rsa-key-20170111.ssh':

PDB_PREM.xml                                                                                                                          100% 7681     7.5KB/s   00:00

[oracle@cloud ~]$ scp -i rsa-key-20170111.ssh /u01/app/dpump/PDB_PREM.dfb oracle@129.144.149.23:/u01/app/on_premise

Enter passphrase for key 'rsa-key-20170111.ssh':

PDB_PREM.dfb                                                                                                                          100%  190MB  55.8KB/s   58:06

[oracle@cloud ~]$

 

6.- On the Database Cloud Service compute node, invoke RMAN and connect to the root. Execute the RESTORE ALL FOREIGN DATAFILES command.

 

a) Invoke RMAN and log in to the PDB as a user that has been granted the SYSDBA or SYSBACKUP privilege.

[oracle@Cloud-Mig12c ~]$ rman target /

 

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Jun 8 18:08:20 2017

 

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

 

connected to target database: PRODDB (DBID=685826250)

 

RMAN>

 

b) Execute the RESTORE command.

RMAN> RESTORE ALL FOREIGN DATAFILES TO NEW FROM BACKUPSET  '/u01/app/on_premise/PDB_PREM.dfb';

Starting restore at 08-JUN-17

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=36 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring all foreign files in backup piece

channel ORA_DISK_1: reading from backup piece /u01/app/on_premise/PDB_PREM.dfb

channel ORA_DISK_1: restoring foreign file 11 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_example_dmm4nwql_.dbf

channel ORA_DISK_1: restoring foreign file 9 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_sysaux_dmm4nwt1_.dbf

channel ORA_DISK_1: restoring foreign file 8 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_system_dmm4nwx9_.dbf

channel ORA_DISK_1: restoring foreign file 10 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_users_dmm4nx06_.dbf

channel ORA_DISK_1: restoring foreign file 12 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_fsindex_dmm4nx1z_.dbf

channel ORA_DISK_1: restoring foreign file 13 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_fsdata_dmm4nx3c_.dbf

channel ORA_DISK_1: foreign piece handle=/u01/app/on_premise/PDB_PREM.dfb

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:01:46

Finished restore at 08-JUN-17

 

c) Exit from RMAN.

 

7.- the Database Cloud Service compute node, invoke SQL*Plus and connect to the root. Execute the CREATE PLUGGABLE DATABASE command.

 

a) On the on-premises database host, invoke SQL*Plus and log in to the on-premises database as the SYS user.

[oracle@cloud ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jun 4 11:47:11 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

 

SQL>

 

b) Execute the CREATE PLUGGABLE DATABASE command.

SQL> CREATE PLUGGABLE DATABASE PDB_PREM as clone USING '/u01/app/on_premise/PDB_PREM.xml'

source_file_name_convert = (

'/u01/app/oracle/oradata/CDBPREM/PDB_PREM/system01.dbf','/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_system_dmm4nwx9_.dbf',

'/u01/app/oracle/oradata/CDBPREM/PDB_PREM/sysaux01.dbf','/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_sysaux_dmm4nwt1_.dbf',

'/u01/app/oracle/oradata/CDBPREM/PDB_PREM/SAMPLE_SCHEMA_users01.dbf','/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_users_dmm4nx06_.dbf',

'/u01/app/oracle/oradata/CDBPREM/PDB_PREM/example01.dbf','/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_example_dmm4nwql_.dbf',

'/u01/app/oracle/oradata/CDBPREM/fsindex01.dbf','/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_fsindex_dmm4nx1z_.dbf',

'/u01/app/oracle/oradata/CDBPREM/PDB_PREM/PDB_PREM_temp012017-05-21_01-01-24-PM.dbf','/u02/app/oracle/oradata/PRODDB/datafile/pdb4_temp01.dbf',

'/u01/app/oracle/oradata/CDBPREM/fsdata01.dbf','/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_fsdata_dmm4nx3c_.dbf')

file_name_convert=NONE NOCOPY TEMPFILE REUSE;

Pluggable database altered.

 

SQL>

 

8.- The Database Cloud Service compute node, execute the ALTER PLUGGABLE DATABASE OPEN command.

 

a) Set the PDB_PREM to READ WRITE

SQL> ALTER PLUGGABLE DATABASE pdb_prem OPEN;

Pluggable database altered.

SQL>

 

b) Exit from SQL*Plus.

 

Well.. Until here, this article. We hope it can be useful for making grow your knowledge about Oracle Database Cloud.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

By Joel Peréz ACED.gifSkant Gupta

 

Hi Readers

 

Due to the success of this article, it was moved to our company blog

Click here to read, Thank you very much:

#11 Oracle 18c: “Oracle 18c and its impact on DBAs” – Enmotech Blog

 

Happy Reading!

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

By Joel Peréz ACED.gifSkant Gupta

 

This article is brought by en.enmotech.com

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

In this article we will show you an Oracle Exadata Cloud Service Account with the ability to provision the Creating an Exadata Database Cloud Service Instance.

 

Creating an Exadata Database Service Instance

When you create an Oracle Database Exadata Cloud Service instance, you provision the Exadata Database Machine that hosts your Exadata Cloud Service database deployments. To create an Exadata Cloud Service instance, use the Create New Oracle Database Exadata Cloud Service Instance wizard as described in the following procedure.

 

To create an Exadata Cloud Service instance:

1. Open the My Services dashboard.

2. Click Create Instance and then select Exadata from the list of options.

The Create New Oracle Database Exadata Cloud Service Instance wizard starts and the Instance Details page is displayed.

3. On the Instance Details page, configure details for your Exadata Cloud Service instance. Then, click Next.

         a. In the Instance Details section, specify the following attributes associated with your Exadata Cloud Service instance.

      • Name — enter a name for your service instance. This name:
        • Must not exceed 25 characters.
        • Must start with a letter.
        • Must contain only lower case letters and numbers.
        • Must not contain spaces or any other special characters.
        • Must be unique within the identity domain.
      • Rack Size — select the rack configuration for your service instance:
        • Quarter Rack — configures an environment consisting of 2 compute nodes and 3 Exadata Storage Servers.
        • Quarter Rack X6 — configures an environment consisting of 2 compute nodes and 3 Exadata Storage Servers.
        • Half Rack — configures an environment consisting of 4 compute nodes and 6 Exadata Storage Servers.
        • Half Rack X6 — configures an environment consisting of 4 compute nodes and 6 Exadata Storage Servers.
        • Full Rack — configures an environment consisting of 8 compute nodes and 12 Exadata Storage Servers.
        • Full Rack X6 — configures an environment consisting of 8 compute nodes and 12 Exadata Storage Servers.

        b. In the Administrator Details section, provide information about the administrator of your Exadata Database Machine environment.

      • Email — enter an email address for the Exadata system administrator.
      • User Name — enter a user name for the Exadata system administrator. Alternatively, check the Use email as user name option to copy the Email entry into the User Name field.
      • First Name — enter the first name of the Exadata system administrator.
      • Last Name — enter the last name of the Exadata system administrator.

4. On the Confirmation page, review the configuration settings. If you are satisfied, click Create Service Instance.

 

Creating an Exadata Database Service Instance: Example

1. Open the My Services dashboard.

1.JPG

Fig 1: Services dashboard

 

2. Click Create Instance and then select Oracle Database Cloud – Exadata Service from the list of options.Then, click Next.

2.JPG

Fig 2: select Exadata Service

 

3. Select Oracle Database 12c Release1 from the list of options.Then, click Nextto continue.

3.JPG

Fig 3: select database version

 

4. In the Service Details screen, do the following:

  • For Service Name, enter urban-beans-db1.
  • From Exadata System list, select urbanbeans-exa-Quarter Rack (2 nodes).
  • For DB Name (SID), enter urbandb1.
  • For PDB Name, enter urbpdb1.
  • Set an administrative password of your choice and confirm the password (this will be your sys password).
  • From Backup Destination list, select Cloud Storage only.

 

Then click Next to continue.

4.JPG

Fig 4: Specifying the service details

 

5. Finally, review the configuration and click Create to create your cloud database.

5.JPG

Fig 5: Creating the Exadata cloud database instance

 

6. After a few minutes, the data guard in exadatacloud database instance has been created successfully.

6.JPG

Fig 6: The Exadata cloud database has been created

 

7. Click the service name (URBAN-BEAN-DB1) to open the main page of the database.

7.JPG

Fig 7: Main page of the exadata cloud database

 

Conclusion

So now you know that it is very easy to create an Exadata Database Service Instance.

We hope this article is useful and we invite you to continue reading our next publications focused on Oracle Cloud.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.com

By Joel Peréz ACED.gifSkant Gupta

 

This article is brought by en.enmotech.com

Subscribe to our Oracle Cloud Blog: blog.enmotech.com

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

By backing up your Oracle Database Cloud Service database deployments, you can protect the software, configuration and database against loss if a failure occurs. By restoring from a backup, you can restore the deployment's software, configuration, and database to their state at the time of the backup.

 

Database Cloud Service provides a backup feature that backs up:

  • The database
  • Database configuration files
  • Grid Infrastructure configuration
  • Important system and cloud tooling files

 

Storage Container Configuration

 

A container is a storage compartment that provides a way to organize the data stored in Oracle Storage Cloud Service.

Any user with the Service Administrator role can create containers. You should create at least one container for your account. Containers are similar to a directory structure but with a key distinction: unlike directories, containers cannot be nested. By default, all containers are of the standard storage class.

 

Creating a Container Using the Web Console

 

1. Sign in to the Oracle Storage Cloud Service console. Then Click on Open Service Console.

1.jpg

Figure 1:  Storage Cloud Service console

 

2. Click Create Container.

2.JPG

Figure 2: Create Container

 

3. Enter a Name for the container as Backup and Storage Class as Standard.

3.JPG

Figure 3: Create Container details

 

4. Click Create. The container is created and displayed in the console.

4.JPG

Figure 4: displayed container

 

5. Select the container in which you would like to backup the database.

5.JPG

Figure 5: select the container

 

6. Select Enable Upload and Download in the Container Information pane.

Click OK to enable Cross-Origin Resource Sharing (CORS).

6.JPG

Figure 6: Enable upload and download option.

 

Create the new Cloud Database Service using Storage Container

 

1. Login to your Oracle cloud services account, go to the "Oracle Database Cloud Service" page and create a new service.

 

  • For Service Name, select Backup-Storage.
  • From the Service Level list, select Oracle Database Cloud Service.
  • From the Metering Frequency list, select whatever frequency is appropriate for your environment.
  • From the Software Release list, select Oracle Database 12c Release1.
  • From the Software Edition list, select Enterprise Edition.
  • From the Database Type list, select Single Instance.

 

Then click Next to continue.

7.JPG

Figure7: Creating a new service (Backup-Storage)

 

2. In the Service Details screen, do the following:

  • For DB Name (SID), enter ORCL.
  • For PDB Name, enter PDB1.
  • Set an administrative password of your choice and confirm the password (this will be your sys password).
  • For Usable Database Storage (GB), enter 25.
  • From the Compute Shape list, select OC3 -1 OCPU, 7.5GB RAM (this is the bare minimum required).
  • For SSH Public Key, enter rsa-key-20170111.pub.
  • From the Backup Destination list, Select Cloud Storage Only.
  • For Cloud Storage Container, enter Storage-ustechnolo/Backup.
  • For Username, enter <registered mail>.
  • For Password, enter <your password>.

 

Then click Next to continue.

8.JPG

Figure 8: Specifying the service details

 

3. Finally, review the configuration and click Create to create your cloud database.

9.JPG

Figure 9: Creating the cloud database instance

 

After a few minutes, the cloud database instance has been created successfully.

10.JPG

Figure 10: The cloud database has been created

 

4. Click the service name (Backup-Storage) to open the main page of the database.

11.JPG

Figure 11: Main page of the cloud database

 

Create the Backup of Cloud Database

 

      1. On the main page and select the Administration Pane.

12.JPG

Figure 12: Administration section

 

2. Click on Backup Now button to create a backup of the database.

13.JPG

Figure 13: backup initiated

 

3. After a few minutes, Backup has completed.

14.JPG

Figure 14: available backup

 

4. Switch to the Storage Container, you will see bunch of files created for backup.

15.JPG

Figure 15: files at storage container

 

Deleting a Database Deployment and Backup sets from Storage Container

When you no longer require a database deployment on Oracle Database Cloud Service, you can delete it.

To delete a database deployment:

 

1. Open the Oracle Database Cloud Service console.

16.JPG

Figure 16: service console

 

2. Select Delete from the   service menu corresponding with the database deployment that you want to delete.

17.JPG

Figure 17: delete option from Menu

 

3. You are prompted to confirm the deletion. Use the confirmation dialog to confirm that you want to delete the database deployment. Optionally, you can also select the option to delete the backups associated with the database deployment.

19.JPG

Figure 18: selecting the delete backups

 

Note: The option to delete the backups associated with the database deployment only exists for deployments that are created using Database Cloud Service release 17.1.5 or later.

 

Once deleted, the entry is removed from the list of database deployments displayed on the Oracle Database Cloud Service console. Also Backup sets has deleted from Storage Container.

18.JPG

Figure 19: empty storage container

 

Conclusion

So, now you know that it is very easy to perform Migration Using Data Pump Conventional Export/Import on Oracle Cloud Creating and Deleting the backup sets of the Database on Oracle Cloud.

We hope this article is useful and we invite you to continue reading our next publications focused on Oracle Cloud.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.com