Is creating two catalog databases for primary and standby the proper option, or should I keep a backup of the primary and standby databases on one catalog database? What is the benifit of this?
Personally, I do not back up my standy databases as this is just a backup of my primary. And I do have another backup of my primary. But if you want to be a cautious DBA, and there is nothing wrong in this field with being too cautious, you can back up your standby as well. You can use the same RMAN catalog database so long as this database is not on your primary or standby database server. The big benefit is that you only have one RMAN catalog to administer.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.