Friday, February 13, 2015

Managing Oracle Database 12c with Enterprise Manager – Part IV


We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog posts on this topic, we looked at provisioning 12c Pluggable Databases (PDBs) in a Container Database (CDB) using Enterprise Manager.
As many DBAs are coming to realize, Oracle RMAN backups can be easily set up and scheduled for multiple Oracle databases in Enterprise Manager, it’s all about saving time and effort. Well, now the RMAN wizards in Enterprise Manager can work with Database 12c CDBs and PDBs too.
Move to the Database 12c Target Home Page in Enterprise Manager, and select Availability.. Backup and Recovery.. Schedule Backup from the Database target menu. The following page appears. 
On this Schedule Backup page, you can select either the Whole Database, or the Container Database Root, or the Pluggable Databases to be backed up in an RMAN backup when a Customized Backup is being scheduled.
Here we have selected only two PDBs to be backed up in this Customized Backup.
We can perform either a full backup, or an incremental backup of the selected PDBs.
The RMAN script generated shows the pluggable database backup command. This shows how RMAN also understands the concept of Database 12c CDBs and PDBs.
If this blog post has perked your interest in how Enterprise Manager can help you to set up and schedule RMAN backups for your Oracle databases, then you can study my detailed Oracle Technical Network (OTN) technical article on this topic “Back Up a Thousand Databases Using Enterprise Manager Cloud Control 12c”.
This is a very powerful ability indeed, from my own experience as a Senior DBA in the 1990s and 2000s, having set up RMAN backups both with and without Enterprise Manager. I saved a lot of time and effort doing it the Enterprise Manager way.
In the next blog post, we will look at more Database 12c aware features in Enterprise Manager 12c.
This blog post was originally posted at this link.  

No comments:

Disclaimer

Opinions expressed in this blog are entirely the opinions of the writers of this blog, and do not reflect the position of Oracle corporation. No responsiblity will be taken for any resulting effects if any of the instructions or notes in the blog are followed. It is at the reader's own risk and liability.

Blog Archive