Configure and Practice Backup and Recovery in Cloud-Alibaba Cloud Developer Community

Author profile

Joel Perez: Oracle ACE director, Maximum Availability OCM,OTN expert, the world's first ACE winners, dedicated to designing and implementing solutions for database high Availability, disaster recovery, upgrade and migration, and data replication.

Kamran Aghayev : Oracle ACE director, OCM, OCCE, RAC implementation expert. Served as the director of the DBA team in AzerCell Telecom LLC. Published books "Expert secrets for using RMAN and Data Pump", "Oracle Certified Master 11g Exam Guide of

author

this article describes how to configure Oracle database backup on the cloud. To back up data, you must be able to use Oracle's storage cloud services ( Storage Cloud Service ), and set the replication policy.

1

use Oracle Storage Cloud services

as shown in the following figure, open the database public cloud service ( public cloud service ) page, drop-down to Oracle Storage Cloud service ( Storage Cloud Service ), click Set Replication Policy ".

Then select " Data Center " , start setting.

Open apsaradb for RDS and create a new service.

GUI the plug-in has been improved so that we can create a database on the cloud in only three steps.

1,   service name

2- ,   enter the software version

3,   submitted SSH public key

fill out after, click next.

To back up data on the cloud, you need to create a cloud storage container ( cloud storage container ). Switch Oracle storage Cloud service ( OracleStorage Cloud Service ), and then obtain REST , then you can create a cloud storage container ( cloud storage container ).

Then open the following link: https://storageconsole.em2.oraclecloud.com/, fill in REST to log on Oracle storage Cloud service ( Oracle Storage Cloud Service ).

Create a storage container ( storage container ).

On the create service page, select " Both Cloud Storage and Local Storage " as the backup path. Enter the container name and password, and then click next.

Preview the configuration and confirm the creation.

After the service is created, open the service and select administrator. " Backup Now " , of course you can also use RMAN set your own backup policy.

2-

back up and restore data on the cloud

selector " Backup Now” , and then you can view the backup details through the log file, as shown in the figure, the backup has been completed.

If you switch to the storage container ( storage container ) page, you will find that many files were created during the backup process.

Open RMAN implementation " LIST BACKUPSET SUMMARY " command to view the backup set.

Now we try to pass DBaaS wizard to restore the database to a specified time point.

Create a new table and insert some data. View the current SCN no. And then drop table .

Now, switch DBaaS backup page, click Recover and enter what you want to restore SCN no.

The recovery process is automatically executed in the background. You can view the details in the alert logs.

After the Restoration, log on to the database and query the created table again.

You can also use it bkup_api plug-ins that run the command line to back up and restore data. Now we try to delete all backups and re-perform the backup and recovery process by using commands.

Delete all RMAN backup.

Use bkup_api plug-in, by setting bkup_start parameter, from CLI back up data.

Check log files for details

after the backup is completed, make sure that the backup set is available, use dbaascli the plug-in can be restored.

Use Now dbaascli plug-in SCN no. SCN incomplete recovery.

Log on to the database again and query the table to see if the recovery is normal.

The backup set of the database is also stored in the flash recovery area of the host where the database is located.

If you want to modify the automatic backup plan root log on to the system and modify crontab plan. The following is the current backup.

You can also use it DBaaS backup button, command line, or RMAN run Oracle backup and Recovery of databases.

 

I hope the above content will be helpful to everyone.

The article is forwarded from the data and cloud public account, the original link

Selected, One-Stop Store for Enterprise Applications
Support various scenarios to meet companies' needs at different stages of development

Start Building Today with a Free Trial to 50+ Products

Learn and experience the power of Alibaba Cloud.

Sign Up Now