Which databases are registered in rman catalog

Note that the recovery catalog views are not normalized or optimized for user queries. In general, the recovery catalog views are not as user-friendly as the RMAN reporting commands.

If you have 10 different target databases registered in the same recovery catalog, then any query of the recovery catalog views show the information for all incarnations of all databases registered in the catalog. You often have to perform complex selects and joins among the views to extract usable information about a specific database and incarnation.

Reset Your Password We'll send an email with a link to reset your password. Stay ahead! Get the latest news, expert insights and market research, tailored to your interests. Sign in with email Enter the email address associated with your account. You auth link is expired or incorrect, please try again. Sign up with email Get the latest news, expert insights and market research, tailored to your interests. Usage Notes. RMAN automatically registers a new standby database in the recovery catalog when the primary database for the standby database is registered in the recovery catalog and either of the following conditions is true:.

Do not try to remove these records. Determine the incarnation key of the desired database incarnation. Obtain the incarnation key value by issuing a LIST command:. If the control file of the previous incarnation is available and mounted, then skip to step 6 of this procedure. Otherwise, shut down the database and start it without mounting. Restore a control file from the old incarnation. If you have a control file tagged, then specify the tag.

For example, enter:. Thus, records with status DELETED can appear in the recovery catalog when you upgrade a recovery catalog created prior to Oracle9 i to the current release. For this special case, you can run the prgrmanc. This example connects to the database rcat as user rman :.

Skip Headers. Managing Target Database Records in the Recovery Catalog This section describes how to maintain target database records in the recovery catalog. Use the following procedure: After making sure the recovery catalog database is open, connect RMAN to the target database and recovery catalog database.