Databases Reference
In-Depth Information
connected to recovery catalog database
RMAN> grant catalog for database orcl to virtual1;
Grant succeeded.
RMAN>
Note that you must first register the database with the
register database
command (example shown above),
which enrolls the database in the recovery catalog. The
grant catalog
command shown in the example grants the
user virtual1 access to the metadata for just a single database named orcl.
4.
Now that the virtual private catalog owner has access to the metadata for the database orcl,
that user can log in to the base recovery catalog and create the virtual private catalog:
oracle@virtual1 ~]$ rman
RMAN> connect catalog virtual1/virtual1@catdb
connected to recovery catalog database
RMAN> create virtual catalog;
found eligible base catalog owned by RMAN
created virtual catalog against base catalog owned by RMAN
RMAN>
The previous command creates the virtual private catalog for the user VIRTUAL1.You can confirm that the
user
VIRTUAL1
can access only the orcl database (and not any of the other databases registered in the base recovery
catalog) by issuing the following command, after logging in as the user VIRTUAL1
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 20 ORCL 1316762630 PARENT 1 04-JUL-12
1 2 ORCL 1316762630 CURRENT 1609405 18-JUL-12
RMAN>
If you log in as the owner of the base recovery catalog owner and issue the
list incarnation
command,
you'll see the other two databases in the base recovery catalog as well, as shown in the following output:
RMAN> connect catalog rman/rman@catdb
connected to recovery catalog database
RMAN> list incarnation;
