The Hunger Site

Thursday, June 5, 2014

Two of my EM Articles in top OTN list

Thanks to all my Readers. Ttwo of my OTN articles on using Enterprise Manager 12c for RMAN Backups and Data Guard Standbys are in the top 10 OTN list:



ExaDBA2B said...


I have read your Data Guard paper and your Back Up a Thousand Databases article and enjoyed them both and wanted to thank you and ask a question. We are implementing Oracle Exadata in two data centers as a DR solution. Your Back Up a Thousand Databases recommends using the control file instead of an RMAN catalog. The problem is the 12c Data Guard manual in the RMAN section states

"An RMAN recovery catalog is required so that backups taken on one database server can be restored to another database server. It is not sufficient to use only the control file as the RMAN repository because the primary database will have no knowledge of backups taken on the standby database."

Is it possible to use an RMAN catalog and still use your method outlined to back up a Thousand Databases? All of our databases will also be RAC if that is a concern.

Porus Homi Havewala (પોરસ હોમી હવેવાલા) said...

Thanks. Yes, in the case you mention, taking backups on a standby database, using a Recovery Catalog will be better. You can use the steps in the article, simply define the RMAN catalog first in Enterprise Manager. Also, RAC databases can be handled as well. Good Luck.

Porus Homi Havewala (પોરસ હોમી હવેવાલા) said...

Abiut your next question that was deleted by mistake, since you mentioned you "are not licensed for Active Data Guard yet( hopefully next year). Are we still able to perform our backups on the standby with regular Data Guard while it is performing constant recovery?" Yes, you can. You can google for the instructions for this. The main advantage of Active Data Guard is that you can have the standby open for reporting all the time.


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