By Porus Homi Havewala, OCM-Oracle on Apr 16, 2014
This detailed technical article explains the set up and scheduling of full and incremental RMAN Database backups for thousands of databases using Enterprise Manager 12c, and how this is done more easily and efficiently than the older, more time-consuming, manual method of performing Unix shell scripting, RMAN scripting, and CRON jobs for each database to be backed up.
And with the Database Group Backup feature new to Enterprise
Manager 12c, it can be even faster to set up RMAN backups for multiple databases - even if there are
thousands - that are part of an Enterprise Manager Database Group (one kind of target group).
The article also highlights the advantages of using Pluggable Databases (PDBs) in Oracle Database 12c and backing them up using RMAN. RMAN cannot backup individual schemas, and it has always been difficult to perform point-in-time-recovery (PITR) at an individual schema level, since schemas can easily be distributed across multiple tablespaces. The advantage in using PDBs in a Container Database is that you can easily set up RMAN backups at the Container Database level, and yet perform PITR at the PDB level. This is a clear technical advantage of the Multi-tenant architecture of Oracle Database 12c.
The set up and scheduling of RMAN database backups forms a part of the Base Database Management features of Enterprise Manager that enables numerous customers to get familiar with the day-to-day use of Enterprise Manager 12c. The full list of Base Database Management features can be found in the Enterprise Manager Licensing Information guide here.
In fact I had personally introduced Enterprise Manager to one of India’s largest financial services organizations in India in 2007 for the purpose of their RMAN backups, they started using it for the first time, and today we are proud to say that they are an Enterprise Manager reference customer who have presented in OOW for the last 2 years. The following slide is from their recent OOW presentation.
One thing I forgot to include in the article (and yes, it is a long article) was on reporting of the RMAN backups. A few readers asked me that question after the article’s publication, both inside and outside Oracle.
I told them that if they were using an RMAN catalog, the catalog would have this information and could easily be queried. If they were not using a catalog, then this backup information would be stored in the control file, and they would have to query each database’s control file (using V$ views) to get the backup report. BI Publisher, installed as an add-on to Enterprise Manager, could be used for this purpose. However note that if BI Publisher is used to query information from a source other than the Enterprise Manager repository database, a license is payable for each database it accesses.
Read the full article at “Back
Up a Thousand Databases Using Enterprise Manager Cloud Control 12c”, and enjoy the world of Oracle Enterprise Manager.
Porus Homi Havewala (OCM 11g/10g).
Twitter | Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager 12c Mobile app