Joel Pérez
By( Oracle ACED )&(OCE)
In this article we will show you how to create an instance from existing backup of other domain. To do this, we have some prerequisites:
• There must be a backup on Storage Container from existing instance.
• We need Database ID of an existing instance.
• We need wallet key of an existing instance.
I already have one backup configured on the existing instance (highlighted below)
You would also need wallet encryption key from server.
Make sure you have FTP (filezilla) installed on your local machine as this would be required to zip the folder.
Note: $ORACLE_BASE/admin//tde_wallet is default location.
Oracle Database Cloud Service
Log in to the "" page to create a new service following the enlisted steps.
• Select a service name of your choice
Oracle Database Cloud Service
• Select “” as the subscription type
• Provide SSH Public Key
Oracle Database 11g Release 2
• Select “” as the Software Release
Enterprise Edition
• Select “” as Software Edition
• Select Billing Frequency of your choice
• Click on Next to proceed
Service Details Section
serviced Configuration
Under
• Select Compute Size (OC3 – 1 OCPU, 7.5 GB RAM min required configuration)
• Select a time zone
Database Configuration
Under
• Select Usable Database Storage (25 GB minimum)
• Provide Administration Password (this would be used as the sys password)
• Select a DB Name (SID)
1521
• Add “” as DB Listener Port
Create Instance from Existing Backup
Now, you need to select the “” as Yes.
Create Instance from Existing Backup
On selecting the “” to Yes, following options would open up
• Database ID
• Upload zipped TDE (the one which was zipped using FTP)
• Cloud Storage Container
• Cloud Storage Username
• Cloud Storage Password
Finally, check the configuration and click on "Create". This will to create our cloud database.
After a few minutes, clone cloud database will be created successfully.
Copybkp
We click on the service name () to open the main page of database.
Now, open two different instances of “Putty” executable.
Connect SSH to both the machines as shown below
pmon
Once the connection is made, check the “” on each server.
It is advised to create a dummy table for before taking the backup. This Dummy table would be used for the testing purpose.
After cloning, it must be exist in cloned database.
So now you know, it is very easy to create a Clone database in the cloud from a different storage location.
We hope this article has proved useful and we invite you to continue reading our next publications focused on Oracle Cloud.
About the authors
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, specialized 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 in 5 continents and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish & OTN Portuguese. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA(Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China and more. 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 and as one of the biggest professional achievement in his career he was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Chief Technologist in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China www.Enmotech.com