Databases Reference
In-Depth Information
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
501 520 ORCL 1316762630 PARENT 1 04-JUL-12
501 502 ORCL 1316762630 CURRENT 1609405 18-JUL-12
2601 2602 CATDB 2337498815 CURRENT 1 20-AUG-12
RMAN>
You can see that only the owner of the base recovery catalog can view the metadata for all the databases
registered in that catalog, unlike the owner of the virtual private catalog, who is restricted to a specific database
or databases.
How It Works
The virtual private catalog is really a set of views and synonyms based on the central or base recovery catalog.
These views and synonyms are copied to the schema of the virtual catalog owner.
The virtual private catalog is a subset of the base recovery catalog to which you can grant access to users in the
recovery catalog database. You can create multiple recovery catalog users, but by default, only the creator of the base
recovery catalog has access to all its metadata. A virtual recovery catalog owner has no access to the metadata of the
entire base recovery catalog.
■
Note
By default, the virtual recovery catalog owner can't access the base recovery catalog.
You must be familiar with the RMAN command
grant
, which lets you assign privileges to database users for
a virtual private catalog. You must first create a virtual private catalog before you can use the
grant
command to
assign privileges on that private catalog to users. The
grant
command lets you grant two important virtual recovery
catalog-related privileges,
register database
and
catalog for database
, which we explain next.
The
catalog for database
privilege shown here grants the virtual catalog user access to a database already
registered in the base recovery catalog:
RMAN> connect catalog rman/rman@catdb
RMAN> grant catalog for database prod1 to virtual1;
By granting the
register database
privilege as shown in the following example, you grant a user the ability
to register new databases in the virtual private catalog and, implicitly, in the base recovery catalog as well:
RMAN> connect catalog rman/rman@catdb
RMAN> grant register database to virtual1;
The
register database
privilege automatically grants the user the
catalog for database
privilege as well.
Once you grant a user the
register database
privilege, that user has the ability to register
new databases
in the
recovery catalog. The virtual private catalog owner can register new databases—that is, databases that aren't part
of the base recovery catalog—by issuing the
register database
command. Any databases that the virtual private
catalog owner registers in this way are also registered automatically in the base recovery catalog.
Even if the virtual private catalog owner has registered a particular database, the base recovery catalog owner
can always unregister that database from the central recovery catalog and thus from the virtual recovery catalog,
which is a subset of the main catalog.
