Chat now with support
Chat with Support

NetVault Plug-in for Oracle 11.2 - User Guide

Introducing Quest® NetVault® Backup Plug-in  for Oracle Defining a backup strategy Installing and removing the plug-in Configuring the plug-in Backing up data Using the Oracle® Flashback Database Restoring data
Restoring and recovering data: an overview Performing User Managed restores Using advanced User Managed restore procedures Performing RMAN restores Using RMAN types of recovery in a non-RAC environment Using advanced procedures with RMAN restores
Maintaining the Recovery Catalog Using the RMAN CLI Using the Plug-in with Oracle® RAC Using the Plug-in in a failover cluster environment Using the plug-in with Oracle® Data Guard Troubleshooting

Configuring the Recovery Catalog database

When you use a Recovery Catalog, RMAN requires that you maintain a Recovery Catalog schema. The Recovery Catalog is stored in the default tablespace of the schema. SYS cannot be the owner of the Recovery Catalog. Decide which database you want to use to install the Recovery Catalog schema. Quest recommends that you create a separate database for the Recovery Catalog and run the catalog database in ARCHIVELOG mode.

Next, allocate space to be used by the catalog schema. The size of the Recovery Catalog schema depends on the number of databases managed by the catalog. The schema also grows as the number of archived redo log files and backups for each database increases. For more information on sizing the Recovery Catalog schema, see Planning the Size of the Recovery Catalog Schema in the Oracle® Database Backup and Recovery Advanced User’s Guide.

Creating the Recovery Catalog owner

After choosing the Recovery Catalog database and creating the necessary space, perform the following steps to create the owner of the Recovery Catalog and grant this user the necessary privileges:

Start SQL*Plus, and connect with administrator privileges to the database that will contain the Recovery Catalog.
sqlplus SYS/<password>@<connect_identifier> AS SYSDBA
Grant the RECOVERY_CATALOG_OWNER role to the schema owner.
Grant the CONNECT role to the rman user.

Creating the Recovery Catalog

After creating the catalog owner, create the catalog tables with the RMAN CREATE CATALOG command. This command creates the catalog in the default tablespace of the catalog owner.

> rman CONNECT CATALOG rman/<password>@<connect_identifier_for_catalog>
Run the CREATE CATALOG command to create the catalog.

Registering the target database

The first step in using a Recovery Catalog with a target database is registering the database in the Recovery Catalog.

> rman TARGET / CATALOG rman/<password>@<connect_identifier_for_catalog>

You can register multiple target databases in a single Recovery Catalog, if they do not have duplicate DBIDs. RMAN uses the DBID to distinguish one database from a different database.

In a Data Guard environment, only the primary database is registered in the Recovery Catalog.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating