NetVault Plug-in for Oracle 11.3

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

Create a user and schema for the Recovery Catalog.

For example, enter:

CREATE USER rman IDENTIFIED BY <password>

TEMPORARY TABLESPACE temp

DEFAULT TABLESPACE tools

QUOTA UNLIMITED ON tools;

Grant the RECOVERY_CATALOG_OWNER role to the schema owner.

This role provides the user with all privileges required to maintain and query the Recovery Catalog.

GRANT RECOVERY_CATALOG_OWNER TO rman;

Grant the CONNECT role to the rman user.

GRANT CONNECT TO rman;

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.

Connect to the database that will contain the catalog as the catalog owner.

For example:

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

Run the CREATE CATALOG command to create the catalog.

The creation of the catalog can take several minutes.

If the catalog tablespace is this user’s default tablespace, you can run this command:

CREATE CATALOG;

You can also specify the tablespace name for the catalog in the CREATE CATALOG command. For example:

CREATE CATALOG TABLESPACE <tablespace_name>;

Registering the target database

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

After making sure that the Recovery Catalog database is open, connect RMAN to the target database and Recovery Catalog database.

For example, issue the following command to connect to the catalog database.

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

If the target database is not mounted, mount or open it:

STARTUP MOUNT;

RMAN creates rows in the catalog tables to contain information about the target database. RMAN then copies all pertinent data about the target database from the Control File into the catalog, synchronizing the Catalog with the Control File.

Verify that the registration was successful.

REPORT SCHEMA

Registering multiple databases in a Recovery 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.

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

NetVault Plug-in for Oracle 11.3 - User Guide

Configuring the Recovery Catalog database

Creating the Recovery Catalog owner

Creating the Recovery Catalog

Registering the target database