Q

Two catalog databases for primary and standby?

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?

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.
This was first published in December 2006

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close