Database Reference
In-Depth Information
Chapter 4: Using the RMAN
Recovery Catalog
1.
B, C, E. The recovery catalog provides a means of storing metadata related to a data-
base's RMAN backup and recovery operations. Additionally, it provides the ability to
store scripts that can be used by any database connecting to the repository via RMAN.
Finally, the recovery catalog provides the means to store backup records for longer
than a year.
2.
A. The
RECOVERY_CATALOG_OWNER
privilege is required to create the recovery catalog.
The
DBA
privilege includes
RESOURCE
and
CONNECT
and will work, but this role has many
additional privileges that are unneeded.
SELECT ANY DICTIONARY
is not required.
3.
B. Use the
CREATE CATALOG
command to create the recovery catalog schema.
4.
A, B. Anytime you execute an RMAN backup operation when connected to the recovery
catalog, RMAN will automatically resynchronize the recovery catalog metadata with the
database control file. The
RESYNC
command is used to manually resynchronize the recov-
ery catalog with the database.
5.
D. You would use the
EXECUTE SCRIPT
RMAN command, contained within a
RUN
block,
to execute the
backup_database
script.
6.
C. You would first create the recovery catalog database. Then you create the recovery
catalog user, granting that user the
recovery_catalog owner
role. You then issue the
CREATE CATALOG
command from RMAN, which will create the recovery catalog schema.
Finally, you connect to the target database and register the database with the
REGISTER
DATABASE
command.
7.
D. To give the RVPC user rights to specific databases, you must connect to the recovery
catalog with RMAN. You then grant those rights to that user from the RMAN prompt
using the
GRANT
command.
8.
A, C. The RVPC user can register the database if they are granted the
register data-
base
privilege. They can also see all recovery catalog database metadata to which they
are granted access.
9.
D. The script will prompt for the missing substitution variable. The script will return
an error if you do not put in a value for the second substitution variable.
10.
C, D. Options C and D show the correct format for the RMAN command line. Option C
connects to the database locally, while option D connects through Oracle Net. Both meth-
ods are completely legal.
Search WWH ::
Custom Search