Database Reference
In-Depth Information
exeRCiSe 4.1
(continued)
4.
Create the user who will store the catalog:
Use the name
RCAT_USER
with the password
RCAT_USER
.
■
Make
RCAT_DATA
the default tablespace (we assume you have a default temporary
tablespace already defined)
■
Also, you will grant an unlimited quota on
RCAT_DATA
to
RCAT_USER
:
■
SQL> create user rcat_user identified by rcat_user
2 default tablespace rcat_data
3 quota unlimited on rcat_data;
User created.
5.
The recovery catalog-owning user requires only a grant to the
RECOVERY_CATALOG_
OWNER
role using the
GRANT
command:
SQL> grant recovery_catalog_owner to rcat_user;
Grant succeeded.
6.
Test to see whether you can connect to the recovery catalog schema that you have
just created:
SQL> connect rcat_user/rcat_user
Connected.
7.
Now you need to create the recovery catalog schema. To do this, use the
CREATE
CATALOG
command, as shown in this example:
C:\Documents and Settings\Robert>Rman catalog=rcat_user/rcat_user@rcat
Recovery Manager: Release 12.1.0.1.0 - Production on Sun Feb 23 13:30:59 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL12C (DBID=670264325)
connected to recovery catalog database
RMAN> create catalog
recovery catalog created
Using a Recovery Catalog
Using a recovery catalog is pretty straightforward with RMAN. You simply indicate that
you want to connect to the recovery catalog when you start RMAN. You will also have to
register the database before your first RMAN operation when connected to the recovery
catalog. Most RMAN operations when connected to the recovery catalog are pretty much
Search WWH ::
Custom Search