Thanks to all my Readers.
My articles listed in the Top 10 list are:
- Back Up a Thousand Databases Using Enterprise Manager Cloud Control 12c [January 2014]
At Position 3 - Set Up and Manage Oracle Data Guard using Oracle Enterprise Manager Cloud Control 12c [August 2013]
At Position 4
Regards,
Porus.
3 comments:
Porus,
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.
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.
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.
Post a Comment