Databases Reference
In-Depth Information
Just as the
grant
command lets you grant various privileges to the recovery catalog users, the
revoke
command
lets you take those rights away. Here's a summary of the
revoke
command's usage:
catalog for database
clause, you can revoke recovery catalog access to a
database from a user, as shown in the following example:
•
By using the
RMAN> revoke catalog for database prod1 from virtual1;
•
The
register database
clause lets you revoke the ability of a recovery catalog user to register
new databases.
RMAN> revoke register database from virtual1;
•
The
all privileges from
clause, as shown in the following example, helps revoke both the
catalog
and the
register
privileges from a user:
RMAN> revoke all privileges from virtual1;
If you're using an Oracle 10.2 or older release of RMAN, you must perform the following steps to use a
virtual private catalog. Connect to the base recovery catalog as the virtual catalog owner, and execute the
create_virtual_catalog
procedure as shown here:
SQL> execute
base_catalog_owner
.dbms_rcvcat.create_virtual_catalog;
If all your target databases are from an Oracle Database 11.1
g
or newer release, you can omit the previous step.
The step is necessary only if you're planning to use a virtual private catalog with an Oracle Database 10.2
g
or older
release. The step doesn't create a virtual private catalog—you've created the private catalog already. You need to
execute this step before you can use a database belonging to an older release.
Connecting to the Catalog from the Command Line
Problem
You want to connect to the recovery catalog and the target database directly from the operating system command line.
Solution
You always use Oracle Net authentication information to connect to the recovery catalog database, but you can
connect to the target database using either operating system authentication or Oracle Net authentication.
The following example shows how to connect from the operating system command line using operating system
authentication for the target database connection and Oracle Net authentication for the recovery catalog:
[oracle@virtual1 ~]$ rman target / catalog rman/rman@orcl
Recovery Manager: Release 12.1.0.0.2 - Beta on Mon Aug 20 11:29:36 2012
Copyright (c) 1982, 2012, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1316762630)
connected to recovery catalog database
RMAN>
